Brad's Sure Guide to SQL Server Maintenance Plans (Paperback)

Brad M. McGehee

  • 出版商: Red gate books
  • 出版日期: 2010-01-18
  • 售價: $1,250
  • 貴賓價: 9.5$1,188
  • 語言: 英文
  • 頁數: 288
  • 裝訂: Paperback
  • ISBN: 1906434344
  • ISBN-13: 9781906434342
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on 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. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? 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.

商品描述(中文翻譯)

在他的新書《Brad's Sure Guide to SQL Server Maintenance Plans》中,Brad McGehee帶領讀者全面了解兩個SQL Server工具,這些工具旨在幫助資料庫管理員確保SQL Server實例上進行了“必要最低”程度的維護:維護計劃精靈和維護計劃設計器。

目錄
* 第1章:為什麼資料庫維護很重要?
* 第2章:在創建任何維護計劃之前
* 第3章:使用維護計劃精靈入門
* 第4章:任務排程
* 第5章:檢查資料庫完整性任務
* 第6章:縮小資料庫任務
* 第7章:重建索引任務
* 第8章:重組索引任務
* 第9章:更新統計資料任務
* 第10章:執行SQL Server代理工作任務
* 第11章:歷史記錄清理任務
* 第12章:定義完整備份資料庫任務
* 第13章:定義差異備份資料庫任務
* 第14章:備份資料庫(交易記錄)任務
* 第15章:維護清理任務
* 第16章:使用維護計劃設計器

為什麼要閱讀這本書?
數百萬個SQL Server實例運行在中小型組織的辦公室中,有許多“意外”的資料庫管理員負責維護它們。通常,他們發現自己沒有足夠的知識、經驗或時間來對SQL Server資料庫進行正確的維護,儘管他們可能希望這樣做。這可能導致性能不佳和可用性降低。無論組織的規模如何,如果使命關鍵的數據變得無法使用,業務將受到嚴重影響。

維護計劃精靈和設計器允許您配置和排程11個核心資料庫維護任務,包括完整性檢查、資料庫備份、索引重組和重建等。Brad詳細介紹了每個任務的目的和重要性,以及如何配置每個任務和所有選項的含義,並討論了排程考慮因素:何時以及多久運行任務?還介紹了如何使用設計器自定義和擴展維護計劃。

如果謹慎使用,這些維護計劃工具對於任何資料庫管理員來說都是強大的節省時間的設備。在書的每個階段,Brad清楚解釋了該工具的正確和不正確使用方式,並指出在更高級的解決方案中,使用T-SQL或PowerShell腳本可能更合適。