Viewing running queries at point in time

SQL Server performance monitoring and alerting

Viewing running queries at point in time

Postby AndyReilly » Wed Apr 09, 2014 5:07 pm

Hi,

I'm very new to SQL monitor and I just wanted to know if it's possible to find what queries where running at a particular point in time, so if I encountered a problem on the server - I could then look back to see what was happening just before the issue occurred?

Regards
Andy
AndyReilly
 
Posts: 2
Joined: Wed Apr 09, 2014 4:54 pm
Location: United Kingdom

Postby chriskelly » Fri Apr 11, 2014 11:11 am

This document explains the Back-In-time feature
https://documentation.red-gate.com/disp ... +Time+mode

This can be used in conjunction with generated alerts to view captured queries.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 368
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Cool - Just what I needed

Postby AndyReilly » Wed Apr 16, 2014 9:04 am

Thanks :D :D
AndyReilly
 
Posts: 2
Joined: Wed Apr 09, 2014 4:54 pm
Location: United Kingdom


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests