Re: tempDB Concept

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 08:34:43 -0500

Tempdb grows just like any other db that has autogrow set on. The size of
Tempdb at restart will be the size it was originally created at or the size
it was changed using an ALTER DATABASE statement. If it was created at
100MB and grew to 1GB it would go back to 100MB on a restart. 

-- 
Andrew J. Kelly  SQL MVP
"Noorali Issani" <naissani@softhome.net> wrote in message
news:e35z%239CCEHA.596@TK2MSFTNGP12.phx.gbl...
> I just wanna confirm that if tempdb creates on run time then how can it
> grows more and more...
>
> When the sql services started then how much size it will take by default
for
> making this temp database.
>
> Thanks
> NOOR
>
>

Relevant Pages

  • RE: ASPState Bug/Security issue
    ... what is the proper way to configure SQL ... >!information does not survives a sql restart unless you ... >!tempdb for storage and I'm fine with the downsides. ... >!the stored procs in aspstate and you are good to go. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: tempdb can not delete it
    ... konow it is regenerated normally on restart, but it does not anymore. ... DBCC shrink does not work also.. ... It is recreated every time SQL Server is shutdown and then restarted. ... after a huge ODBC operation to read some data from a DB table, my tempdb is now 2.8 GB and I can not delete tempdb. ...
    (microsoft.public.sqlserver.setup)
  • Re: specific users on the tempbDB
    ... TempDB is recreated every restart of SQLServer. ... My developers have on the development server have ...
    (microsoft.public.sqlserver.security)
  • Re: huge tempdb database
    ... > Even if we stop and restart SQL Server, the database will remain this size ... I thought that the tempdb was recreated from ... > the model database upon restart? ...
    (microsoft.public.sqlserver.server)
  • Re: I am getting tempdb full error again
    ... Andrew J. Kelly SQL MVP ... Why don't you just make tempdb larger than you need and forget about this issue. ... Back up the transaction log for the database to free up some log space.. ... exec sp_helpdb tempdb ...
    (microsoft.public.sqlserver.server)