Tag Archives: administration

Capacity Planning – Monitor and Extrapolate

Posted on January 16, 2012 by way0utwest

I wrote a post recently on capacity planning, and then thought of one more thing. In addition to planning for the future for new systems, you also need to regularly monitor your existing ones. Planning for the future, IMHO, isn’t … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Read-only Data

Posted on January 6, 2012 by way0utwest

We keep gathering, storing, and managing more and more data. Many of our systems could use an archiving plan to migrate older data to another database or system where it can be accessed, but it won’t impact the performance of … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Read-only Data

Autogrow guidelines

Posted on December 2, 2011 by way0utwest

I always enable autogrow on my databases. However, it’s there for emergencies, not as a space management tool. I monitor disk space, and I grow my files manually as space runs low. I want to control the growth, but in … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Recovery Models

Posted on September 26, 2011 by way0utwest

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases use the defaults, which mean that they are in the full recovery model. In that case, you need to be … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Recovery Models