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.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass