Practical Maintenance Plans in SQL Server: Automation for the DBA

Bradley Beard

  • 出版商: Apress
  • 出版日期: 2016-04-21
  • 售價: $1,330
  • 貴賓價: 9.5$1,264
  • 語言: 英文
  • 頁數: 272
  • 裝訂: Paperback
  • ISBN: 1484218949
  • ISBN-13: 9781484218945
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)

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

商品描述

This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that’s it, but there is so much more that can and must be done to ensure the integrity of your most important company resource – the data you are tasked to manage and safeguard. This book walks even the newest of users through creating a powerful, automated maintenance plan.

Automate your job using SQL Server Agent to leverage the power of Maintenance Plans to deliver real, proactive solutions to common issues. Schedule common tasks such as backups and index rebuilds to run automatically, and get early-warning notifications of impending problems relating to resource usage and query performance. By the time your boss knows to call you about a problem, you’ll have already called him to describe your solution.

 

The large majority of books never really cover the topic of inheriting a database server with multiple live databases; the common thread is that the databases will be created and maintained by the reader forever and ever. In the real world, that scenario rarely happens. Practical Maintenance Plans in SQL Server covers that scenario and provides you with the knowledge and tools needed to get comfortable writing your own maintenance plans for any SQL Server database, whether created by you or inherited.

  • Shows the different tasks that can be run in a maintenance plan.
  • Explains how and why those tasks can be implemented.
  • Provides a roadmap to creating your own custom maintenance plan.

What You Will Learn
  • Implement a completely automated backup maintenance plan
  • Be alerted to performance problems and outages ahead of your boss
  • Learn the different types of database maintenance tasks
  • Plan the workflow of tasks within a maintenance plan
  • Automate your work by implementing custom maintenance plans
Who This Book Is For
 
Practical Maintenance Plans in SQL Server is for any level of database administrator, but specifically it’s for those administrators with a real need to set up a powerful maintenance plan quickly. New and seasoned administrators will appreciate the book for its robust learning pattern of visual aids in combination with explanations and scenarios. Practical Maintenance Plans in SQL Server is the perfect “new hire” gift for new database administrators in any organization.
 

商品描述(中文翻譯)

這本書是一本完整的指南,教導 SQL Server 資料庫管理員如何建立和維護維護計劃。維護計劃通常只包含備份任務,但實際上還有很多其他必須完成的工作,以確保您所管理和保護的最重要公司資源 - 數據的完整性。本書將引導即使是最新的使用者,逐步創建一個強大且自動化的維護計劃。

使用 SQL Server Agent 自動化工作,利用維護計劃的功能提供實際的主動解決方案來解決常見問題。安排常見任務,如備份和索引重建,以自動運行,並提前警告有關資源使用和查詢性能的問題。當您的上司知道要找您解決問題時,您已經給他打電話描述了解決方案。

大多數書籍很少涵蓋繼承具有多個實時資料庫的資料庫伺服器的主題;共同點是讀者將永遠創建和維護這些資料庫。在現實世界中,這種情況很少發生。《SQL Server 實用維護計劃》涵蓋了這種情況,並為您提供了撰寫自己的維護計劃所需的知識和工具,無論是由您創建還是繼承的任何 SQL Server 資料庫。

本書內容包括:
- 介紹可以在維護計劃中執行的不同任務。
- 解釋如何以及為什麼要實施這些任務。
- 提供創建自己自定義維護計劃的路線圖。

學習內容包括:
- 實施完全自動化的備份維護計劃。
- 在上司之前提前警告性能問題和故障。
- 了解不同類型的資料庫維護任務。
- 計劃維護計劃中任務的工作流程。
- 通過實施自定義維護計劃自動化工作。

本書適合任何級別的資料庫管理員,特別是那些迫切需要快速建立強大維護計劃的管理員。新手和經驗豐富的管理員都會喜歡本書,因為它結合了視覺輔助工具、解釋和實例的強大學習模式。《SQL Server 實用維護計劃》是任何組織中新任資料庫管理員的完美「新人禮物」。