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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
Can some please reply for this....
Post #1418021
Posted Saturday, February 9, 2013 8:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:28 AM
Points: 5,573, Visits: 24,808
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: Tuesday, July 8, 2014 2:57 AM
Points: 369, Visits: 1,208
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
Thank you...... Any more ans ...
Post #1418093
Posted Sunday, February 10, 2013 12:02 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 3:58 AM
Points: 710, Visits: 4,531
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