Publisher's Synopsis
SQL Server is one of the great platforms where you can host your database application. Performance Monitoring and Tuning in SQL Server is a continuous process. Today, a particular functionality in your application may work fantastic, however, with the increase in the data volume performance gets slower. You need to continuously monitor the performance of your SQL Server database so that you can avoid any major outage later. So, the question is how do you monitor? Do you perform this activity manually on a daily basis? If yes, then this book is a perfect match for you. Monitoring some common parameters on a daily basis can make a DBA's life easy to a greater extent. Even an experienced DBA can make a mistake. So it is important to automate this activity so that you get to know the status of your database health even when you are off work. This book is also a perfect match for the developers and architects who work with SQL Server daily in one or the other way. This book contains the approach of how to automate the entire database monitoring process. Automation eliminates human errors. So, it is important to collect the database performance metrics automatically by following some steps mentioned in this book.This book talks about the core concept of the SQL Server Query Optimizer so that by knowing this fundamental and important concept developers can write queries in a better way that will help to maintain the database performance at an optimum level. This book also explains about the Parameter Sniffing and how to fix it, what are the causes of performance degradation and how to fix them using some simple methods, update statistics and its importance, indexes, expensive queries, blocking scenarios, deadlock incidents, and resource utilization trend. This book also explains the method of how to automate the database performance metrics collection.After reading this book, Database Administrators and Developers will have the knowledge and skills to use the techniques and tools effectively to monitor and tune the database performance. The areas that are covered are:1)Identifying costly stored procedures or queries2)Identifying blocking and deadlock scenarios3)Understanding Wait Statistics and how wait statistics can help to find the potential bottleneck4)Resource (Disk, CPU, Memory) bottlenecks5)Some important queries that can be used in performance optimization6)Index fragmentation7)Update statistics8)Parameter Sniffing and how to fix it9)How to analyze the execution plan10)How to improve query performance11)How to address Tempdb Contention issues12)Temporary tables Vs Table Variables