December 24, 2003 at 1:54 pm
Merry Christmas to All!
This is actually a second part from previous posting. I had a task to cluster SQL2000 on NAS. And there were a lot of considerations plus or minus NAS, SAN, etc. It turns though that my task is completely different - I'm going to install SQL directly on the NAS. The device is FlexStor M4-16000SF, product of Dynamic Network Factory. Here are some specs: 4 TB storage, 16 drives of 250 SATA in RAID5 together, 2 GB memory for SQL and 1 CPU – Xeon 2.4 GHz, Dual OS drives raid1, 2 gigabit network connection, fibre backbone, Windows 2003 Storage Server. Looks pretty fancy...
Does somebody have an experience running SQL on NAS? The Sales Rep told my boss that there are hundreds of people doing that, but until now I could not find anybody to talk to.
The second question is about the good old practice to separate I/O on different drives/spares. My best experience was with 5 separate spares for OS, Data, temp db, tr. logs, and indexes with heavy usage. If all the drives are raid-ed together although they have their spindles, could I make a separation different then logical partitioning? How I could control I/O in this case?
Any input will be greatly appreciated.
Thanks,
MJ
December 29, 2003 at 8:00 am
This was removed by the editor as SPAM
December 29, 2003 at 11:00 am
Not sure why this was locked, but I unlocked it.
I wouldn't use NAS, barely like using SAN because of the potential contention and access issues. If a large file copy on the network slows SQL access, your DB can easily be marked suspect. Not a big deal, but you then ahve to deal with it.
As far as separation, if you cannot control the spindles, separation may or may not work. Or it may be sporadic.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply