April 17, 2009 at 2:34 am
Hello, I am using SQL Server 2005. 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
I previously by mistake posted this question in the "SQL Server 7,2000 | Performance Tuning" forum (http://www.sqlservercentral.com/Forums/Topic699027-65-1.aspx) - the answer provided in that post was No (i.e. for 2000) however I wondered whether it is possible in 2005
Many thanks
Travis
April 17, 2009 at 3:11 am
Travis (4/17/2009)
Hello, I am using SQL Server 2005. 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 applicationI previously by mistake posted this question in the "SQL Server 7,2000 | Performance Tuning" forum (http://www.sqlservercentral.com/Forums/Topic699027-65-1.aspx) - the answer provided in that post was No (i.e. for 2000) however I wondered whether it is possible in 2005
Many thanks
Travis
check the query and create indexes whenever required.
also update the statistics of the table.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply