What are best practices for setting transaction log size for tempdb?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » What are best practices for setting...

What are best practices for setting transaction log size for tempdb?

Rate Topic

Display Mode

Topic Options

Author

Message

rajeshjaiswalraj

Posted Sunday, February 10, 2013 10:51 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:19 PM
Points: 23, Visits: 98

Please some one help me .....

Smile

What are best practices for setting transaction log size for tempdb?

Post #1418123

GilaMonster

Posted Sunday, February 10, 2013 2:35 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:29 PM
Points: 37,722, Visits: 29,976

Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1418142

Jeff Moden

Posted Sunday, February 10, 2013 5:58 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 32,906, Visits: 26,792

rajeshjaiswalraj (2/10/2013)

Please some one help me .....

Smile

What are best practices for setting transaction log size for tempdb?

I wouldn't call it a "best practice" but here's what I do...

I set it to 100MB with 100MB Growth and then I watch it. Whatever it get's to after a full monthly cycle has passed is probably a pretty accurate size. I'll add half a GB to that and use that for the Initial Size keeping the 100MB growth. Of course, the new intial size won't kick in until the next bounce of the service or reboot of the server. I typically will do the same with the MDF file.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1418157

SQLRNNR

Posted Sunday, February 10, 2013 6:39 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:07 PM
Points: 18,733, Visits: 12,332

GilaMonster (2/10/2013)

Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.

Same thing I do. Other option is to run it for a while and monitor. Then adjust your settings.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1418170

« Prev Topic | Next Topic »

Permissions