Thank you so much! I appreciate the information.

John,

Thank you for your reply Another question if I may..how did u convert the 63 hits to a percentage of 98%?

Also - one more clarification if I may..

In sp_configure..what would I set the min server memory to if i set the max server memory to 7 gig?

Thanks!

Thank you all for your replies. I appreciate it!

So if I am reading it all correctly:

Server 1: Windows 2003 Enterprise Edition; SQL 2000 Standard Edition; Memory = 4 Gig...