SQL Database Documentation Inconsistency / SAN use for back-end database

Locked SQL Database Documentation Inconsistency / SAN use for back-end database

  • sabato 7 marzo 2009 17:40
     
     
    So I've been digging through the documentation and found an inconsistency and wondering if anyone knew the official Microsoft answer.  On this page:

    http://technet.microsoft.com/en-us/library/dd425133%28office.13%29.aspx
    (Storage Requirements)

    You can find these two items within sentences of each other:

    Among the more common methods of protecting your Office Communications Server 2007 R2 infrastructure against failure of back-end database storage are SQL Server clustering, network attached storage (NAS), SAN, and RAID.

    ...

    As a best practice, use Directly Attached Storage (DAS) or, except for the back-end database, SAN storage array solutions, because this configuration optimizes performance and reliability for Office Communications Server 2007 R2.

    These two statements would seem to contradict each other.

    In the download CHM file the note reads differently as:

    As a best practice, use Directly Attached Storage (DAS) or SAN storage array solutions because this configuration optimizes performance and reliability for Office Communications Server 2007 R2.

    And then above each of the notes on this page and the download CHM file is this section:

    Use of a SAN is not supported for the Office Communications Server back-end database. For other databases and for storage of your Office Communications Server 2007 R2 data files, particularly for Enterprise Edition deployments larger than 50,000 clients, where availability, performance, and data protection are critical. This configuration optimizes server performance and reliability. It is expected that such organizations may already have a SAN deployed and can provision additional logical unit numbers (LUNs) and ports.

    So the question is, what is the real scope on the backend database?  Can you use a SAN for SQL database to protect in a SQL cluster environment or is the second statement about non-support on the SQL database the real story.  Just curious if anyone has asked this question before.

    Richard

    Richard Brynteson | Convergent Solutions Group | http://www.convergent-solutions.com

Tutte le risposte

  • lunedì 9 marzo 2009 17:57
    Moderatore
     
     Risposta suggerita
    Richard,

    This is being reviewed internally and the documentation is getting cleared up to tell the same story, so to speak.  From the feedback I received from the product group (without going into too much detail) I think it's safe to say that line in the CHM file about SANs not being supported is the incorrect statement.
    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
  • martedì 10 marzo 2009 11:43
     
     
    Jeff,

    Thanks.  I was assuming that was the case but then again I started to think about it and maybe Microsoft doesn't want someone's phone system to be dependent on a SAN not crashing (then I would think DAS would be more likely to fail - so what the heck).

    Richard

    Richard Brynteson | Convergent Solutions Group | http://www.convergent-solutions.com