MSSQL DBA daily jobs

Daily maintenance jobs:

1. Backup database.
2. Check database integrity: check primary key etc.
3. History cleanup: log history archive.
4. Check indexes: rebuild index, re-organize index etc.
5. Shrink database.

Daily monitoring jobs:

1. Monitor database connections.
2. Monitor physical storage usage.
3. Monitor memory usage: cache hits ratio, page reads, writes/sec etc.
4. Monitor CPU usage.
5. Monitor physical disk I/O, network segment.
6. Monitor error log on critical events: severity level > 16.
7. Monitor user activities: connections, dead lock detection, user security breach, SQL compilation/sec etc.