Top 10 SQL server Performance tuning tips

Thursday, 3 September 2009

I planned to post some performance tuning steps ,mostly DB design related, for the next 10 days.One each day so that the readers wont get bored.So...Here we go..

Use SQL Profiler

Use SQL Profiler check the Duration, Reads and Writes for each Stored Procedure and for each statement within the stored procedure.Typically Reads should not exceed four times the number of rows returned. If reads are abnormally high then indexes may require a re-look or the query has to be split depending on the complexity.Set the duration filter before running the trace to identify the queries that exceed a specific duration.