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.


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.
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.