Pperformance tuning in sql other than profiler

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts