We have a 3 tier ASP based application running IIS 5 in the Frontend & SQL 2000 in the backend. COM+ is running in middle tier. Clients are using this application over the internet.
The OS is Win2000 SP3 with SQL 2000 SP3 with all latest updates.
The problem we are facing for few days is that SQL server process (SQLSerVr.exe) is taking too much memory. Once SQL memory consumption start rising, it doesn’t come back to normal untill we restart the server.
The server has got 1 gig of memory. We have checked the SQL in detail but nothing suspicious has been found. We’ve even deployed the DB on another server but still the same issue on the new server as well.
We have scanned the servers for viruses well & nothing found. There are few errors in EventViewer, but nothing related to SQL server.
Now we need to know:
1) Any idea what is cauing SQL to behave in this way?
2) Is there a way we can check what processes, threads & handles are runnning inside SQLSrvVe.exe process?
3) How to detect identify this SQL problem?
Your comments & suggestions are are highly appreciated.
