SQL Server Performance Tuning and Optimization – Must Read Links!

It’s been long time, I have been working on this subject and have also written many posts to share my learning with the SQL community. Here are few links from my website which every viewer must go through:

Managing SQL Performance Proactively
*****************************************
Amazing SQL server tools every DBA must have!!! – Part 1 – https://dbcouncil.net/2013/06/25/amazing-sql-server-tools-every-dba-must-have-part-1/

Amazing SQL server tools every DBA must have!!! – Part 2 – https://dbcouncil.net/2013/06/25/amazing-sql-server-tools-every-dba-must-have-part-2/

Configure SQL Agent Alerts to notify SQL Performance issues – https://dbcouncil.net/2012/01/04/configure-sql-agent-alerts-to-notify-the-performance-issues/

Recommendations for optimal indexing for SQL server tables! – https://dbcouncil.net/2014/06/27/sql-server-is-my-table-indexing-optimal-2/

Strategy for tuning SQL server VLDB – https://dbcouncil.net/2014/04/17/strategy-for-tuning-vldb/

SQL server table partitioning : Have you chosen a right partition column? – https://dbcouncil.net/2014/04/08/table-partitioning-have-you-chosen-right-partition-column/

 

Troubleshooting SQL Performance Issues
*****************************************************
SQL Server : How can you say It’s memory pressure? – https://dbcouncil.net/2012/07/09/sql-server-how-can-you-say-its-memory-pressure/

Troubleshooting SQL Server High CPU issues without profiler traces – https://dbcouncil.net/2011/12/14/troubleshoot-high-cpu-issue-without-using-profile-traces/

Configure PSSDIAG to capture high CPU issues – https://dbcouncil.net/2012/02/18/configure-pssdiag-to-capture-high-cpu-issues/

Analyzing PSSDIAG logs without using SQLNEXUS – https://dbcouncil.net/2012/03/23/analyzing-pssdiag-logs-without-using-sqlnexus/

WriteLog waittype impacting SQL Server Performance – https://dbcouncil.net/2011/12/22/writelog-waittype-impacting-sql-server-performance/

SQL server 2005 can’t leverage more than 64 processors. Can it? – https://dbcouncil.net/2012/02/23/sql-server-2005-cant-leverage-more-than-64-processors-can-it/

 

 

HTH!