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 |
|
tolnep
Starting Member
1 Post |
 Posted - 2009-01-16 : 09:26:35
|
| SQL Server 2005 32 Enterprise, Win2k3 SP1. C Drive RAID 10 local, D, E RAID 10 on EMC Clariion, G Drive (new) 5 spindle RAID 5 on Clariion. Majority of acccess is read on the db.The G drive was added recently due to increased workload by users and additional workload added to this server. Being pretty familiar with the apps on this server, I moved a few very busy tables. I would now like to move some more to balance the load. I use latency (transfers and reads) as the balancing factor.I would like to be able to identify individual tables and indexes as being candidates for moving to the new drive. Is there any perfmon object or DMV query that shows access by table? Used to work on a mainframe and i had the capability (Tandem now HP Nonstop). I miss this metric..I already know how to ID sql statements and sprocs and total IO counts and execution counts and then look into those to find accessed tables. Looking for something with more 'teeth' than this method.thanks for any info.. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 10:25:27
|
| Didn't get your actual requirement? |
 |
|
|
|
|
|
perfmon or DMV or other to find busiest table?