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

tempdb log files Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 3:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 2, 2013 1:48 PM
Points: 1, Visits: 20
I begin to work with one new client.
Sql 2005 x64 standard sp3. 4 CPU'S.

I find 4 data files and 4 log files?. Each log file grow equally, said 3gb each and 2gb used.
I always thought: log files are sequentially filled but in this case, apparently, they are filled in parallel.

The question is: what I'm missing?
Post #1477757
Posted Thursday, July 25, 2013 6:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:34 PM
Points: 1,219, Visits: 1,690
Both Paul Randal and Jonathan Kehayias have blogs which include evidence that the t-logs are filled sequentially

http://www.sqlskills.com/blogs/paul/multiple-log-files-and-why-theyre-bad/

http://www.sqlskills.com/blogs/jonathan/an-xevent-a-day-23-of-31-how-it-works-multiple-transaction-log-files/

Jonathan's conclusion:
The reason that only a fraction of the log records are written to the three additional log files is proportionate to the difference in the autogrowth settings between the first log file at 32MB and the three additional log files at 1MB. If the first log file was set to grow at 1MB, the majority of the log records would not be in the first log file.
Post #1477815
Posted Thursday, October 24, 2013 4:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 6:52 PM
Points: 1, Visits: 12
Very Informative!
Post #1507962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse