Link to home
Start Free TrialLog in
Avatar of mcsglobal
mcsglobalFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Profiler

I am trying to look at a performance issue within SQL and need to be able to monitor what tables are being opened within SQL at a given time , I have been using SQL Profiler but cant seem to work out how I can get a list of tables being opened at a certain time , I need to basically run a test on my database and at a certain point start the profiler and then list just what tables are being opened then stop SQL Profiler , Anyone any ideas on how I can do this , I will want to capture the list over about a 15 min time period
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mcsglobal

ASKER

Thankyou Vitor ,

I was thinking it needed to be more complicated than that but it gives us what we needed

Thankyou
Keep it simple ;)