January 9, 2012 at 6:43 pm
Hi everyone,
I was thinking of creating an alert to capture the "SQL Server:SQL Errors > Errors/sec > DB Offline errors" performance counter. I have two questions, what does this counter really mean? Is it for when the database goes offline by running the alter database offline command or is it when database goes offline in any fashion? Second question is, will setting up this alert have a performance hit on my server?
Thanks.
January 9, 2012 at 6:52 pm
It is the number of errors that forced SQL Server to put a pesky, consistently erring database offline.
On a typical installation and under typical circumstances, this number will be zero. If, however, you are running a database hosting service that has thousands of databases owned by unpredicatable users, on the same server, say Azure, this is a vital information you need to explain to you [irated] customer why his database was taken offline.
I suggest that unless you are a cloud administrator, you do not have to worry about that.
January 9, 2012 at 6:58 pm
Got it, thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply