The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
26 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 ...
3
votes
3answers
2k 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
1answer
10k 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
2answers
730 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
1k 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
2k 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
121 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
1answer
2k 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
290 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
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
1answer
299 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
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
3answers
548 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
285 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
268 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
3k 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
882 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 ...
7
votes
7answers
16k 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
1k 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
2k 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
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
5answers
1k 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 ...