Brad’s Sure Guide to SQL Server Maintenance Plans

Brad’s Sure Guide to SQL Server Maintenance Plans

A comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer.

Publication date: 18 Jan 2010

ISBN-10: 1906434344

ISBN-13: 9781906434342

Paperback: 288 pages

Views: 2,345

Type: N/A

Publisher: Red Gate Books

License: n/a

Post time: 25 Apr 2016 11:00:00

Brad’s Sure Guide to SQL Server Maintenance Plans

Brad’s Sure Guide to SQL Server Maintenance Plans A comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer.
Tag(s): Relational Database
Publication date: 18 Jan 2010
ISBN-10: 1906434344
ISBN-13: 9781906434342
Paperback: 288 pages
Views: 2,345
Document Type: N/A
Publisher: Red Gate Books
License: n/a
Post time: 25 Apr 2016 11:00:00
From the Book Description:

Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don’t have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly.

The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering:

  • The intent of each task and why it’s important
  • How to configure each task and what all the options mean
  • Scheduling considerations: when and how often should you run the task?
  • Customizing and extended your Maintenance Plans using the Designer

Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.




About The Author(s)


Brad McGehee is an Industry speaker, writer, and consultant on Microsoft SQL Server, specializing in SQL Server performance tuning, clustering, and high availability. He is the founder of www.SQL-Server-Performance.Com, and oversaw its growth to 350,000 visits each month. Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, and he is the author or co-author of more than 12 technical books and over 100 published articles. He spends what time he has left with his family in Hawaii. He is a Microsoft SQL Server MVP, MCSE+I, MCSD, and MCT.

Brad McGehee

Brad McGehee is an Industry speaker, writer, and consultant on Microsoft SQL Server, specializing in SQL Server performance tuning, clustering, and high availability. He is the founder of www.SQL-Server-Performance.Com, and oversaw its growth to 350,000 visits each month. Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, and he is the author or co-author of more than 12 technical books and over 100 published articles. He spends what time he has left with his family in Hawaii. He is a Microsoft SQL Server MVP, MCSE+I, MCSD, and MCT.


Book Categories
Sponsors
Icons8, a free icon pack