View FAQ
Frequently Asked Questions
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 
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.

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

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: 
Permanent Link 149