《SQL Server 2012深入解析与性能优化(第3版) 呈现大量专家建议和实例，指导您在透彻理解SQL Server和Windows内部原理的基础上排除SQL Server 2012故障。通过学习本书，您将能熟练使用具体的故障排除工具，并正确解释工具的输出结果，从而迅速地查找和排除SQL Server所在服务器的各种性能问题。

主要内容

完整介绍查询的生命周期，呈现实际环境中的SQL Server架构

介绍服务器硬件和存储系统，分析SQL Server如何使用内存以及正确的内存配置方式

探讨查询的处理和执行，讲述锁和tempdb数据库的工作原理

分析如何使用故障排除工具针对系统范围的性能问题收集数据、展开分析并找到根源

详述如何使用PowerShell和扩展事件来增强故障排除工具集，以及如何在虚拟环境中管理SQL Server-" SQL Server 2012 in-depth analysis and performance optimization (3rd Edition) presents a large number of expert advice and examples to guide you in a thorough understanding of the basis of failure to exclude SQL Server 2012 and SQL Server on Windows internals. By studying this book, you will be able to skillfully use specific troubleshooting tools, and correctly interpret the output tools to quickly find and remove various server where SQL Server performance issues. The main content of the complete life cycle of a query introduced, showing the actual environment of SQL Server architecture introduces server hardware and storage systems, analytical processing, and discuss how SQL Server uses memory to execute the query and the correct memory configurations, working about locks and tempdb databases Principle of how to use the troubleshooting tools to collect system-wide performance problems for data to analyze and find the root cause of detailing how to use the event to enhance and e