Monitoring MS SQL Stored Procedure Cache util

Question

Question by Mike T. · Jan 20, 2015 at 12:52 AM ·

Monitoring MS SQL Stored Procedure Cache util

Hi,

One of our customer uses MS SQL2008 R2 and would like to be able to report on the utilization of the Stored Procedure Cache size. They have noticed that application performance decreases when this cache file gets full. Any idea of showing this value in a 6.1 dashboard?

regards, Mike

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-01-20T02:58:17Z

Answer by Andreas G. · Jan 20, 2015 at 02:58 AM

Hi

Dynatrace can capture any Windows Performance Counter using our Windows Performance Monitor. SQL Server is exposing the Stored Procedure Cache Size through a Perf Counter. So - all you need to do is setup a Windows Performance Monitor which will then query that value on a pre-defined schedule, e.g: every 10 seconds. Once this monitor is set up you can put it on a dynatrace dashboard or also use it for alerting

Andi

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Monitoring MS SQL Stored Procedure Cache util

1 Reply

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags