Questions tagged [tempdb]
The tempdb tag has no usage guidance.
26
questions
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 ...
-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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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).
...
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, ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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?