View FAQ
Frequently Asked Questions
Search
Keyword
Categories
Categories
WebWatchBot General 
NetMailBot General 
Website - General  
NetMailBot Performance 
Watch Item Settings/Configuration 
WebWatchBot Email Settings/Configuration 
NetMailBot Mail Merge & Using a Database 
NetMailBot - Attachments 
WebWatchBot Connectivity - Network - Firewalls 
WebWatchBot Known Issues 
NetMailBot Installation 
NetMailBot Known Issues 
WebWatchBot Installation 
WebWatchBot Errors (Not Relating to Installation) 
WebWatchBot Known Issues - Resolved 
WebWatchBot Performance 
Article
Category WebWatchBot Performance 
Question/Issue SQL Server uses a large amount of memory (memory leak) 
Answer/Solution SYMPTOMS
Applies to: WebWatchBot installations with SQL Server as the back-end database.

Over a period of time, the SQL Server process (sqlservr.exe) consumes a large amount of memory and can appear to be a memory leak because memory consumption increases consistantly.

CAUSE
SQL Server manages memory and will increase usage as configured. By default SQL Server can use up to the total amount of physical memory.

RESOLUTION
To limit the maximum amount of memory that SQL Server can use, please refer to the Microsoft KB article on configuring SQL Server Memory Usage: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_9zfy.asp 
Permanent Link 149