Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krajdba
Starting Member
43 Posts |
 Posted - 2007-10-01 : 12:59:25
|
| Hi Our application generates A LOT of updates,deletes and insert during certains times and due to this it generates heavy transaction log usage. I have setup maintenance plans to take backups of transaction logs for every 15 minutes. Will this cause performace issue?Will there be contention for the transaction logs backups when there is heavy updates/insert/deletes?Please let me know.Thanks Raj. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 13:28:53
|
No, shouldn't be (or should only be minimal  ) |
 |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-10-01 : 14:46:55
|
| Hi, You should improve performance of its storage system like adding more disks, creating a RAID with more performance that today.You should put your Transact Logs in different disks in which the Datafiles aren't stored.Try creating a transact log with the size enough for that period you've defined. Avoiding use system resource to increment that file. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 15:03:26
|
| Yeah, make SURE that you aren't Shrinking the TLog files, other than that they should grow, by themselves, to an "equilibrium" state.+1 to "Put the logs on different spindles"Kristen |
|
|
|
|
|
|
Performance of Database