Check SqlServer Database Load against each Http Urls Load

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?