Kbase P62028: Can't update statistics
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
sysprogress is DBA, user "SQL92" has a reader profile.
SYMPTOM(s):
Can't update statistics
When updating statistics, the Db-connection is lost.
Dr. Watson "_sqlsrv2.exe access violation"
Error -20217
When starting the secondary broker with parameter -SQLStmtCache 16
caused the _sqlsrv2.exe to abort.
CAUSE:
The cache memory is not enough.
FIX:
Increasing -SQLSmtCache to 32