April 3, 2009 at 9:48 pm
Is it possible to keep tempdb on a separate disk?
April 3, 2009 at 9:50 pm
Yes, you can place the files anywhere you want.
April 3, 2009 at 10:31 pm
Yes.
alter database tempdb
modify file (name='tempdev', filename='f:\temp\tempdev.mdf')
alter database tempdb
modify file (name='templog', filename='f:\temp\templog.ldf')
Double check the new location, it must be valid, if not - SQL WONT WARN YOU !! while altering, but sql will fail to start after recycle.
You need to recycle sql server for allowing it to effect. you also need to delete old files manually.
April 4, 2009 at 3:29 am
Not only is it possible, I think the notion of having tempdb on its own separate disk \ array \ controller is suggested as one step you can take towards achieving better server performance.
April 4, 2009 at 6:45 am
Yes. I agree. I think this is one of the most commonly used practice in every environment (dev / qa/ prod)
And this should be done just after installation to avoid any issues.
April 4, 2009 at 6:47 am
randhirdadwal (4/3/2009)
Is it possible to keep tempdb on a separate disk?
Yes, technically you should place tempdb on its own disk without mixing up with the OS files.
You should also create equal number of files opposed to equal number of CPU's and of same size which gives you optimal performance.
April 5, 2009 at 5:04 am
Here are some excellent resource for the tempdb database.
All About the tempdb Database[/url]
April 5, 2009 at 10:14 am
Boolean_z (4/4/2009)
Yes. I agree. I think this is one of the most commonly used practice in every environment (dev / qa/ prod)And this should be done just after installation to avoid any issues.
It is a should be ... but is neglected so many times, as is the placement of e.g. the os page file(s). !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 5, 2009 at 10:30 am
April 5, 2009 at 10:53 am
That was a nice link, John. Any thoughts to writing it up a little more formally, and submitting at an article?
April 5, 2009 at 4:31 pm
Andy Hogg (4/4/2009)
Not only is it possible, I think the notion of having tempdb on its own separate disk \ array \ controller is suggested as one step you can take towards achieving better server performance.
i second this
April 6, 2009 at 2:29 am
The SQL Server 2008 install even has an option to specify where you want tempdb to be placed, so you can separate it from your other databases at install time.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
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
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply