Solved

SQL Database temp database

Posted on 2014-04-03
3
162 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tempdb log contention 16 49
SQL query with cast 38 51
SSIS I need to get the most old file from a folder in the SSIS package. 3 39
migrate a SQL 2008 to 2016, 2 33
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.

807 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