Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Temp db if full Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 8:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi, One of our production application database still on old server
SQL server version 6.5
windows version 2000 SP4

We are receiving temp db full error more often. Earlier we used to get this once in a month and we used to restart SQL server/Reboot server to resolve the issue. But now it is occurring more often. Users are not happy with this.

I have started my career with SQL2000 and I have NO idea about 6.5 version.

How to resolve this without restarting the server? Thanks

Tepmdb properties:
tempdb datasize - 2600 MB
Data space available - 2090 MB
Log size - shared with data
Log space available - Shared with data
Post #1483759
Posted Tuesday, August 13, 2013 10:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:11 PM
Points: 5,571, Visits: 24,767
Read the following:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms675048(v=vs.85).aspx

It lists what you can do and how to do it .....


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1483861
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse