Hi, wolf318, thanks for the reply.

The AVG() is exactly for the reason that some database have multiple data files. The alert described in this article is to 'monitor total space',...

I know this is old, but I had a similar issue recently. It was a security issue. For whatever reason, the security was not propagated properly during install, I did...

This would work, especially if there is a default retention time for the data, any data beyond that would be cleared out by a garbage collector, and any databases that...

I think I may have answered my own question.

It appears that the ReadErrorLog function is returning it's own error, rather than a collection of errors from the server log, which...

Thanks Perry. I think I just answered my own questions. I enabled Failover Clustering as a feature and tried to start the service and was prompted with the following error:

The...

Catching up on emails and I saw this editorial. My last post we had 3 servers and about 15 databases, and about a year ago I took a new job....

GilaMonster (6/20/2012)

---

There is a traceflag to disable checkpoints, I wouldn't be too astonished to find that SAP enables it, it's an app that doesn't exactly play well with others. Check...

Thanks for the feedback Gail, I figured that was the case but wasn't sure why automatic checkpoints wouldn't run. Nice to have some confirmation that I am not missing something...

Hey Josh, well spotted, that will teach me to play with my code while I write up my articles. 🙂

I will see if I can edit the article now it...

Hi Jason, thanks for the comments, all advice is greatly appreciated.

1. Good point, this will allow us to more easily deploy the process to servers with different threshold requirements.

2. The...

this thread:

http://www.sqlservercentral.com/Forums/Topic375915-146-1.aspx

has some helpful advice from standard to Enterprise, I would have thought the same principles would apply to an upgrade from Developer to Enterprise.

Hope it helps.

Stopping the cluster services / clustered SQL service should stop all of your SQL services. If any of the SQL services have not been added into the cluster you will...

As previously stated, clarification is the key

Do they want you to shut down a "clustered Service / application" on one server?

If so you can just right click the requested...

Thanks again Jeff, input is really appreciated.

Thanks, I will...