I'm trying to understand dT SQL query metrics in ado.net (.net/entity framework) scenario. Are counters from ado.net driver location or SQL server side? Do SQL query excution metrics include, e.g., network layer delays?
Answer by Guntars S. ·
So, dT SQL metric like Exec Time is actually sending query to SQL Server + SQL processing + returning results, isn't it? Do you have some documentation where it is explained in detail?
Answer by Andreas G. ·
To add to my last response
The Transaction Based -> Database Measures you see - such as Database Count, Database Time are taken from the PurePath - which is data from within the application. There are some out of the box measures such as overall DB Count and overall DB Time. But you can also create your own measures such as Exec time for a particular SQL.
On top of that - as i said before - you can tap into other resources that give you more system monitoring metrics as as network layer delays, ...
Andi
Answer by Andreas G. ·
In general metrics are captured form within the application. Additionally to these metrics you can however capture any Windows Performance Counters exposed by e.g: SQL Server. For that we have our Windows Performance Monitor
JANUARY 15, 3:00 PM GMT / 10:00 AM ET