We're building a server monitor. We would like to keep stats about our SQL Server (among many other servers and hardware) and after, let's say a month, be able to detect at what times during the week our sql servers are slower.
We're facing some timeout issues and would like to detect the best times to run our report generation tools (that do heavy queries). That would be when the servers are not too busy.
Is there a stored procedure we could execute to retrieve those stats? Or monitor it let's say every minute? So we could store the values and get stats from those metrics after a month or two?
Aucun commentaire:
Enregistrer un commentaire