MSSQL server plugin to get details of stored procedures queries

[kamleshkaler9]

Hey , I went through lots of post till now regarding the monitoring of databases and about the SQL statements . But I haven't found any solution till now . My requirement is very clear ,I want the the queries details that executes inside the stored procedures of the databases. More specifically dynatrace till date can provide the details of methods/stored procedures used by any application . But is it possible to get individual execution time of those queries that get executed inside those stored procedures .Open for discussion and I'm working on such plugin that can resolve my problem . Kindly give your suggestions and feedback...@Radu S. @Radoslaw J.

[skrystosik · Accepted solution]

Plugins are not used for transaction monitoring. This means that you can write plugin that will give you some performance metrics like page life but not transactions inside MSSQL server.

We can only see what left application server and what returned from ado.net. For stores procedures there is now solution.

Sebastian

[kamleshkaler9]

Thanks a lot @sebastian k. for your reply ,it helped me in understanding about the feasibility of my problem statement .

Moreover at server level I'm able to get the execution time of the stored procedures .But if I'm not wrong then this time also includes the network time , But if I want to get the only execution time of the stored procedure excluding network time i.e. time when it hits the database till the time it returns result . Is it possible ?

One more thing I would like to ask that with the below mentioned link , can I create any solution through which I can get the queries of stored procedures .

https://dynatrace.github.io/plugin-sdk/plugins/ruxit_mssql.html

[skrystosik]

For dynatrace, this plugin only gethers performance counters so unfortunately you wont get what you need. You have correct that you have SQL times + response time to application process but this is more important for application performance monitoring than raw db time.

Sebastian

[Babar_Qayyum · Accepted solution]

Hello @kamlesh k.

If you are talking about AppMon then you can use the Database Agent for the SQL execution plan.

A query execution plan is the optimized set of steps used to access data in a SQL relational database management system. It is retrieved from the database cache on demand and is not stored in AppMon.

Note: Stored procedures and functions are supported only for MSSQL

https://www.dynatrace.com/support/doc/appmon/datab...

Regards,

Babar

[kamleshkaler9]

Thank You @Babar Q. for your response but my query was for the current version of dynatrace and oneagent .Moreover at server level I'm able to get the execution time of the stored procedures .But if I'm not wrong then this time also includes the network time , But if I want to get the only execution time of the stored procedure excluding network time i.e. time when it hits the database till the time it returns result . Is it possible ?