Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Tempdb grows suddenly. Expand / Collapse
Posted Friday, August 30, 2013 4:55 AM



Group: General Forum Members
Last Login: Today @ 9:33 AM
Points: 15,989, Visits: 30,357
Since it's happening overnight, there has to be a process that is getting run overnight. Do you have scheduled jobs. If so, what are they doing?

I wouldn't suggest rebooting the server over and over as a fix. Instead, leave it where it is, figure out what the issue is, then determine if you just need a bigger tempdb or if it can be shrunk permanently because you've fixed the issue.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1490073
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse