How to analyze troubleshoot IO issues ?
Refer : https://blogs.msdn.microsoft.com/karthick_pk/2012/06/26/io-requests-taking-
longer-than-15-seconds-to-complete-on-file/
How to analyze tackle Writelog issue ?
Refer : https://blogs.msdn.microsoft.com/sqlsakthi/2011/04/16/what-is-writelog-
waittype-and-how-to-troubleshoot-and-fix-this-wait-in-sql-server/
How to analyze CPU issue ?
Refer : https://blogs.msdn.microsoft.com/docast/2017/07/30/sql-high-cpu-
troubleshooting-checklist/
How to analyze memory issue ?
Refer : https://social.technet.microsoft.com/wiki/contents/articles/22316.sql-
server-memory-and-troubleshooting.aspx
SQL Server useful performance counters ?
Attached a file.
Query tuning and indexing tips ?
Refer : https://technet.microsoft.com/en-us/library/ms172984(v=sql.110).aspx
Latch contention .
Refer : https://blogs.msdn.microsoft.com/sqlserverfaq/2010/05/27/monotonically-
increasing-clustered-index-keys-can-cause-latch-contention/
How to analyze Tempdb contention .
Refer: https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-27-of-30-
troubleshooting-tempdb-contention/
Refer: https://support.microsoft.com/en-in/help/2154845/recommendations-to-reduce-
allocation-contention-in-sql-server-tempdb-d
A detailed look into deadlock ?
Refer : https://blogs.msdn.microsoft.com/bartd/2006/09/08/deadlock-troubleshooting-
part-1/
MAXDOP best practices .
Refer : https://support.microsoft.com/en-in/help/2806535/recommendations-and-
guidelines-for-the-max-degree-of-parallelism-confi
In-depth memory architecture .
Refer : https://blogs.msdn.microsoft.com/sqljourney/2012/12/16/an-in-depth-look-at-
sql-server-memorypart-1/
Index internals .
Refer: https://technet.microsoft.com/en-us/library/jj835095(v=sql.110).aspx
SQL server query timeouts. Attached file .
Back up restore troubleshooting . File attached .
Server performance and monitoring .
Refer : https://docs.microsoft.com/en-us/sql/relational-
databases/performance/server-performance-and-activity-monitoring?view=sql-server-
2017
ReadTrace or RML Utilities: http://www.microsoft.com/downloads/details.aspx?
FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en (needed to install
SQLNexus, also can be used to analyze profiler traces)
SQLDiag Utility (general purpose diagnostics collection utility with profiler
traces) - http://msdn.microsoft.com/en-us/library/ms162833(SQL.90).aspx
Performance Dashboard Reports (Precursor to SQL Server 2008 Activity Monitor) -
http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-
e419218c1efc&displaylang=en
Performance Dashboard Reports for SQL 2012 (also for 2008/2008 R2) -
http://www.microsoft.com/en-us/download/details.aspx?id=29063
Database Engine Tuning Advisor - http://msdn.microsoft.com/en-
us/library/ms173494(SQL.90).aspx
AlwaysOn latency issue .
Using perfmon 1 : https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/21/sql-
server-2012-alwayson-part-11-performance-aspects-and-performance-monitoring-i/
Using perfmon 2 : https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/24/sql-
server-2012-alwayson-part-12-performance-aspects-and-performance-monitoring-ii/
Using extended events :
https://blogs.msdn.microsoft.com/psssql/2018/04/05/troubleshooting-data-movement-
latency-between-synchronous-commit-always-on-availability-groups/
Redo queue issue :
https://blogs.msdn.microsoft.com/alwaysonpro/2015/01/06/troubleshooting-redo-queue-
build-up-data-latency-issues-on-alwayson-readable-secondary-replicas-using-the-
wait_info-extended-event/
Latency reports : https://blogs.msdn.microsoft.com/sql_server_team/new-in-ssms-
always-on-availability-group-latency-reports/
Troubleshooting SQL server alwayson configuration issue � file attached
