Posted by Erland Sommarskog on 10/01/07 21:44

rdraider (rdraider@sbcglobal.net) writes:
> 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.

It depends on the activity in the database. If you do plenty of
activities that can be minimally logged, simple recovery is a gain. Example
of minimally logged operations are bulk-load, select into, create index
including reindexing.

You will also be somewhat less prone to performance loss because of auto-
grow in tempdb.

RAID5 is usually considered a poor choice for SQL Server files.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]