Getting Data In

How to get SQL stored procedure execution time?

I have a requirement to get the execution time taken by each of the SQL Server Stored Procedure so that the most time taking SP's can be further optimized.
How do you get this data using dbconnect or Splunk forwarder running on SQL server?

0 Karma

SplunkTrust
SplunkTrust

By themselves, neither DB Connect nor Universal Forwarder can tell you the performance of your database. OTOH, if your database server has the means to record its own performance metrics then either method can be used to get those metrics into Splunk. Use DB Connect if the metrics are stored in a table; use a UF if they're written to a text file.

---
If this reply helps you, an upvote would be appreciated.
0 Karma

Thanks for your response. Can you provide some more details of how to configure SQL server to record the SP performance including its execution time etc. so that Splunk can index the data. Are you taking something custom way to do this or there is a native way in SQL server to enable logging of this data?

0 Karma

SplunkTrust
SplunkTrust

You will have to ask that question of your DBA or on a Microsoft site.

---
If this reply helps you, an upvote would be appreciated.
0 Karma