SQL Server 2012 Internal principles and Troubleshooting (column)

Source: Internet
Author: User
Tags server memory virtual environment

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.