Execution Time of Stored Procedures In SQL Server

Introduction

When working in SQL Server Stored Procedures, we are keen about the execution time of it. Its very simple to find execution time of stored procedures in SQL Server.

Execution Time

Its simple to figure out the execution time of stored procedures using SET STATISTICS TIME ON.

SET STATISTICS TIME ON
EXEC  [Sales].[pGetSalesDetails]

After executing the above statement, see the messages output window. It will list the execution time taken for the Stored Procedure.

Fig.1 Execution Time taken

Conclusion

In this simple article, we discussed about finding the execution time of stored procedure. I hope you all found this article much useful. We will discuss more simple tricks in our upcoming articles. Please share your feedback in the comment section.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: