Check SqlServer Database Load against each Http Urls Load
Hi All,
One of the requirement I got is,
I need to check sqlserver database statistics when a web page gets loaded.
For eg: Through Application manager we can see the statistics of Http URL's counter's.
Using SqlDb Manger we can see the metrics of database counter statistics.
I need to merge this above two(Application Manager & SqlDbManager Plus) .
What I need exactly is when Http url is loaded, I need to store the metrics of sql server counters and need to generate report saying for each page,
Page Load: Bytes Transferred, Received, Sent etc...
For the loaded page: SqlServer Db statictics is , CPU, Memory, Buffer Cache Hit Ratio, Plan Cache Hit Ratio etc...
Please help me how to achieve this.
Thanks,
Kannan.N
New to ADSelfService Plus?