Take the tour ×  We've got a production DB server on SQL 2005.
Everything runs normally for a while, but after a couple weeks
we see a notable performance drop. Only restarting SQL Server
brings performance back to normal.  Some background:    •
Running over 1200 databases (mostly single tenant, some multi-
tenant). Before anyone lectures on moving to only multi-tenant,
there are valid reasons for keeping this structure......   • RAM
is 16 GB. After restarting, it doesn't take too long for SQL
Server to go back to 15 GB usage.   • Active DB connections is
about 80 connections - which we feel is fairly healthy
considering there is one connection pool per web server per
process - so we don't have a connection leak issue.  We've tried
several things in non-peak times: - Run DBCC DROPCLEANBUFFERS
(with a CHECKPOINT) to clear data cache. It has no effect, nor
does it clear any of the RAM usage). - Run FREEPROCCACHE and
FREESYSTEMCACHE to clear query plans and stored proc cache. No
effect.  Obviously restarting SQL