Book description
Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.
Introduces new administration features of SQL Server 2008
Shows how to manage a SQL Server 2008 database at professional level
Provides guidance on performance optimization
Table of contents
- Cover Page
- Title Page
- Copyright
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
PART 1 Introducing Microsoft SQL Server 2008
- CHAPTER 1 New Feature Overview
- CHAPTER 2 Pre-Installation Considerations
- CHAPTER 3 Choosing a High-Availability Solution
-
PART 2 Getting Started
- CHAPTER 4 Installing Microsoft SQL Server 2008
- CHAPTER 5 Upgrading to Microsoft SQL Server 2008
-
CHAPTER 6 Post-Installation
- SQL Server Configuration Manager
-
Configuring the Instance
- Viewing Advanced Options
- Viewing Configuration Settings
- Specifying Maximum and Minimum Server Memory
- Enabling Address Windows Extensions
- Specifying the Backup Compression Default
- Enabling Login Failure Auditing
- Enabling Dedicated Administrator Connections
- Disabling Default Trace
- Enabling Use of the CLR (Common Language Runtime)
- Choosing Lightweight Pooling
- Enabling a Query Governor Cost Limit
- xp_cmdshell
- Miscellaneous Configuration Options
- Preproduction Tasks
- Summary
-
PART 3 Administering Microsoft SQL Server 2008
- CHAPTER 7 Multi-Server Administration
- CHAPTER 8 Managing Security Within the Database Engine
- CHAPTER 9 Administering Database Objects
- CHAPTER 10 Indexing for Performance
- CHAPTER 11 Managing Backups
- CHAPTER 12 Restore and Recovery Strategies
- CHAPTER 13 Automating Routine Maintenance
-
PART 4 Troubleshooting and Tuning
-
CHAPTER 14 Monitoring Your Server
- Baseline Your Server
- Familiarizing Yourself with the Performance Monitor
- Monitoring Your CPU
- Monitoring Your Memory
- Monitoring Disk IO
- Monitoring Miscellaneous Counters and DMVs
- Capturing SQL Server PerfMon Counters Using DMVs
- Leveraging the SQL Server Profiler
- Using Server-Side Tracing
- Automating Your Monitoring
- Summary
- CHAPTER 15 Auditing SQL Server
-
CHAPTER 16 Managing Query Performance
- Correlating Profiler and the Performance Monitor
- Finding Similar Queries
- Running the Standard Performance Reports
- Optimizing for Specific Parameter Values
- Forcing Index Seeks
- Forcing a Specific Execution Plan
- Adding Hints Through Plan Guides
- Managing Resources with the Resource Governor
- Monitoring Resource Governor
- Summary
-
CHAPTER 14 Monitoring Your Server
- PART 5 Conclusion
- Index
Product information
- Title: Pro SQL Server 2008 Administration
- Author(s):
- Release date: August 2009
- Publisher(s): Apress
- ISBN: 9781430223733
You might also like
book
Beginning SQL Server 2008 Administration
Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …
book
Microsoft® SQL Server 2008 R2 Unleashed
This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. …
book
Microsoft® SQL Server® 2008 Internals
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team …