InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:28:55 GMT20http://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxI just validated it, you can get the start time for a statement within a batch by querying sys.dm_exec_sessions. I posted a [url=http://scarydba.wordpress.com/2009/07/28/when-did-this-statement-start/]blog entry on it here[/url].Tue, 28 Jul 2009 09:27:35 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxDo you mean to say that report sql is being repeatedly executed (maybe from diff connections) and you want to find out when this whole thing started ?Tue, 28 Jul 2009 03:15:46 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxI'm not trying to be obtuse, I just don't understand what you are referring to. Do you mean queries coming from Reporting Services?Mon, 27 Jul 2009 11:08:29 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxI mean the Report SQL which is running in the db. I am trying to identify the start time of the report SQL.Mon, 27 Jul 2009 09:53:57 GMTanusharani_chttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxWhen you say SQL, do you mean an individual SQL statement? One that is currently running? I'm not entirely sure, but you may not be able to drill down to that level without capturing statements in a trace. That's one way of doing it, but you would already have to have the trace in place. You couldn't turn it on in a moment's notice.I'll have to test the DMV to see if it records a statement or a batch start time.Mon, 27 Jul 2009 08:25:37 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxMy understanding is ->One SQL sends multiple requests to the db, the start time in dm_exec_* tables all point to the start time of EACH REQUEST, thus at a given point of time, I am unable to determine when the SQL started. Mon, 27 Jul 2009 07:55:14 GMTanusharani_chttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxThis SP gets the start time of the running SQL from system table dm_exec_* and system function dm_exec_sql.My understanding is ->One SQL sends multiple requests to the db, the start time in dm_* tables all point to the start time of EACH REQUEST, thus at a given point of time, I am unable to determine when the SQL started. Mon, 27 Jul 2009 07:54:41 GMTanusharani_chttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxSQL 2005Mon, 27 Jul 2009 07:50:58 GMTanusharani_chttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxFor 2005/2008, take a look at sys.dm_exec_syessions. It will give you a basic breakdown of information for the connections in the system, including start times on the last batch. For more detailed information, take a look at sys.dm_exec_requests. That will give you very specific information about what a process is waiting for, what it's doing, what statement it's on within the batch, etc. In some cases, not all, not even most, it will also show a percent complete, but don't rely on that value in any way. It may or may not be accurate and useful.Mon, 27 Jul 2009 06:54:35 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxCheck this article. See if this helps.[url]http://www.sqlservercentral.com/scripts/T-SQL/66830/[/url]Sat, 25 Jul 2009 01:43:15 GMTvstittehttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxWhat version of SQL Server are running?Sat, 25 Jul 2009 01:38:57 GMTvstittehttp://www.sqlservercentral.com/Forums/Topic759513-360-1.aspxI am creating a stored procedure to identify, and kill a long running Business Objects query in the SQL Server database. I am able to identify the BO SQL iin the database with the BO user id, and also able to check the status "RUNNABLE" in sys_processes table, but last_batch column keeps updating timestamp for EACH REQUEST sent to the DB for the same BO query. Hence, I am unable to identify the start time, and to find out how long the BO SQL has been running. Does anyone know, how can I accomplish this ?Fri, 24 Jul 2009 14:35:55 GMTanusharani_c