How to get wait stats of a MS SQL DB procedure /query in a pure parh of a web request
I am new to Dynatrace,using trial , how can i get 'wait stats' on a query or procedure which is shown in a pure path.
Hi Singh
This type of data is currently not captured. dynaTrace captures SQL Executions based on ADO.NET or JDBC interface methods which are called by our application. The stats you are referring to are - based on my knowledge - stats that SQL Server itself would provide. As we do not yet have an agent that extends all the way into SQL Server we cant give you these metrics along the PurePath.
You need to go to SQL Server for this, e.g: use SQL Server Manager Tools to analyze these statements.
One option you do have with dynaTrace is to pull in certain Windows Performance Counters which are provided by SQL Server. For that dynaTrace offers its Monitor Plugins to query any type of Windows Performance Counters. I dont think SQL Server exposes these metrics per SQL Statement - but - you should be able to get some high level performance statistics. For more information check out SQLServer Monitoring Plugin
EMEA Community Member of the Month - November 2018
Announcing Dynatrace's EMEA Community Member of the Month for November 2018, Mathieu C.! Click here to read more! LATAM Community Member of the Month - November 2018
Announcing Dynatrace's LATAM Community Member of the Month for November 2018, Rene S.! Click here to read more! 