Drives used for SQL databases are running out of free space

Nearly all SharePoint farms I look at show the error:

Drives used for SQL databases are running out of free space

However, this seems to happen even on SharePoint farms where there is tonnes of space. It’s always puzzled me, and it results in many customers simply ignoring the warning, ‘cos they can’t figure out why they’re getting it, and having checked the drives they think they’re fine (and they probably are).

Well Zoltan Kovacs has a very good analysis. It’s well worth a read.

I’m going to plagiarize a little – in case his blog vanishes in the future – but the essential elements are:

It compares the current size and “some” autogrowth value with the free space on that drive. It does not care about your free space in your database; if you have a 1 GB db and have 990 MB free space in it, it is still counted as 1 GB as current size.

So you are safe if:

all your databases files can grow with two times its growth percentage [if specified as percentage] OR can grow 40% [if autogrowth is specified as a fixed value] compared to current free space.

Nice. That’s useful, and might make these rules useful again.

Advertisements
Drives used for SQL databases are running out of free space

One thought on “Drives used for SQL databases are running out of free space

  1. Hi Andy,
    Thanks for the summary reblog. Let me know if you are interested in any other rule. If I have time might have a look 🙂

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s