October 5, 2015 at 5:04 am
how to trouble shoot the performance of sql by suing the dmv's in sql 2012/14
October 5, 2015 at 5:15 am
ramyours2003 (10/5/2015)
how to trouble shoot the performance of sql by suing the dmv's in sql 2012/14
Begin by reading these:
David Durant; Stairway to Indexes. A series of well-written articles to take you from beginner to expert. There are fifteen articles each requiring a good hour to read and digest.
http://www.sqlservercentral.com/stairway/72399/
Benjamin Nevarez
Grant Fritchey
http://www.amazon.com/SQL-Server-Query-Performance-Tuning/dp/1430267437/ref=asap_bc?ie=UTF8
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
October 5, 2015 at 6:40 am
I'd take a look at Louis Davidson and Tim Ford's book
Performance Tuning with SQL Server Dynamic Management Views
It's free to download.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply