Tag Archives: performance

How Statistics impact the performance of SQL Query

In this article I will run through a simple demo which explains how STATISTICS impact the performance. During this Demo, I will use the Number of Logical Reads as performance indicator (More Logical Reads indicates Performance Degrade) Created a new … Continue reading

Posted in Performance, Script, SQL | Tagged , , , , , , | 1 Comment

SET STATISTICS IO ON; SET STATISTICS TIME ON – performance tuning

SET STATISTICS IO ON and SET STATISTICS TIME ON are beautiful ways which can be used while performance tuning individual queries. SET STATISTICS IO ON Enabling STATISTICS IO is very informative as it displays Scan count, logical reads, physical reads, … Continue reading

Posted in Performance, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment

Free eBook on Performance Tuning with SQL Server Dynamic Management Views

Free eBook Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford is available for download at http://www.red-gate.com/community/books/dynamic-management-views. This book talks about DMVs available related to Execution, Transactions, Indexes, I/O, and SQL Operation system. Best part … Continue reading

Posted in Performance, Referene, SQL | Tagged , , , , , , , | Leave a comment

Performance Tuning – Wait Queues

Understanding waiting time of sql requests provides great information while troubleshooting performance issues. The white paper http://technet.microsoft.com/en-us/library/cc966413.aspx provides insight into possible performance problems and troubleshooting methodology. I like these 2 stored procedures described in the article: track_waitstats_2005: http://gallery.technet.microsoft.com/scriptcenter/8c90bd2e-9def-4f44-bce4-e5dae4d86f71 get_waitstats_2005: http://gallery.technet.microsoft.com/scriptcenter/86886b7f-8f75-4052-99d1-ef8ebd910a88

Posted in Performance, SQL, Uncategorized | Tagged , , | Leave a comment