SQL DBA Checklist (SQL Server DBA Activities)

SQL DBA Activities - Checklist 

Daily (Routine DBA) Activities

§  Auditing Login Failures

§  Monitoring Connectivity Issues

§  Audit Long Running Queries

§  Memory Issues

§  MSDTC and Remote Connection Issues

§  Monitoring IP and Memory statistics

§  Monitoring Jobs & Alerts

§  Monitoring Replication Alerts

§  Monitoring Log Shipping & Mirroring

§  Database Backups Audits

§  Database Refresh

§  Schema level refresh

§  Providing ad-hoc export dump

§  Blocking Issues and Resolution

§  Deadlock detection and Prevention

§  Updating Statistics

§  Index Usage Monitoring

§  Management History Checks

Emergency DBA Activities

§  Service startup Configurations

§  Server down Issues

§  Database down Issues

§  Corrupted Databases / Objects

§  Missing Start-up Parameters

§  Blocking Issues

§  Deadlock detections

§  Replication Failures

§  Peer-Peer Replication Issues

§  DR Process Issues & Precautions

§  Connection Issues in Cluster Nodes

§  Missing Objects

§  Missing RIDs / Offsets

§  Invalid Page Versioning

§  Views not in Sync

§  Missing Indexes

§  Procedure Execution Issues

§  Job & Alert Failures

Maintenance Activities

§  Trace Files & user dump files

§  Database & Object Health Checks

§  Password Resets

§  Configuring Replication

§  Configuring Log Shipping mechanism

§  Configuring DB Mirroring mechanism

§  Clustering Installation and Issues

§  Load Balancing for Report Generation

§  Database Maintenance Plans Design

§  Resource Governor and management

§  Policy Based Management (PBM)

§  Management Data warehouses (MDM)

§  Patching Activities and Issues

§  Service Pack Issues and Rollbacks

§  Server Migration and Issues

§  Database Migration and Issues

§  DR Process & Smoke Test Procedures

§  Monitoring Performance Counters

Other (non SQL Server) Activities

§  DB Management Documentation

§  Creating KB Articles

§  Auditing SLA & OLA

§  DB Report Generation

§  DB History Reports

§  Network Share Management

§  AD Syncup Issues

§  Windows Cluster Management

§  DCOM & COM+ Issues

§  WMI Errors

§  SAN Issues

§  Storage & RAID Issues

§  MOM Monitoring

§  REDGATE Tools

§  Design Tools

§  UML

§  TOAD

§  ERWIN