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.

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.