Pankaj750

Delhi, Delhi, India

Yearly Stats: $4,900 Earned |

Related Services
Skills & Industries
Show your appreciation Others Enjoy This
Comments

Database Administration

Daily

1.Check the SQL Error logs for any errors that may of occured overnight.
2.Check available physsical Diskspace (stored procedure)
3.Check the Event Viewer.
4.Check the jobs for failed completion.
5.Check backups and log sizes.
6.Monitor performance with PERFMON
7.Check for outstanding active or blocked transactions. (stored procedure)

Weekly

1.Run Indexing
2.Run Integrity checks

Monthly
1.Perform monthly security audits on all logins and users to SQL Server.
2.Perform physical disk fragmentation on data drives.

$50 / Hour
$25 minimum budget

2017 Guru.com ©. All rights reserved