May 19, 2009 at 8:49 am
We are getting an issue on a SQL Server 2005 that runs on a windows 2000 box.
Whenever there a large amount of activity on SQL a number of big temp files get written to the following location:
C:\Documents and Settings\Administrator\Local Settings\Temp\1\
The Server then runs out of space and has to be rebooted. Has anyone had a similiar experience ?
May 19, 2009 at 9:02 am
What are the names of those files?
SQL wouldn't be writing to that directory unless something was configured to write there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 9:30 am
They are eithier temp file ie. tm344.tmp or ~vs2E0 sql server query files. But it only fills up when we are running a long sql server query.
May 19, 2009 at 10:12 am
They are eithier temp file ie. tm344.tmp or ~vs2E0 sql server query files. But it only fills up when we are running a long sql server query.
You are causing this yourself by executing queries in SSMS on the server. The easiest way to fix this is to execute the queries from a PC running SSMS and connected to the server. That way, if the query fills up the temp directory on the PC - the only thing affected is your PC.
Now, if you really need to run these very large queries and return the data to SSMS on the server - then you need to move the temp directory for that user to a drive that has enough space available.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply