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
