Establish policies and
procedures for database management, security, and utilization
1) Monitoring of Space in server
email alerts
2)Monitoring of successful completion
of jobs- failure email.
3)Monitoring successful completion of
backups- failure email
4) Weekly or Monthly rebuild of
indices
5)Weekly Running of Fragmentation
Reports
6)Daily Checking of Database
Integrity- DBCC CHECKDB(‘MYDATABASE’)
7)Making sure statistics are
update-auto stats-set to true.
8) Daily checking of error logs
9)Daily checking if Agent is up and
running
10) Creating
a master list of all servers
List all jobs and time
they run.
11)
Jobs
for clearing all old log files
12)
Monthly
deletion of old backups which you may have stored
13)
Monitoring
if Transaction log, full and differential backups are going fine.
No comments:
Post a Comment