We would like to build our own chart in dashboard to display - connection pool size, usage, max & min pool usage, acqu avg, acqu max and fail% (the information we see from dashbase dashlet - pool usage). Which method or sensor should we set up to get these data then create own dashboard? We want to create own dashboard and alerts.
Answer by Rick B. ·
Ah, OK. Please Edit your System Profile and go to the Measures dialog. Click Create and browse to Server Side Performance -> Agent Based Measures -> ADO.NET and select the appropriate measures with the appropriate database.
This should give you what you need for the pool usage stats, as for the acquistion times and failure rates per pool there is not a way to chart this as of now.
JANUARY 15, 3:00 PM GMT / 10:00 AM ET