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 |
|
asn187
Starting Member
9 Posts |
 Posted - 2007-07-11 : 05:17:39
|
| Hi,I have a legacy sql 2000 database with numerous stored procedure and tables.I need to find out the top 20 most used/accessed tables in the databaseAny one know how i could do this type of trace with profiler? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-11 : 05:42:10
|
| loot at SP:Completed event. when done put the trace into the table and do some stasts._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
asn187
Starting Member
9 Posts |
Posted - 2007-07-11 : 05:55:25
|
| sorry this may seem like a very basic question but the stats that go into a table i have to create it beforehand? but how can i create it without knowing the column types names etc? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-11 : 05:58:37
|
| no you don't have to.when you finish the trace you simply save it to a table which gets created by itself._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
asn187
Starting Member
9 Posts |
Posted - 2007-07-11 : 06:50:03
|
| oh ok then thanks for ur help much appreicated |
|
|
|
|
|
|
Finding the Top 20 most Used/Active tables in a DB