My company has a large customer base running on SQL 2000 databases. (MSDE and SQL Standard) These databases for the most part are running in Windows 2000 and 2003 environments.
As of late, our servers have been shipping with Windows 2008 and 2008 R2.
We have been installing SQL 2000 on these servers and it now appears there is a memory leak in the system. (MSDE and SQL Standard)
I have attempted to run a copy of SQL 2008 with the database in compatibility mode. But this appears slower!
A quick restart of the SQL service on the older systems appears to take care of the issues for a few days until the memory is used up again.