Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2007-02-12 : 14:14:45
|
| How do you compare SAN drive vs local drive on a 32 bit server? Is it good idea to move my DB files to a SAN instead of local?Canada DBA |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-02-12 : 19:12:40
|
| This Q is too broad.In the disk world, it's just a matter of how much data can be read / written to the storage per time unit.We need specs on how the local disks + SAN are configured in order to give you any answer.Generally a SAN is good because generally it is more fail safe ... generally ...Generally a SAN is good for read because it has a cache ... generally ...Generally for write operations the only thing that matters is the RAID configuration and speed of disks ... generally ...rockmoose |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-12 : 19:54:50
|
| here is a good resource for answering this kind of question. There is SQL code that you can run that will help you benchmark various disk configs. The consensus is really that direct-attach disk is the fastest when you use the absolute fastest drives available and several SCSI adapters. This kind of config (as described in the thread linked below) is more complex than a typical SAN config (for the most part), so YMMV. But, if you need the absolute fastest config, this is the way to go.http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995-ec |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-02-12 : 21:45:27
|
| Microsoft has a little utility called SQLIO that you can use to monitor disk performance. It will let you compare local drive throughput to SAN throughput. A Google search should find it quickly.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-04-03 : 09:41:18
|
| Thanks guys! These posts were very helpful. Especially the link that eyechart sent was wonderful.Canada DBA |
|
|
|
|
|
|
SAN drive speed vs local drive