MikeASchreiner
asked on
SBS 2003 sqlservr.exe service memory keeps building!
I'm having issues with my SBS 2003 sqlservr.exe service. There are 2 of these services running and 1 of them keeps building or holding memory. It gets to a point where I start recieving critical alerts. I go in and stop and restart the service to release the memory. I have to do this about every 3 or 4 days. Does anyone have any suggestions on why this keeps building up memory?
ASKER
hello itcoza,
I restarted the mssqlsbsmonitoring service and it restarted the SQL service that was hogging the most memory.
Should SQL Service Manager be Running the monitoring service? As it is running in the icon tray with a green triangle.
I restarted the mssqlsbsmonitoring service and it restarted the SQL service that was hogging the most memory.
Should SQL Service Manager be Running the monitoring service? As it is running in the icon tray with a green triangle.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll run the wizzard again and let you know what happens.
The alerts are not exeptional, you can kill the alerts or modify the database see http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx for the latter.
ASKER
Ok I re-ran the wizzard and I'm holding around 188,000K after 24 hours. It was getting up to 300,000K to 500,000K before so I think we got it under control now.
If you go to the services MMC. There should be more than one SQL service (server) running there. Once you have the problem again, you can restart any one of them to identify what one is causing the problem. This way at least one can address the correct instance of the databases. My feeling is that it is the DB that stores the SBS monitoring data.
Regards,
M