Post reply

DB not available on all nodes

  • December 16, 2008 at 9:30 am

    #913251

    If disk caching is enabled within the OS it is possible that data is not flushed from the cache down to the disk prior to it going offline. SQL believes that the transactions are committed and makes the adjustments on it's end, however the changes are not committed causing the missing data behaviour.


    Shamless self promotion - read my blog http://sirsql.net

  • January 5, 2009 at 11:41 am

    #921335

    Thanks to both of you for your help. We seem to have a resolution. Unfortunately, we made two changes so we don't know which one did the trick or if we needed both. The changes were:

    Set the MAXREQUESTHOLDTIME registry value to 600 instead of 60 for the SAN (from Lefthand support).

    Disabled the indexing service in disk manager for the drives.

    I have only moved the groups a few times since we made these changes so I hope I am not speaking to soon :unsure:

  • January 6, 2009 at 2:40 am

    #921625

    Thanks for sharing the solution.



    My blog

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply