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.

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 – 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 – June 19, 2009 | Alvin Ashcraft's Morning Dew