TempDb - odd usage figures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » TempDb - odd usage figures

TempDb - odd usage figures

Rate Topic

Display Mode

Topic Options

Author

Message

Stuart Davies

Posted Monday, September 21, 2009 1:54 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:54 AM
Points: 2,475, Visits: 2,135

Hi,
Running SQL2005 SP2
At the moment I don't believe that it is causing me any problems, but tempdb is showing that there is -700% free for the data file and -3000% free for the log (there is no issue with space on the drives where the data and log files are stored).

Does anyone have an idea as to what is causing these odd figures?

Thanks

Stuart

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Post #790980

Stuart Davies

Posted Monday, September 21, 2009 2:01 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:54 AM
Points: 2,475, Visits: 2,135

Double posted on this one - sorry please do not reply to this thread

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Post #790983

« Prev Topic | Next Topic »

Permissions