Solved

SQL Database temp database

Posted on 2014-04-03
3
161 Views
Last Modified: 2014-04-18
Any idea how to split the temp database in serveral files in order to improve the SQL database performance ?

We will replace the SQL server and I'm thinking of use a SSD hdd to put the tempdb and log file. Any comment ? Any fact for the new server to improve the performance is appreciated ?

Great Tks.
0
Comment
Question by:AXISHK
3 Comments
 
LVL 16

Accepted Solution

by:
Carol Chisholm earned 300 total points
ID: 39977295
0
 
LVL 10

Assisted Solution

by:PadawanDBA
PadawanDBA earned 200 total points
ID: 39978157
I always like how the Ozar team explains stuff: http://www.brentozar.com/?s=tempdb.  Specifically recommended, the Bob Dylan explanation of the TempDB =)
0
 

Author Closing Comment

by:AXISHK
ID: 40009966
Tks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question