Do you change the default temp folder location on your live servers?

Published 17 June 09 07:00 PM | MartinBell

Depending on which version of windows you are running the location of the default temp directory may vary e.g. for Vista and Windows 2008 it is Drive_Letter:\Users\AppData\Local\Temp  where Drive_Letter is the drive on which you installed Windows i.e. the system disc. So why should you change this?

One reason is because if the system disc gets full, the server can become un-responsive and it can be difficult to logon to diagnose and correct the problem. If your temp directory is elsewhere the effects may still cause you problems, but should (hopefully) be less of an issue to correct!

Of course you may think that the controls on your production system(s) will mean this will never happen, but when does everyone always stick to the plan or even know it?

In my next article I show how a DBA can un-knowingly cause problems.

<Update> 

Books Online now carries a warning about filling up the TEMP directory when using SQL Profiler http://msdn.microsoft.com/en-us/library/ms174203.aspx.

SQL Profiler will keep a copy of the trace displayed in the GUI even if you specify a file for it to save the output to; this means you could end up with two large files!!!

</Update>

Filed under: ,

Comments

# Dew Dump – June 18, 2009 | Alvin Ashcraft's Morning Dew said on June 18, 2009 03:08 PM:

Pingback from  Dew Dump &#8211; June 18, 2009 | Alvin Ashcraft's Morning Dew

# Martin Bell UK SQL Server MVP said on June 19, 2009 04:18 PM:

When you spot the Windows Administrators scurrying about in a mild panic, just make sure you are not running SQL Profiler!!

# Dew Dump – June 19, 2009 | Alvin Ashcraft's Morning Dew said on June 20, 2009 02:28 AM:

Pingback from  Dew Dump &#8211; June 19, 2009 | Alvin Ashcraft's Morning Dew

This Blog

SQL Blogs

Syndication