Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server 2008 R2 TEMPDB massive autogrowth suddenly. RE: SQL Server 2008 R2 TEMPDB massive autogrowth suddenly.

  • January 7, 2013 at 1:37 pm

    #1574518

    Yep I've asked the app admin and report people everyone is claiming they were doing nothing.

    All the users access the DB via the application front end. So general users shouldn't(wouldn't) be running queries directly against the DB the only exception is the report writers, they have a report DB restored from the nightly backup but sometimes they want full live data.

    Most likely it was an glitch in the application i guess. some query the app executed got stuck and filled up tempdb?

    Here are the errors in SQL error log.

    --------------------------------------------------------------------------------------

    Date7/01/2013 12:57:40 PM

    LogSQL Server (Current - 7/01/2013 1:00:00 PM)

    Sourcespid2866

    Message

    Error: 17053, Severity: 16, State: 1.

    ----------------------------------------------------------------------------------------

    ---------------------------------------------------------------------------------

    Date7/01/2013 12:57:40 PM

    LogSQL Server (Current - 7/01/2013 1:00:00 PM)

    Sourcespid2866

    Message

    k:\SQLDATA\tempdb.mdf: Operating system error 112(failed to retrieve text for this error. Reason: 15105) encountered.

    -----------------------------------------------------------------------------------

    -------------------------------------------------------------------------------------

    Date7/01/2013 12:57:41 PM

    LogSQL Server (Current - 7/01/2013 1:00:00 PM)

    Sourcespid2866

    Message

    Error: 1105, Severity: 17, State: 2.

    --------------------------------------------------------------------------------------

    -------------------------------------------------------------------------------------

    Date7/01/2013 12:57:41 PM

    LogSQL Server (Current - 7/01/2013 1:00:00 PM)

    Sourcespid2866

    Message

    Could not allocate space for object 'dbo.SORT temporary run storage: 143231156879360' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    ------------------------------------------------------------------------------------------