I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes.
tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space restriction.
Is it OK to move tempdb to another drive and leave the other SYSTEM databases on C: or should I move them all? Any and ALL advice is greatly appreciated.
SQL Server 2005 on Windows 2003 Server
September 11, 2009 2:22 PM
September 11, 2009 10:18 PM