February 7, 2006 at 11:03 am
How can we see if a table is been used heavily in a prodn environment. This has to be done with very limited access to the prodn box. I have only read access to these tables, can run sqls like sp_who, splock and so on but is there any easy way to figure out when and how the table is been used. ANy help is greatly appreciated.
TIA
February 7, 2006 at 12:54 pm
If you can Run Profiler.
Create New trace, Save data to sql table in another database.
choose Events and data columns you are interested in,
and finally Choose Filter :-> TextData like '%table Job%'
run this for some time than analyse the use through
query analyser by t-sql
select * from dbname..tracetable
Hope this helps.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply