You would probably need to have a profiler session running to record the queries that were run. I keep one running all the time that looks for queries that use 2 or more seconds of CPU. They say that running profiler can cause a performance hit on the server but what I have found is that its impact is minimal and that the trade off I got for identifying the "queries from hell" and getting those cleaned up was worth it. I have been able to greatly improve performance with profiler and also Perfman.
I don't think you would want to capture every single query but if you filter it than you will have a managable amount of data to work with and be able to capyure the bad ones.
Dave
-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Wednesday, July 24, 2002 6:27 AM
To: SQLDBA (E-mail)
Subject: History of Queries
Hi people,
I dont know if this is even possible but, is there any way of telling what
was running at a particular time in the past. ie, this morning at 10:30am I
noticed a huge increase in disk IO for about 5 minutes but would like to
know exactly what was running then.
Thanks!
Meg
**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily of Mondial Assistance (UK) Ltd. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
If you have received this email in error please notify the IT support desk by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please then delete this email and destroy any copies of it. Thank you.
Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ
Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered office as above
**********************************************************************
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page