Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Write error during log flush. Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 3:37 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:15 AM
Points: 77, Visits: 191
Error from SQL Server Log
Log Writer: Operating System Error 170(The requested resource is in use) encountered.

This happens nearly everyday for different databases and SQL Server restarts depending which log file causes a problem.Like in case of tempdb I had to restart the database.

I have a virtualized multi-instance SQL Server Cluster on Vmware ESX 4.1, and the storage is on NetApp SAN. The last week we migrated storage to a Netapp SAN.

The shared disks within the virtual machines are virtualized disks, should we have the shared disks as RDM(physical disks). Would this be causing the write error ?
Post #1507396
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse