Is there a way to look back several hours and know what query was running on a SQL host monitored by AppInsight for SQL at a point where it may have been having a problem? We do not have DPA. Would that be a requirement for this use case?
Unfortunately, SAM does not hold the top query stuff historically in the database.
Does adding DPA provide that ability?
Yes it does, dpa tracks the number of executions and the total amount of wait for all queries and charts the changes over time.
jameslindsay wrote:Is there a way to look back several hours and know what query was running on a SQL host monitored by AppInsight for SQL at a point where it may have been having a problem? We do not have DPA. Would that be a requirement for this use case?
jameslindsay wrote:
What are you looking to solve? Have you considered adding a Server & Application Monitor Feature Requests ?
I had a DBA ask me if I could tell him what queries were running on a host 2 to 3 hours earlier. The best I could do is go back 1 hour. I get why...I turns into a lot of data when multiplied over 200 SQL servers.
