Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TempDB on Amazon Ephemeral drives Expand / Collapse
Author
Message
Posted Sunday, April 21, 2013 5:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 30, 2016 8:09 PM
Points: 103, Visits: 685
Has anybody used the EC2 Ephemeral drives as a location for their TEMPDB databases?

Normally I use a standard volume but these drives are supposedly faster for TEMPDB -- but are volatile of course which should not be an issue for the TEMPDB as long as it is put in the root of the drive and not a folder (as the folder will not get re-created when the machine restarts).

thanks

Post #1444828
Posted Monday, April 22, 2013 4:24 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 3,059, Visits: 3,780
I am interested to hear what your experience is if you do this.

We have decided to always use EC2 volumes, but have not experimented with using the instance storage for tempdb.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 29 Aug 2016: now over 38,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1444917
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse