Questions tagged [tempdb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
29 views

How does Azure handle TEMPDB on the local SSD when using WSFC to support an always on availability group?

How does Azure handle TEMPDB on the local SSD (drive D:) when using WSFC to support an always on availability group? I know that the local SSD, where it's recommended to place TEMPDB, is erased ...
Gabe Green's user avatar
-1 votes
1 answer
299 views

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

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 ...
Kewin Björk Nielsen's user avatar
4 votes
1 answer
8k views

How to find out who / what is hammering SQL Server TempDB

I am using SQL Server 2012 Enterprise. The server has one availability group configured. There are several databases for different tools on the instance. The tools all belong together and therefore ...
Tobi DM's user avatar
  • 53
3 votes
1 answer
45 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
CWilliams's user avatar
5 votes
4 answers
6k views

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored ...
mramirez's user avatar
0 votes
2 answers
24k views

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's user avatar
1 vote
2 answers
3k views

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 ...
Matt Penner's user avatar
2 votes
2 answers
3k views

Why did my tempdb fill up, and what was trying to shrink it?

After months of perfectly flat disk usage, my tempdb file suddenly grew by several gigs over the weekend. Nobody at the company is aware of anything that might have changed. When I checked the tempdb ...
Josh's user avatar
  • 763
1 vote
4 answers
5k views

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 ...
David's user avatar
  • 11
0 votes
1 answer
189 views

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 ...
Ddono25's user avatar
  • 165
3 votes
1 answer
9k views

What happens when tempdb can't grow any more?

I have run into a problem where a tempdb database set to have unrestricted growth has used up all the available disk space (10x its norm). I am considering setting a maximum size limit, something big ...
Iain Hoult's user avatar
0 votes
1 answer
374 views

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?
user avatar
1 vote
2 answers
1k views

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). ...
SQL3D's user avatar
  • 670
1 vote
1 answer
335 views

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, ...
Dustin Laine's user avatar
2 votes
6 answers
2k views

SQL Server 2005 tempdb files moved to invalid (SSD) drive. How to validate drive, or how to move files back?

SQL 2005 32bit Developer edition, all recent service packs Windows Server 2003 Standard 64x, all recent updates Fusion IO drive We installed a wifty new 80GB SSD card on our development server, ran ...
Philip Kelley's user avatar
0 votes
3 answers
624 views

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 ...
user avatar
1 vote
2 answers
491 views

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, ...
Jason N. Gaylord's user avatar
2 votes
4 answers
278 views

SQL 2005 Standard Questions

I have a question about the tempdb files and hyperthreading. Here are the sw/hw specs. Server 2008 SP2 Standard X64 SQL 2005 Standard Sp3 x64 Dual Quad Core Xeon's E5540's (HT enabled) 12 GB Ram My ...
user avatar
0 votes
2 answers
7k views

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 ...
Robin's user avatar
  • 827
1 vote
2 answers
4k views

Is it ok to limit the size of templog in SQL Server 2005?

I've a problem I'm investigating whereby my tempdb logfile grows out of all proportion to anything which would seem sensible. This morning it was over 10x the size of the data files. However, the ...
Robin's user avatar
  • 827
9 votes
8 answers
40k views

My templog.ldf is huge (45gb), What if anything should I do?

I've a SQL 2005 installation and my templog.ldf file keeps growing to consume all the free space on the drive it's on. Sometimes it'll stop with a few mb free but sometimes it goes further, this being ...
Robin's user avatar
  • 827
1 vote
1 answer
2k views

How does the Proportional fill Algorithm in SQL 2005/2008 work?

When we setup multiple data files for tempdb I understand SQL Server uses a Proportional Fill algorithm. How does it work? Does it use the same method for user databases aswell. I have tried to ...
Chirag's user avatar
  • 155
2 votes
1 answer
3k views

Large amount of tempdb log writing, no reading

I'm running into some behaviour that appears strange to me. I'm using SQL Server 2008 Enterprise, 32-bit (quad Core 2), on Windows 7 (for testing). I have a stored procedure that uses two table ...
MichaelGG's user avatar
  • 1,739
3 votes
3 answers
3k views

Correct settings for tempdb to avoid significant changes in free space

Every two to three days we are getting the following SCOM error: The database tempdb in SQL instance MSSQLSERVER on computer sqlserver has experienced a significant change in free space ...
Alex Angas's user avatar
  • 2,037
3 votes
5 answers
2k views

TempDB contention on sysmultiobjrefs SQL 2005

We've been having trouble caused by what we believe is contention within tempDB. Whenever we are having problems, our system is always waiting on one particular resource: 2:1:103, which when we look ...
Rob's user avatar
  • 31
11 votes
4 answers
1k views

SQL Server setup check list

What are the things I have to consider when I have to install SQL Server (2005/2008) on a new server? Storage setup TempDB Security What are some common mistakes made in that process?
splattne's user avatar
  • 28.6k