SQL 2000 on SATA drives

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

icem - 26 May 2005 14:51 GMT

We are considering getting a LeftHand network storage solution to house ous SQL
databases. We are intererested to see if anyone is using SATA for SQL, and
if the performance is acceptable.

Any information would be appreciated.

Thank you.

Reply to this Message

Andrew J. Kelly - 26 May 2005 15:39 GMT

Is this a NAS? If so NAS is not supported for SQL data and log files.

Signature

Andrew J. Kelly SQL MVP

> We are considering getting a LeftHand network storage solution to house
> ous SQL
[quoted text clipped - 5 lines]
>
> Thank you.

Reply to this Message

Leythos - 26 May 2005 18:02 GMT

> We are considering getting a LeftHand network storage solution to house ous SQL
> databases. We are intererested to see if anyone is using SATA for SQL, and
[quoted text clipped - 3 lines]
>
> Thank you.

You have not provided anywhere near enough information to give you a
valid answer.

SATA drives are faster than IDE drives, but, not as fast as UW320 SCSI
drives.

SATA drives can use custom RAID controllers that you can purchase from
vendors that let you build 3,4,5,6 drive RAID arrays.

Without knowing about your specific needs for performance there is no
way to tell if it will work.

Also, anything you do over a network will be slower than the drives you
are installing - even with a GB network.

Signature

--
spam999free@rrohio.com
remove 999 in order to email me

Reply to this Message

Hank Arnold - 27 May 2005 09:39 GMT

Go for SCSI and RAID

Signature

Regards,
Hank Arnold

> We are considering getting a LeftHand network storage solution to house
> ous SQL
[quoted text clipped - 5 lines]
>
> Thank you.

Reply to this Message

Andrew D. Newbould - 28 May 2005 01:01 GMT

>Go for SCSI and RAID

And don't forget that SATA drives, while performance matches SCSI,
generate an awful lot more heat and therefore require VERY good
ventilation within your Server / NAS etc.

The last SATA RAID server I used had TWO 80mm fans directly behind the
rack to keep the three drives cool (forgetting the normal assortment of
other fans) - noisy bugger :-)

Signature

Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com

ZAD Software Systems Web : www.zadsoft.com

Reply to this Message

Leythos - 28 May 2005 20:30 GMT

> >Go for SCSI and RAID
>
> And don't forget that SATA drives, while performance matches SCSI,
> generate an awful lot more heat and therefore require VERY good
> ventilation within your Server / NAS etc.

That's not true, the SATA 10,000 RPM drives are just as hot as the SCSI
10,000 RPM drives, actually, the temp differences come in based on the
vendor and what motor they are using in a particular device.

I have SATA drives that are cool, and ones that are HOT.

> The last SATA RAID server I used had TWO 80mm fans directly behind the
> rack to keep the three drives cool (forgetting the normal assortment of
> other fans) - noisy bugger :-)

Any more, it seems like they are producing drives that are much warmer
than drives of the past - I have taken to always ensuring that we have
front fans, back fans, and PSU fans in all server and workstation cases.
I also try to never purchase variable speed PSU's that based fan speed
on case temp, I've seen them spin way to slow.

Signature

--
spam999free@rrohio.com
remove 999 in order to email me

Reply to this Message

Gert E.R. Drapers - 27 May 2005 16:16 GMT

See ftp://ftp.research.microsoft.com/pub/tr/tr-2003-70.pdf but this is just
using SATA not LeftHand, which is a NAS, which are not supported to run SQL,
see http://support.microsoft.com/default.aspx?scid=KB;EN-US;304261 INF:
Support for Network Database Files (304261)

GertD@SQLDev.Net

Please reply only to the newsgroups.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> We are considering getting a LeftHand network storage solution to house
> ous SQL
[quoted text clipped - 5 lines]
>
> Thank you.

Reply to this Message