Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Here's the problem we're having:

In the applications that are using the databases we get errors like:

The log for database 'redactedDatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Cannot close event log because there are still event handle users active.

The server log says this:

Error: 9001, Severity: 21, State: 1.

Context:

The server in question is holding databases for a multi-tenant application and lately it's been under quite heavy loads.

It has something like 3k small databases on it and these errors have been coming in the last week.

We have a work-around right now, which is taking the database offline then bringing it online again.

Any ideas why this is happening and how we can fix it?

Edit: Server specs: 2 Intel Xeon CPU 2.27GHz processors, 24 GB RAM, 4 x 500 GB HDDs in RAID 10 (SAS)

share|improve this question
    
What does the server's event log have at around the same time? –  Richard Sep 27 '12 at 9:54
    
Error: 9001, Severity: 21, State: 1. –  linkerro Sep 27 '12 at 9:58
    
Can you post the server's hardware specs? –  squillman Sep 27 '12 at 12:09
    
Posted the server specs –  linkerro Sep 27 '12 at 12:37
    
What do the secs/read and secs/write numbers look like from performance monitor? Do they spike when you have problems? I would think that 2x500/RAID1 (are they SATA or SAS?) could get overwhelmed pretty quickly, unless you have a super-small amount of updates, –  darin strait Sep 27 '12 at 12:40
show 3 more comments

1 Answer 1

Log corruption or hardware failure?

http://www.sql-server-performance.com/forum/threads/error-9001-severity-21-state-4.5878/

Also, from SQLServerPedia:

http://sqlserverpedia.com/blog/sql-server-bloggers/error-9001-severity-21-state-1-the-log-for-database-%E2%80%98tempdb%E2%80%99-is-not-available/

Finally, check the mini-dump file in the SQL Server log folder.

share|improve this answer
    
I checked the system logs, there are no hardware errors for the disk. –  linkerro Sep 27 '12 at 14:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.