Reply to Simple recovery model affect performance?
Posted by rdraider on 10/01/07 17:03
Do you get any performance improvement by using a Simple recovery model?
Full backup run each night, loss of 1 days data is acceptable.
This is an ERP app (accounting, inventory, order entry, etc) so a mix of
reads and writes, 20 users.
SQL 2000 Standard, Windows 2000 sp4, 2gig ram, RAID1 for OS, RAID5 for SQL
data and logs.
Hardware upgrades do not seem to be in the budget.