What are best practices for setting transaction log size for user databases and what is 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 user databases and what is for tempdb?

Rate Topic

Display Mode

Topic Options

Author

Message

rajeshjaiswalraj

Posted Saturday, February 09, 2013 7:30 AM

Grasshopper

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

What are best practices for setting transaction log size for user databases and what is for tempdb?

Can some one please help me that.. How to Decide that how much size i have to give for user data base and Temp data base.

Post #1418013

rajeshjaiswalraj

Posted Saturday, February 09, 2013 7:59 AM

Grasshopper

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

Can some please reply for this....

Post #1418021

bitbucket-25253

Posted Saturday, February 09, 2013 8:55 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 PM
Points: 5,102, Visits: 20,208

As with most items concerning SQL and for your specific question "It depends", is in some regards the universal answer.

Now to obtain further details for various situations such as database activity (insert of new data, deletion/updating of already entered data) I suggest you read:

And in particular the section titled: What are the performance implications?

http://support.microsoft.com/kb/315512?wa=wsignin1.0

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1418028

Vedran Kesegic

Posted Saturday, February 09, 2013 9:18 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 342, Visits: 1,074

For the transaction log initial size and filegrowth setting, see here: blog.sqlxdetails.com

_____________________________________________________
XDetails Addin - for SQL Developers and DBA
blog.sqlxdetails.com - Transaction log myths - debunked!

Post #1418030

rajeshjaiswalraj

Posted Sunday, February 10, 2013 3:20 AM

Grasshopper

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

Thank you...... Any more ans ...

Post #1418093

pietlinden

Posted Sunday, February 10, 2013 12:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:13 PM
Points: 186, Visits: 1,583

I would check out Gail Shaw's articles. She writes extensively on transaction log management, and knows what she's talking about.

Maybe start here: [url=http://www.sqlservercentral.com/articles/Administration/64582/][/url]

Post #1418125

« Prev Topic | Next Topic »

Permissions