April 16, 2009 at 5:53 pm
Hello, does anyone know of a way to determine how long a query took to run say 3 months ago. I know that there are statistics held within master.sys.dm_exec_query_stats that show this for cached queries however I am wanting to go back much further. Also note that I am *not* after 'jobs' that have run (eg msdb..sysjobhistory). I am specifically interested in queries that have been run from a web application
Many thanks
Travis
April 16, 2009 at 6:46 pm
Nope. Unless you were tracking and logging that information there is no way to go back 3 months ago and see the execution time. In addition the DMV you referenced is for 2005 not 2000.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply