SQL DBA| Top 10 DBA Tasks and DBA Tool | MS SQL DBA Training

For Details Visit Us: https://www.techpledgeconsulting.com/
Email: [email protected]
Whats up: +91-7676-7 03-141
this list suggests 10 critical tasks SQL Server DBAs must do every day, towards ensuring healthy databases and SQL Server instances.

Here’s my list:

Check SQL Server Instance Up-time
Check Last Full, Differential and Log Backup Times
Check Failed SQL Agent Jobs in the Last 24 Hours
Check Current Log for Failed Logins
Check for Blocked Processes
Check Top N Queries Based on Average CPU Time
Check Drive Volumes Space
Check Index Fragmentation
Patch Management
Self-Education and Improvement

Comments are closed.