Home Page Icon
Home Page
Table of Contents for
Advertisements
Close
Advertisements
by Amit Banerjee, Gavin Payne, Justin Langford, Glenn Berry, James Rowland-Jones, C
Professional SQL Server 2012 Internals and Troubleshooting
Cover
Contents
Part I: Internals
Chapter 1: SQL Server Architecture
Introduction
Database Transactions
The Life Cycle of a Query
SQL Server’s Execution Model and the SQLOS
Summary
Chapter 2: Demystifying Hardware
The Importance of Hardware
How Workload Affects Hardware and Storage Considerations
Processor Vendor Selection
Choosing and Configuring Hardware for Redundancy
Hardware Comparison Tools
Summary
Chapter 3: Understanding Memory
Introduction
Physical and Virtual Memory
SQL Server Memory
Optimizing SQL Server Memory Configuration
Summary
Chapter 4: Storage Systems
Introduction
SQL Server I/O
Storage Technology
Measuring Performance
Summary
Chapter 5: Query Processing and Execution
Introduction
Query Processing
Query Optimization
Query Plans
Executing Your Queries
Summary
Chapter 6: Locking and Concurrency
Overview
Transactions
Database Transactions
The Dangers of Concurrency
Locks
Lock Escalation
Deadlocks
Isolation Levels
Summary
Chapter 7: Latches and Spinlocks
Overview
Symptoms
Susceptible Systems
Understanding Latches and Spinlocks
Latch Types
Latch Modes
SuperLatches/Sublatches
Monitoring Latches and Spinlocks
Latch Contention Examples
Summary
Chapter 8: Knowing Tempdb
Introduction
Overview and Usage
Troubleshooting Common Issues
Configuration Best Practices
Summary
Part II: Troubleshooting Tools and Lessons From The Field
Chapter 9: Troubleshooting Methodology and Practices
Introduction
Approaching Problems
Defining the Problem
Data Collection
Data Analysis
Validating and Implementing Resolution
Summary
Chapter 10: Viewing Server Performance with Perfmon and The PAL Tool
Introduction
Performance Monitor Overview
Getting More from Performance Monitor
Performance Analysis of Logs
Other PerfMon Log Analysis Tools
Summary
Chapter 11: Consolidating Data Capture with SQLdiag
The Data Collection Dilemma
An Approach to Data Collection
Getting Friendly with SQLdiag
Using SQLdiag Configuration Manager
Employing Best Practices
Summary
Chapter 12: Bringing It All Together with SQL Nexus
Introducing SQL Nexus
Getting Familiar with SQL Nexus
Customizing SQL Nexus
Resolving Common Issues
Summary
Chapter 13: Diagnosing SQL Server 2012 Using Extended Events
Introduction to Extended Events
Getting Familiar with Extended Events
Why you should be Using Extended Events
What are Extended Events?
Creating Extended Events Sessions in SQL Server 2012
Viewing Data Captured by Extended Events
Summary
Chapter 14: Enhancing Your Troubleshooting Toolset with Powershell
Introducing PowerShell
Getting Started with PowerShell
Using PowerShell to Investigate Server Issues
Proactively Tuning SQL Server Performance with PowerShell
Summary
Chapter 15: Delivering A SQL Server Health Check
The Importance of a SQL Server Health Check
Running DMV and DMF Queries
SQL Server Builds
Database-Level Queries
Summary
Chapter 16: Delivering Manageability and Performance
Improve Efficiency with SQL Server Manageability Features
Manageability Enhancements in SQL Server 2012
Policy-Based Management
Other Microsoft Tools for Managing SQL Server
Summary
Chapter 17: Running SQL Server in A Virtual Environment
The Shift to Server Virtualization
An Overview of Virtualization
Why Virtualize a Server?
Common Virtualization Products
Virtualization Concepts
Extended Features of Virtualization
Managing Contention
Identifying Candidates for Virtualization
Architecting Successful Virtual Database Servers
Monitoring Virtualized Database Servers
Summary
Introduction
Advertisements
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Introduction
Visit
www.safaribooksonline.com/wrox
to get started
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset