SQL SERVER DBA - Service Improvment Plan (SIP)

Posted on 2011-11-01
Medium Priority
Last Modified: 2012-05-12

Please share some advanced SIP plans for (DBA prospective) sql server 2005\2008. The SIP plans must save DBA time or production time.

I have implemented below mentioned SIP's in my current environment. Is there any other new\advanced SIP's for DBA?
1. Automated backup status report - using tsql code
2. Automated disk space report - using tsql code and powershell
3. Job status report (Index rebuild\checkdb\Statistics update)

Thanks in Advance.
Question by:sg05121983
LVL 15

Accepted Solution

Anuj earned 2000 total points
ID: 37062133
Add this to your list

Physical file fragmentation report.
Server Report - Hardware and SQL Server configuration for Instance wise.
Database file management report -  Includes both data file and log file size, Growth report.
tempdb growth and performance report.
Index maintenance report  - Includes Fragmentation, duplicate index, rebuild strategy.
Statistics report - About the statistics update.
Msdb Maintenance report - Includes purging old jobs, SSIS package reports, and job running on the server.
Job Reports - Job complete status reports on the server.
Linked server report -
Audit Failure Login report - details about failed login.
Security Report - At database and server level, adding and removing logins also.
DDL change report - DDL changes in the database.
Long running query report - Query that executes for long time comparing your baseline.
Downtime report - regarding how the downtime occurred and the how you prevented it from happening in future.
Service pack update reports - both sql server and windows service packs.
High availability reports - Replication, log-shipping clustering, mirroring


Author Closing Comment

ID: 37080196

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question