Support local disk location for TempDB in failover cluster installation - by qcjamess

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


63
0
Sign in
to vote
ID 532759 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/11/2010 12:42:59 AM
Access Restriction Public

Description

In busy SQL Server environments the TempDB database can be the database with the highest IO load.  If row versioning is enabled, the IO load can be much higher than any other database - especially since TempDB is a shared resource used by all databases in a given instance.

Failover clustering has the requirement that all SQL Server databases be contained on the shared storage - including the TempDB.  This doesn't make much sense to me, especially given the fact that TempDB does not persist across restarts of the SQL Engine.  Also, the IOPS generated by a busy system's TempDB utilization can overburden a system's HBA and storage arrays, leading to slower disk performance for log and databasedatafile IO.

This problem is made even worse for a stretch/geo dispersed cluster where the TempDB IO is mirrored to the remote storage unnecessarily.
Sign in to post a comment.
Posted by Boltworthy on 5/22/2014 at 4:01 PM
Is it possible to add new local disk for TempDB use to an existing SQL 2012 clustered instance?
Posted by millertime78 on 3/28/2012 at 9:00 PM
I'm glad to see this now in SQL2012
Posted by Johann Weskandt on 2/16/2012 at 7:31 AM
Note: This is possible now/soon in SQL Server 2012! See http://msdn.microsoft.com/en-us/library/bb500459%28v=SQL.110%29.aspx and related links for details!

Johann Weskandt
Escalation Engineer for SQL Server
Microsoft GMBH, Germany
Posted by Microsoft on 4/5/2010 at 11:19 PM
Enabling tempdb over local disk for a clustered instance need to change the current SQL Server Engine behaviors. Considering the potential impact of the Engine changes, we will not add this new feature in SQL Server 2008 service packs.

On the other hand, we are actively investigating the possiable solutions to support this in a future release.

Thanks again for your valuable feedbacks.

Regards,
Min He
Program Manager, SQL CRD Engine
Posted by Microsoft on 2/20/2010 at 3:08 AM
Creating tempdb on local disk is not supported by current SQL Server releases. We will investigate for a future release to support it.

Thanks,
Min He
Program Manager, SQL CRD Engine