How to find the start time of query in the database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » How to find the start time of query in the...

12 posts, Page 2 of 2

««1 2

How to find the start time of query in the database

Rate Topic

Display Mode

Topic Options

Author

Message

ChiragNS

Posted Tuesday, July 28, 2009 3:15 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

Do 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 ?

"Keep Trying"

Post #760607

Grant Fritchey

Posted Tuesday, July 28, 2009 9:27 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 13,371, Visits: 25,143

I just validated it, you can get the start time for a statement within a batch by querying sys.dm_exec_sessions. I posted a blog entry on it here.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #760862

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions