DBAs play a major role in the everyday operation of any organization that uses databases. However, the term “healthy database” is often misinterpreted.
In the databases world, a healthy database is not just a database that is online and is not corrupted.
A healthy database, and consequently an RDBMS instance, have also an “accepted” up-time percentage, consistent and available backups, have no significant index fragmentation percentages, and much more.
All the above, and more, are things that DBAs must ensure every day.
Below, you can find my list of the “Top 10 SQL Server DBA Daily Tasks“.
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 Uptime
- 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
Enter your name and email address below in order to receive the download link for the “Top 10 SQL Server DBA Daily Tasks List” right into your email inbox.
* By submitting the below form, you agree to be receiving our newsletter.
[email-download-link namefield=”YES” id=”2″]
Rate this article:
Reference: SQLNetHub (https://www.sqlnethub.com)
Recommended eBooks on SQL Server: