We have a prod server that has slowled significantly after more RAM was added, from 1gig to 2gig. We set the max SQLServer can use to 1900Mb. When it gets closer to the max queries slow significantly from around 1-2 sec up to 10secs. The DB is v7 SP2.
Anyone had this problem before?
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"