Velocity Technical Archive
sbs memory issues
Archived Reference: This is a historical technical article preserved from the Velocity Technologies knowledge base. For current Phoenix and East Valley managed IT services, explore our managed IT services or cybersecurity solutions.
Okay, so what does tasklist /svc from a command prompt tell us?\nAh ha...it's our Firewall monitoring service ....see that MSSQL$MSFW? That's our ISA server monitoring that indeed needs to be throttled.\nIf you've checked out the instructions on the SBS 2003 sp1 document , you'll know that the recommendation is to perform a command to throttle that instance. So we open a command prompt and do the following:\nOpen a command prompt and type in the following instructions:\nOsql –E –S %computername%MSFW\nsp_configure ‘show advanced options’,1\nreconfigure with override\ngo\nsp_configure ‘max server memory’,NNNN (Where NNNN is the amount of ram in mb. Recommended amount is 100 MB for SBS)\nreconfigure with override\ngo\nand end the command with\nexit\nAs you can see the commit charge has now gone way down.\nAnd you can see that PID 1612 is no longer sucking that memory.\nAnd I'm once again a happy camper... along with my SBS box.\n