SQL DBA Checklist (SQL Server DBA Activities)

Daily (Routine SQL DBA) Activities

Emergency DBA Activities

Maintenance 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 Procedures
  • Schema level Refresh
  • Database Clone Procedures
  • Providing ad-hoc export dump
  • Blocking Issues and Resolution
  • Deadlock detection and Prevention
  • Updating Statistics
  • Index Usage Monitoring
  • Management History Checks
  • Service startup Configurations
  • Minimal Configurations and Standby
  • Server down Issues
  • Database down Issues
  • Corrupted Databases / Objects
  • Missing Start-up Parameters
  • Blocking Issues - Lock Hints, Audits
  • Deadlock Detection and Prevention
  • Replication Failures
  • Peer-Peer Replication Issues
  • DR Process Issues & Precautions
  • Connection Issues in Cluster Nodes
  • Missing Object Issues & Solutions
  • Missing RIDs / Offsets & SHOWCONTIG
  • Invalid Page Versioning & Page Repairs
  • Views not in Sync, ALTER Issues
  • Missing Indexes & DTA Tool Usage
  • Procedure Execution Issues
  • Job & Alert Failures
  • Policy Based Management (PBM)
  • Always-On Availability Groups (AAG)
  • Patching Activities and Issues
  • Service Pack Issues and Rollbacks
  • Trace Files & user dump files
  • Database & Object Health Checks
  • Configuring Replication & Log Shipping
  • Configuring DB Mirroring For DR & HA
  • Clustering Installation and Issues
  • Load Balancing for Report Generation
  • Database Maintenance Plans Design
  • Resource Governor and management
  • Server Migration and Issues
  • Database Migration and Issues
  • DR Process & Smoke Test Procedures
  • Monitoring Performance Counters
  • Creating KB Articles, SLA & OLA
  • Windows Cluster Management
  • DCOM, COM+, WMI, SCOM & SAN Issues

SQL Server DBA Activities


SQL Server, MSBI (SSIS, SSAS, SSRS) and SQL DBA Training

MSBI (SSIS, SSAS, SSRS)
[+] More Info
  Home  |   T-SQL Training  |   SQL DBA Training  |   MSBI Training  |   About us  |   Testimonials  |    Contact Us   |    Register Today
SQL School certified trainers

Register Today For Free Demo