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 |
|
jason.a.stewart
Starting Member
1 Post |
 Posted - 2011-01-18 : 13:29:22
|
| running MSSQL 2005.I'm on a performance tuning contract. Customer basically has about 600 DBs with identical design. In each DB there are several hundred very flat tables, with indexes on every single column (never using SPs--only dynamic SQL). Thats the performance problem right there. I can't do anything about the no-SPs issue because they're using PERL DBI in their architecture, so I'm focusing on making the tables efficient.Anyway, I'm trying to approach this systematically, and have run into a snag. I know I can run profiler, grab a trace, drop it into the tuning wizard to give me the most frequently accessed tables, but I'm wondering if there's a faster way to get that data, even in raw form. I'm dealing with 600 DBs and I really don't want to trace and analyze all that. I need the common threads.What I need is basically: tablename, num_of_statements...something I could just run against all DBs, dump to a table and sort.Is there anything? I've been doing this for 10 years and haven't ever needed it. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-18 : 13:55:12
|
| You can query sys.dm_db_index_usage_stats. |
 |
|
|
|
|
|
How to Query most frequently accessed tables