We normally run a load test daily for an hour and after that we capture all the DB Statics using SQL diagnostic manager . Is there any way where we can programmatically generate the graphs. Below are the stats that we normally retrieve
1) Database Deadlocks. Select Alerts> select appropriate server and metric as deadlock > select time span and click on search
2) Server statistics: : Goto reports >Analayze> Server Statistics > select DB Server and Time Span and click on Search
3) Similarly we also retrieve the Database statistic
It would be really helpfuly if we can invoke an API and fetch these statistics.
Please do assist in getting these statistics programmatically