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.
Its simple to figure out the execution time of stored procedures using
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.
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