May 24, 2007 at 3:38 pm
We store our filegroups on the SAN. I have been reading that to improve performance, put indexes in their own filegroup on another disk, and large tables in their own as well. I am uncertain that this statement is true with the SAN. Is there anyone that can shed some light this for me?
Thanks!
May 24, 2007 at 9:32 pm
The problem with splitting data that way is that it assumes that the workload is evenly distributed across the files. It is rare to actually have accurate information about that, and even if you do, it can change at different times of the day or over time.
I distribute the workload by creating multiple files in a filegroup, and placing one file on each disk. Since the data is more or less evenly distributed across all disks, it tends to balance the IO evenly across all disks without having to spend a lot of time analyzing usage of individual tables or indexes.
May 25, 2007 at 2:15 am
maybe this can help a bit ...
http://www.sql-server-performance.com/ew_san.asp
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 25, 2007 at 9:00 am
It creates more administration and complicates disaster recovery, but it can help. However it's not necessarily a big performance boost:
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
May 25, 2007 at 12:03 pm
great article ALZDBA ... I wish there was more information on ...
Of course there are other factors, such as RAID stripe size, RAID controller CPU utilization, controller caches, data file placement, etc., but they are beyond the scope of this article.
The reason is that we went into all of those areas when configuring our SAN ... a sanity check primer woould have been nice.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply