Hello Everyone,
I am wondering if someone is aware of a way to pull the same data generated by Solar Winds Database Performance Analyzer report using API or SQL query for last 24 hours or any given period of timeCreate
I am looking to pull following data.
Top SQL statements
Total IO Write time
Procedure Cache hit ratio
Buffer Cache Hit Ratio
Active Sessions
OS Memory Utilization
Round trip time
CPU utilization
Page LifeCycle Expectancy
O/S Disk Queue Length
