cheers already rebuilding indexes, stats, freeing caches etc once a day.

database is 3GB server has 4GB with 5 drives in raid 5 (client decision) again. Have asked for OS to be on two of them on raid 0 and the other 3 in raid 5 for SQL Server.

Do you think 4GB ram is enough? Windows 2003 32 Bit, can I enable AWE is should they look at upgrading to 64 bit?

1.65 is currently being used by SQL