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.
- Hardware Utilization and Performance (Memory, Available Disk Storage, and then CPU Utilization)
- Database and Server Configuration (Database Settings, Database Status, Database Back Up Status - Completion, Max Server Memory Settings)
- Database Maintenance (SQL Server Logs, File Growth, Mirroring Monitor , Back up completion, Index Fragmentation)
Thank You.
Aucun commentaire:
Enregistrer un commentaire