Thanks for your response.

Both the systems have statistics updates, there may be little variation in the data. I am not sure of they are structured the same way & index...

I mean the Report SQL which is running in the db. I am trying to identify the start time of the report SQL.

My 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...

This 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...

SQL 2005