email-935809 (8/9/2010)
freeing caches once a day.
Don't do that. You're just making SQL do more work
Do you think 4GB ram is enough? Windows 2003 32 Bit, can I enable AWE is should they look at upgrading to 64 bit?
No idea if 4 GB is enough. That's like asking how long a piece of string is. Without knowledge of your workload there's no way to give a useful answer. AWE is for when you have more than 4GB of memory on the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability