SQL SERVER DBA - Service Improvment Plan (SIP)

Posted on 2011-11-01
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

    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now