Article - CS229387
Microsoft SQL Server services need restart every 2 days leading to restart of the MSSQL$SQLEXPRESS, which in turns lead to users losing connection to Creo Elements/Direct Model Manager database server 19.0
Modified: 11-Apr-2016
Applies To
- Creo Elements/Direct Model Manager / Drawing Manager 19.00
- Microsoft SQL Server 2008
- Microsoft SQL Server 2008 R2
Description
- Microsoft SQL Server services need restart every 2 days leading to restart of the MSSQL$SQLEXPRESS, which in turns lead to users losing connection to Model Manager database server 19.0
- Following error is recorded in the Windows event log:
Event 701, MSSQL$SQLEXPRESS : There is insufficient system memory in resource pool 'internal' to run this query.
Event 18053, MSSQL$SQLEXPRESS: Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Event 18053, MSSQL$SQLEXPRESS: Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
- Issue is observed on Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2
This is a printer-friendly version of Article 229387 and may be out of date. For the latest version click CS229387