AllThe Essential DBA Playbook for Optimized SQL Server Management
The Essential DBA Playbook for Optimized SQL Server Management
The Essential DBA Playbook for Optimized SQL Server Management
Abstract
Whether you’re taking a position as a DBA at a new company or you’ve been
with your current company for years, you may be facing the same challenge:
not having the optimal hardware, software, workflow or culture you need to
run a smooth environment. In fact, it’s often quite the opposite: the department
may have poor security practices, nonexistent disaster recovery plans, poor
documentation and substandard hardware or network configuration. Then
there are the cultural or organizational challenges: poor management, underresourced departments or poorly thought-out processes.
While it would be impractical to formulate a strategy for every possible situation,
you can put in place a handful of strategies to overcome panic and methodically
focus on issues within your control. “The Essential DBA Playbook for Optimized
SQL Server Management” explains how, in three chapters:
• Chapter 1: Assessing Your SQL Server Environment — The first step is to
assess the SQL Server environment. An initial database infrastructure status
check is necessary for sustained, optimized database management.
• Chapter 2: Establishing Effective Backup and Recovery — The next step is to
establish effective backup and recovery, keeping in mind high availability and
disaster recovery best practices.
• Chapter 3: Ongoing SQL Server Management Optimization — Finally, you
need to maintain your optimization efforts by communicating effectively,
stabilizing the environment and taking advantage of automation.
This e-book covers assessing your SQL Server environment.
III
2015 Dell. All rights reserved. | Share:
Chapter 1
Assessing Your
SQL Server
Environment
1
2015 Dell. All rights reserved.
Please complete the form to gain access to this content
