The tempdb tag has no wiki summary.
1
vote
2answers
119 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 ...
1
vote
2answers
221 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
3answers
242 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
1answer
81 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 ...
2
votes
1answer
267 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
1answer
174 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
2answers
491 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
1answer
185 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
6answers
1k 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
3answers
457 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
2answers
243 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
4answers
230 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
2answers
1k 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
2answers
282 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 ...
6
votes
7answers
6k 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
1answer
652 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
1answer
740 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
3answers
2k 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
...
2
votes
5answers
800 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 ...
9
votes
4answers
846 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?
