w3wp.exe service consumes excessive memory when PDshop is used with Microsoft's SQLOLEDB provider
Avoid using the "SQLOLEDB" provider when possible. Some PDshop users have experienced excessive memory usage when using this provider. Microsoft has confirmed there are memory leaks with this provider, unrelated to PDshop. We strongly recommend using the SQL Client connector instead.
SQL Client web.config example:
<add key="dbtype" value="MSSQL" />
<add key="dbconntype" value="SQL" />
<add key="dbconn" value="Server=localhost\SQLEXPRESS; Database=databasename; Uid=youruserid; Pwd=password; "/>
SQL Client web.config example:
<add key="dbtype" value="MSSQL" />
<add key="dbconntype" value="SQL" />
<add key="dbconn" value="Server=localhost\SQLEXPRESS; Database=databasename; Uid=youruserid; Pwd=password; "/>
Related Topics
Article Applies to:
ASP.NET (Microsoft's .NET)
Search for help...