mercredi 21 octobre 2015

How do I perform daily, monthly SQL Server 2005 maintenance?

Team,

I have SQL Server 2005 and I am new to DBA role and wondering if there is any T-SQL Script/Stored Procedure out there that they will help me accomplish the following on regular basis - Daily, Weekly, Monthly Yearly.

  1. Hardware Utilization and Performance (Memory, Available Disk Storage, and then CPU Utilization)
  2. Database and Server Configuration (Database Settings, Database Status, Database Back Up Status - Completion, Max Server Memory Settings)
  3. Database Maintenance (SQL Server Logs, File Growth, Mirroring Monitor , Back up completion, Index Fragmentation)

Thank You.

Aucun commentaire:

Enregistrer un commentaire