Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server 2008 R2 in hung state. Need help in analyzing the log. RE: SQL Server 2008 R2 in hung state. Need help in analyzing the log.

  • April 23, 2014 at 6:50 am

    #1708071

    Perry Whittle (4/23/2014)

    in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B. Whenever the admin ran parallel backups or restores of the huge databases on server B, server A used to have similar problems to what you're seeing, in fact in some cases the LUNs would disappear and the SQL instance would go offline.

    I've seen a similar thing, the LUNs were dedicated but the fiber switch was shared with a data warehouse. One day the data warehouse ran a complete reload of all data and our production server keeled over and died.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass