April 28, 2009 at 12:27 pm
How to find long running query and who is ran before and running now
April 28, 2009 at 12:57 pm
SQL Trace.
See here for setting up and running a trace:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2009 at 1:03 pm
That's in a future, what about finfing what happend last hour?
April 28, 2009 at 1:07 pm
A trace that you already had running....
SQL 2000 doesn't store info on what queries it has run in the past and by who.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply