Why is it not possible to review the collected data for a server that is no longer accessible for some reason?

When a target is unwatched on SQLSentry, it does not show the collected data, it requires watching. However, watching means activating data collection and it should be able to show the old data that has already been collected without any problems when there is no such need.


This situation is mostly impossible when you want to compare the collected data of your old offline server after migrating to a new server.


In addition to this; I was alwayson examining a server at the time of the problem and there was data for 09:00 and I detected the problem with disk waits, disk latency values. Then I did a failover process and unwatched the server whose data I examined and restarted it. Later, when I wanted to see this collected data again to prepare the problem analysis report, it started showing as no data exists. I watched the server but it still did not show the data I had seen before. I think this is a serious problem and should be fixed. Also, there should not be a requirement to watch.

  • Hi Emrah, I'm still looking into this as I just saw your post for the first time. My initial suggestion would be to see if you can access the data that you need via the Reports feature. Does this show what you need to see? You can also invoke the Reports within SSMS, since they're all basically stored procedures. 

    Second, your image of the dashboard doesn't show the time period that you've selected for the instance. But if the instance is not currently monitored, you'll see the info exactly as you have it here. But if you go back to the time the instance was watched, you'll be able to see your data. If you have the Portal set up, you can also see the data there. 

    Let us know if that gets you any further. Cheers!