Top 10 SQL Server DBA Daily Tasks List

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:

1. Check SQL Server Instance Uptime
2. Check Last Full, Differential and Log Backup Times
3. Check Failed SQL Agent Jobs in the Last 24 Hours
4. Check Current Log for Failed Logins
5. Check for Blocked Processes
6. Check Top N Queries Based on Average CPU Time
7. Check Drive Volumes Space
8. Check Index Fragmentation
9. Patch Management
10. Self-Education and Improvement

Get the list here! It’s free!

Top 10 SQL Server DBA Daily Checks List

1 file(s)   329.56 KB

Download

Online Course Recommendations

Moreover, I recommend the below 2 online courses, for learning more about SQL Server and stay up to date:

SQL Server Fundamentals (SQL Database for Beginners)

In this course, you will learn everything you need to get started with SQL Server. Via a 2.5-hour journey with a combination of lectures, live demonstrations, quizzes and a practice test, you will get started with one of the world’s leading RDBMSs, that is SQL Server. (learn more…)

SQL Server 2019: What’s New

In this course, you will learn about all major new features and enhancements in SQL Server 2019. Via a 1-hour journey with a combination of lectures, live demonstrations, quizzes and a practice test, you will get up to date with SQL server 2019 in no time! (learn more…)

Rate this article: (4 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub (https://www.sqlnethub.com)

Artemakis Artemiou

Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.