SQL Server 2005 high memory usage and performance problems
- by emzero
Hi there guys.
I have this ASP.NET/SQLServer2005 website running on a production server (Win2003, QuadCore, 4GB).
The site runs smoothly normally, but after 2-3 weeks I notice a slow performance on the site (especifically in one particular page). Also I notice that the SQL Server process is using like 2GBs of RAM. So I restart the service, the site runs fast again and the process 300-400MBs.
I'm looking for an explanation of why is this happening? What is SQL Server storing in RAM that takes too much space and degrades the performance?
What can I do to avoid this? I'm trying to avoid restarting the SQLServer everytime this happens.
Thank you!