Exact time of Long running Query

IgnacioJose

Hi is there a way to find out exactly at what time (hours:minutes:seconds) was a long running query executing?

Evan Moss

Hello,

Thanks for your post.

You unfortunately can't see the seconds for the start time, but if you go into alert details, you should be able to see the start minute (listed as "Query start time") and the duration (listed as "Query duration").

Hope that helps.

Thanks,
Evan

faarizamar

A data sheet I picked up at SQL in the City last week shows an Architecture diagram where it indicates the average db size for the repository as 94,000 MB. Is that really the case? What contributes to the size?