Pperformance tuning in sql other than profiler

Posted by Vishalneeraj-24503 under Sql Server on 7/16/2017 | Points: 10 | Views : 283 | Status : [Member] [MVP] | Replies : 1
Hi All,

How to do performance tuning in SQL server other than profiler and index tuning wizard.

Suppose one SP is running very very slow and there are 5000+ line of code inside that SP. What will be my first approach to rectify issue. What steps should i follow to accomplish.




Responses

Posted by: A2H on: 7/16/2017 [Member] [MVP] Silver | Points: 25

Up
0
Down
Please check the below options mentioned in this link : http://www.sqlservergeeks.com/improve-stored-procedure-performance-in-sql-server/

Recently I had performance issue with one of the stored procedure. Changing the stored procedure operations to set based has greatly improved the performance.

Thanks,
A2H
My Blog

Vishalneeraj-24503, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response