We have been experiencing degrading performance on our SQL 2000 std. database. We are running on windows 2003 std, with 4GB of ram. our larger (and most often used) databases have gone over 2GB each.
Checking memory usage, we never see the system going over 1.8GB, so figured that memory could not (yet) be the issue becouse SQL would go up to atleast 2gb... but... this is so close to it that it might actually be that limit already.
What do you think?