Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [tempdb]

26 questions
1
vote
2 answers

How to test TempDB performance?

I'm getting some conflicting advice on how to best configure our SQL storage with our current SAN. I would like to do some of my own performance testing with a few different configurations. I looked at using SQLIOSim but it doesn't seem to simulate…
Matt Penner
  • 253
  • 4
  • 10
1
vote
4 answers

Should Tempdb's Log file be on a different drive than the data files for best performance?

We have tempdb on its own drive array split into several files for performance. We have DB logs files on non-data drives. We question if we should put the tempDB log file on the log drive for all DB's or elsewhere, but separated from the temdb data…
David
  • 11
  • 1
  • 2
1
vote
2 answers

Fusion-IO ioDrives in SQL Server cluster

Has anyone successfully set up a Fusion-io ioDrive (or similar product) in a Windows cluster for SQL Server? (I would be interested in either Windows Server 2003 or 2008 and SQL Server 2005 or 2008). We are looking into the possibility of setting…
SQL3D
  • 670
  • 1
  • 6
  • 11
1
vote
1 answer

SQL Server 2005 TempDB Maintenace

I am working with a SQL Server 2005 database, which has the 8 files in 1 filegroup for the TempDB. The initial size of the 1st file is 8MB, and the other 7 are 2GB. This database is a reporting DB, which is populated nightly from an SSIS package.…
Dustin Laine
  • 433
  • 4
  • 13
1
vote
2 answers

TempDB is Full Issue for SQL Server 2000

Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at…
Jason N. Gaylord
  • 223
  • 3
  • 11
0
votes
2 answers

Can I safely stop running Update Statistics on my SQL Server 2005 instance?

I've got a SQL 2005 database which has some maintenance plans on it set up by someone else. One runs Update Statistics on all databases early in the morning. It seems this is causing tempdb to fill up and hence breaking some other maintenance tasks…
Robin
  • 817
  • 3
  • 11
  • 20
0
votes
2 answers

Is it safe to shrink tempdb.mdf in MS SQL Server?

Hej, my TEMPDB.mdf grew up to 42GB on MS SQL Server 2005 installed on Windows Server 2003. Last date change is 31/01/2013 at night. So, I wonder whether this is ok to shrink it?
Volodymyr Molodets
  • 2,424
  • 9
  • 36
  • 52
0
votes
1 answer

Replication on system databases

Is it possible to replicate system databases? I only ask because I had an issue previously (described here) that appeared to be impossible but has come back up again this week. This time TempDB log was growing quickly and according to…
Ddono25
  • 165
  • 3
  • 13
0
votes
1 answer

SQL Server 2008 tempdb log

my tempdb log is currently at: Currently allocated space: 0,50 MB Available free space: -25,95 MB (-5190%) How can this be minus? What should I do?
Geo
0
votes
3 answers

SAN performance issues storing SQL Server tempdb on a SAN that's being backed up

I'm afraid I don't know much about SAN's so please forgive my lack of detail or technical terms. As a developer I've just completed and put on an existing production system a new application but it would appear to have tipped the scales regarding…
Phil
-1
votes
1 answer

SQL server suddently started to write huge amount of uknown data to tempdb

so today our sql server suddently started to write a huge amount of data to the tempDB that resulting in disk spike so it can take up to 5 min before we can do anything in our program tryed to take all our not so active databases offline and found…
Kewin Björk Nielsen
  • 103
  • 3
1
2