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

What are best practices for setting transaction log size for user databases and what is for tempdb? Expand / Collapse
Author
Message
Posted Saturday, February 9, 2013 7:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:21 AM
Points: 75, Visits: 270
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
Posted Saturday, February 9, 2013 7:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:21 AM
Points: 75, Visits: 270
Can some please reply for this....
Post #1418021
Posted Saturday, February 9, 2013 8:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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
Posted Saturday, February 9, 2013 9:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 29, 2014 5:52 AM
Points: 369, Visits: 1,215
For the transaction log initial size and filegrowth setting, see here: blog.sqlxdetails.com

_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1418030
Posted Sunday, February 10, 2013 3:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:21 AM
Points: 75, Visits: 270
Thank you...... Any more ans ...
Post #1418093
Posted Sunday, February 10, 2013 12:02 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:28 PM
Points: 927, Visits: 5,889
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 »

Add to briefcase

Permissions Expand / Collapse