How do I perform daily, monthly SQL Server 2005 maintenance?
Hardware Utilization and Performance (Memory, Available Disk Storage, and then CPU Utilization)


If your site already has SCOM deployed, use SCOM, as is capable of monitoring SQL Server. Otherwise, pick something off the shelve, eg. Bosun


  Database Maintenance (SQL Server Logs, File Growth, Mirroring Monitor , Back up completion, Index Fragmentation)


Use Ola's Index Maintenance and Backup scripts.