Top 10 SQL Server DBA Daily Tasks List

Top 10 SQL Server DBA Daily Tasks List

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

If you register as a member on SQLNetHub, you will be able to access the Member’s area, from which you will be able to download the above list, enriched with T-SQL scripts for each task (where available) and more info.

Registration is free.

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Loading...

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

Top 10 SQL Server DBA Daily Tasks List Click to Tweet

Recommended eBooks on SQL Server:

Developing with SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Developing SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics 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). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found at aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.com and TechHowTos.com.