SQL Server 2012 Internal principles and Troubleshooting (column)

PROFESSIONAL SQL SERVER? Internals and Troubleshooting a book (downloadable from here), I think the content is very good. I also want to have a more comprehensive understanding of SQL Server 2012, so look at the translation, and the focus of the content published in the blog. Here is a link to the relevant blog, I hope to bring you a little help. Because of the limited personal ability, if there is a wrong translation, please correct and exchange!

First part internal principle (internals)

Chapter One SQL Server schema

• Database transaction: http://blog.csdn.net/burgess_liu/article/details/17553407
• The life cycle of the query: http://blog.csdn.net/burgess_liu/article/details/17558663
  http://blog.csdn.net/burgess_liu/article/details/17609599
• Execution mode and sqlos:http://blog.csdn.net/burgess_liu/article/details/17691489 for SQL Server
• Summary: http://blog.csdn.net/burgess_liu/article/details/17710139

Chapter II Secret Hardware

• Hardware disclosure: http://blog.csdn.net/burgess_liu/article/details/17712705

Chapter III Understanding Memory

• Physical and virtual memory: http://blog.csdn.net/burgess_liu/article/details/17733149
• SQL Server memory: http://blog.csdn.net/burgess_liu/article/details/17739725
• Optimizing SQL Server memory configuration: http://blog.csdn.net/burgess_liu/article/details/17757655

Fourth Chapter Storage System

• SQL Server I/o: http://blog.csdn.net/burgess_liu/article/details/17786129
• Storage technology: http://blog.csdn.net/burgess_liu/article/details/17952595
  http://blog.csdn.net/burgess_liu/article/details/17990973
  http://blog.csdn.net/burgess_liu/article/details/18260867
• Measurement performance: http://blog.csdn.net/burgess_liu/article/details/18325209
  http://blog.csdn.net/burgess_liu/article/details/18358361

Fifth. Query processing and execution

• Query processing: http://blog.csdn.net/burgess_liu/article/details/18593893
• Query optimization: http://blog.csdn.net/burgess_liu/article/details/18602471
  http://blog.csdn.net/burgess_liu/article/details/18729109
• Query plan: http://blog.csdn.net/burgess_liu/article/details/18812633
• Query execution: http://blog.csdn.net/burgess_liu/article/details/18839385

Sixth Zhang Yi and concurrency

• Risk of Concurrency: http://blog.csdn.net/burgess_liu/article/details/18978093
• Lock: http://blog.csdn.net/burgess_liu/article/details/19067719
• Isolation level: http://blog.csdn.net/burgess_liu/article/details/19397391

Seventh Zhang and Spin Lock (Latch&spinlock)

• Symptoms: http://blog.csdn.net/burgess_liu/article/details/19540293
• Understanding Latch and spinlock:http://blog.csdn.net/burgess_liu/article/details/19545473
• Types and patterns of latch: http://blog.csdn.net/burgess_liu/article/details/19607151
• Monitor latch and spinlock:http://blog.csdn.net/burgess_liu/article/details/19820095

Eighth. Understanding tempdb

• Overview and Usage: http://blog.csdn.net/burgess_liu/article/details/19974923
• Troubleshoot daily issues: http://blog.csdn.net/burgess_liu/article/details/20030715
• Configuration Best Practices: http://blog.csdn.net/burgess_liu/article/details/20109295

The second part of the troubleshooting tools and the use of relevant tools and lessons learned

10th. viewing server performance using Perfmon and PAL tools

• Perfmon Getting Started Guide: http://blog.csdn.net/burgess_liu/article/details/20484405
• Get more useful information from Performance Monitor: http://blog.csdn.net/burgess_liu/article/details/20525659
• Performance analysis of logs: http://blog.csdn.net/burgess_liu/article/details/20551987
• Other Perfmon log performance analysis tools: http://blog.csdn.net/burgess_liu/article/details/20563975

The 11th chapter uses SQLDIAG to merge data collection

• First knowledge of sqldiag:http://blog.csdn.net/burgess_liu/article/details/20614571
• Using SQLDIAG Configuration Manager: http://blog.csdn.net/burgess_liu/article/details/21612515
• Best Practice: http://blog.csdn.net/burgess_liu/article/details/22052209

12th chapter using SQL Nexus Integration

• Familiarity with SQL nexus:http://blog.csdn.net/burgess_liu/article/details/22093135
• customizing SQL nexus:http://blog.csdn.net/burgess_liu/article/details/23909625
• Solve daily problems: http://blog.csdn.net/burgess_liu/article/details/24307671

13th. Using extended events to diagnose SQL Server 2012

• Using extended events to diagnose SQL Server 2012:http://blog.csdn.net/burgess_liu/article/details/24668891
• Create extended events session in SQL Server 2012: http://blog.csdn.net/burgess_liu/article/details/25119701
• View data captured by extended events: http://blog.csdn.net/burgess_liu/article/details/28606425

14th. Using PowerShell to enhance the troubleshooting capability

• Getting Started with PowerShell: http://blog.csdn.net/burgess_liu/article/details/31373671
• Using PowerShell to investigate server issues: http://blog.csdn.net/burgess_liu/article/details/36624925
• Using PowerShell to tune SQL Server performance: http://blog.csdn.net/burgess_liu/article/details/36644117

15th Chapter SQL Server Health Check

• SQL Server Health Check: http://blog.csdn.net/burgess_liu/article/details/36654597

16th Chapter Management and performance

• Management and performance: http://blog.csdn.net/burgess_liu/article/details/37506493

17th. Running SQL Server in a virtual environment

• running SQL server:http://blog.csdn.net/burgess_liu/article/details/37654829
in a virtual environment