February 4, 2005 at 10:48 am
Hi,
Is there any way using Profiler, Perfmon, or a script to find how often individual tables and indexes are used? I want to break up a database with heavy read/write activity, but I'm not familliar with the application yet and I don't know which tables are the most active.
Thanks
Charlie
February 4, 2005 at 12:20 pm
With SQL Profiler, you can set up traces to capture information of your interest.
You can select based on event classes.
(i.e. Stored procedures, TSQL, Objects event classes .etc. provide information related to database objects being accessed.)
February 4, 2005 at 12:29 pm
I see that a column ObjectID can be included, but this appears to just give the object ids for stored procedures. I'm looking to track tables. Is there any way to do this? (other than looking for table names in the TextData column)
February 28, 2010 at 4:56 pm
Hey
I've attached a script that may help you. It shows all the indexes in the selected database and orders them by the user_seeks which is basically how many times they have been used by user queries. It also shows the table name which they are attached to, so you could effectively use the results to work out which tables have been used the most.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply