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 |
|
agrikk
Starting Member
2 Posts |
 Posted - 2011-11-29 : 19:13:28
|
| I have a SQL Server 2008 R2 server with 4 SAN volumes whose access patterns are very lopsided in terms of disk I/O that I am trying to even out.On my database server I have databases set up typically with a single filegroup which contains four database files, one placed on each volume (E:, F: G:, and H:). When running a query, volume E: gets hammered and its Average Disk Queue Length hits an average of 700, while the other volumes hover between 30 and 150.How do I determine what process is causing so much I/O on the disk?Is there a way to "rebalance" the data in a database such that I/O is more evenly distributed across the four volumes? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agrikk
Starting Member
2 Posts |
Posted - 2011-11-30 : 01:35:00
|
| How about if there are multiple databases, each with a filegroup of four files (one on each volume)? Is there a way to tell which is causing the most I/O? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Balance data access (and Disk I/O) across volumes?