LessThanDot

A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

What does a SQL Server DBA need to check for daily, weekly, monthly, quarterly and yearly?

by SQLDenis on October 18, 2011 in category Data Modelling and Design

Instapaper

I am putting a wiki page together on what a SQL Server DBA needs to monitor daily, weekly, monthly, quarterly and yearly. So far I have created a couple of things here: What does a DBA need to check for daily, weekly, monthly, quarterly and yearly

So far I have added only a few items and a couple of blurbs, I would like to expand that and need some input from you the readers. What do you monitor

Daily

Weekly

Monthly

Quarterly

Yearly

Leave me a comment, include any links that have some good scrips also, I will link to those

About SQLDenis

Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.

Social Sitings

Author: SQLDenis

Categories: Data Modelling and Design Microsoft SQL Server Admin

Tagged as monitoring

Instapaper