Getting Data In

How to get SQL stored procedure execution time?

santosh_sshanbh
Path Finder

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

richgalloway
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, Karma would be appreciated.
0 Karma

santosh_sshanbh
Path Finder

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

richgalloway
SplunkTrust
SplunkTrust

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

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...