VLDB and Transaction Log
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
SQL Server 2000 EE Service Pack 4
Windows 2003 EE
Disk is EMC SAN
We have large databases in the range of 40-80 GB. The transaction logs are
around 12 GB each.
In theory is it better to have one file for the transaction log on a single
spindle or multiple smaller files each on their own spindle.
The documentation I have read in the past pointed to a single file, but not
sure if it applies as larger databases come into play.
.
Relevant Pages
- Re: In Addition....
... The transaction logs are what are what every transaction is ... transaction logs and then lazily written to the databases. ... >What do you mean by your mailboxes and public folders ... >> are stored on my c partition, ...
(microsoft.public.exchange.admin) - Re: Database and mirroring
... For all but the smallest deployments, you would want your transaction logs ... OS, RAID 1 for the logs, and either RAID 1 or RAID 10 for the databases. ... backup technology you are using; ... Another area is recoverability. ...
(microsoft.public.exchange.admin) - Re: SQL Server Express - Detach & Shrink
... what I need is some sort of single file to store numerical data. ... past we have used Access databases for this sort of thing but now our client ... So when a user has finished with a database, I stream both the mdf and ldf ...
(microsoft.public.dotnet.framework.adonet) - Re: Unlikely performance issues
... the following disk configuration: ... has the search catalog + paging file + public databases ... Avarage mailbox has 7000 items and is ... should move my transaction logs to another disk. ...
(microsoft.public.exchange.admin) - Re: Exchange logs going nuts
... I have one store on Exchange 2003 with 4 databases in it ... > that is creating an insane amount of logs and I'm trying to figure out ... > there are 50GB's of transaction logs in under 24 hrs. ...
(microsoft.public.exchange.admin) |
|
