SQL Server Performance

SQL Server Temp Database Management

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Jacko25, Jan 17, 2007.

  1. Jacko25 New Member

    I would like to run a maintenance command overnight on the SQL Server, that manages the size of the temp database. Is this possible?
  2. alzdba Member

    - You need a stop/start to downsize it.

    - I wouldn't downsize tempdb because it materializes your sql-workspace, so maybe the next day your server will suffer file-extentions to everyboddy's regret ! (unless offcourse it grew due to exceptional stuff)
  3. MohammedU New Member

Share This Page