locked
Cluster & SSD RRS feed

  • Question

  • Hi All,

    Just wondering whether we could setup SSD ( Solid State Drive )  in  Windows Server 2008 R2 Cluster Environemnt using ONLY for SQl Server 2008 Cluster TempDB

    Thanks,

    Spatial_Partition

    Monday, July 16, 2012 4:48 PM

Answers

  • I guess optimal SSD location is local, but it may make sense to put them on the SAN as well, I believe most SAN vendors support it anyway.

    Josh

    • Marked as answer by amber zhang Tuesday, July 24, 2012 1:26 AM
    Tuesday, July 17, 2012 10:41 PM
  • Yes, I think we all read the original post differently.  For future reference, let me just make the final answer clear.

    SQL Server supports any drive technology the OS supports.  SQL Server uses the logical drive as exposed by the OS. 

    SQL Server storing tempdb on a local drive in a cluster environment is a feature of SQL 2012 and above.  This is independent of the hard drive technology of the local drive used.

     

    • Marked as answer by amber zhang Tuesday, July 24, 2012 1:26 AM
    Wednesday, July 18, 2012 1:39 PM

All replies

  • It is supported configuration for SQL Server 2012, but not 2008 sorry.

    Reference, http://msdn.microsoft.com/en-us/library/ms143506.aspx#storagetypes


    Mohit K. Gupta --- MCTS, MCITP, MCC2011
    My Blog OpsVault My MSDN Blog Twitter @SQLCAN

    Monday, July 16, 2012 5:02 PM
  • SQL Server uses whatever drives are exposed to the OS.  It does not know or care what type of drive they are.

    If you are asking if you can move tempdb to another drive, the answer is yes.

    Please see:

    http://www.sqlteam.com/article/moving-the-tempdb-database

    Monday, July 16, 2012 5:57 PM
  •  My Environment are : Windows Server 2008 R2 Clustered, SQL Server 2008 Clustered , EqualLogic SAN

    Try to use SSD and move TempDB  into SSD

    It's possible or nedd to wait to SQL 2012 as Mohit implied.

    Cheers,

    Tuesday, July 17, 2012 4:12 PM
  • Mohit is incorrect. 

    SQL Server uses whatever drives are exposed by Windows.  SQL Server does not care or know what kind of drive is installed.  As long as your server hardware and OS drivers supports SSD hard drives, there is no issue using SSD on any version of SQL Server.  I have used SSD drives on SQL 2000.

    • Proposed as answer by JRStern Tuesday, July 17, 2012 5:59 PM
    Tuesday, July 17, 2012 5:30 PM
  • I didn't say they can't use it.  I simply stated it is not a supported configuration.  I personally have not used TempDB on local disk for Cluster in SQL Server 2008 Failover cluster.  I can verify the support statement for 2008, but I am pretty sure it was not supported configuration.

    Mohit K. Gupta --- MCTS, MCITP, MCC2011
    My Blog OpsVault My MSDN Blog Twitter @SQLCAN

    Tuesday, July 17, 2012 8:00 PM
  • To clarify,

    In SQL 2012

    local tempdb in a clustered instance is supported in SQL 2012. As TempDb is recreated whenever SQL Service starts (failover) no need to be keep it in shared storage.  Yes you can use SSD.

    SQL 2008 R2 or prior clustering required tempdb on a shared storage.

    Tuesday, July 17, 2012 8:00 PM
  • Thanks All

    Cheers,

    Tuesday, July 17, 2012 8:08 PM
  • Yes, that is correct.  In a cluster, prior to SQL 2012, tempdb being on shared storage.  The OP did not specify if the SSD was local or shared storage.

    Tuesday, July 17, 2012 8:34 PM
  • Good point .. I guess I assumed it will be local heh my bad.

    Mohit K. Gupta --- MCTS, MCITP, MCC2011
    My Blog OpsVault My MSDN Blog Twitter @SQLCAN

    Tuesday, July 17, 2012 10:36 PM
  • I guess optimal SSD location is local, but it may make sense to put them on the SAN as well, I believe most SAN vendors support it anyway.

    Josh

    • Marked as answer by amber zhang Tuesday, July 24, 2012 1:26 AM
    Tuesday, July 17, 2012 10:41 PM
  • Yes, I think we all read the original post differently.  For future reference, let me just make the final answer clear.

    SQL Server supports any drive technology the OS supports.  SQL Server uses the logical drive as exposed by the OS. 

    SQL Server storing tempdb on a local drive in a cluster environment is a feature of SQL 2012 and above.  This is independent of the hard drive technology of the local drive used.

     

    • Marked as answer by amber zhang Tuesday, July 24, 2012 1:26 AM
    Wednesday, July 18, 2012 1:39 PM
  • +1 Agreed :).

    Mohit K. Gupta --- MCTS, MCITP, MCC2011
    My Blog OpsVault My MSDN Blog Twitter @SQLCAN

    Wednesday, July 18, 2012 5:11 PM