wi_wl0909 发表于 2014-09-03 13:52

Sybase 报错 求大神分析一下

00:00000:00024:2014/09/03 13:48:14.85 serverWARNING: memory usage in procedure headers (2)
does not match memory usage count in Pss (4) for server process id 24.
01:00000:00024:2014/09/03 13:48:18.42 serverWARNING: memory usage in procedure headers (2)
does not match memory usage count in Pss (0) for server process id 24.
00:00000:00024:2014/09/03 13:50:47.02 serverWARNING: memory usage in procedure headers (2)
does not match memory usage count in Pss (4) for server process id 24.
00:00000:00024:2014/09/03 13:50:48.08 serverWARNING: memory usage in procedure headers (2)
does not match memory usage count in Pss (0) for server process id 24.

memory   1539   167    1372   11%
系统内存大小是2G


数据库内存分配

Memory Usage:


                                 Meg.         2K Blks                Bytes

      Configured Memory:      1210.9375            620000         1269760000

            Code size:      15.7659            8073             16531752
      Kernel Structures:      17.5832            9003             18437332
      Server Structures:      25.1493             12877             26370914
         Cache Memory:       908.3242            465062            952446976
         Proc Buffers:      15.0797            7721             15812176
         Proc Headers:       229.0332            117265            240158720

wfcjz 发表于 2014-09-03 17:41

现在是什么问题？

wi_wl0909 发表于 2014-09-03 17:45

问题是开始总提示内存不足，通过调整数据库的分配内存后，就好了点，现在看日志就是有报错，想问问是什么原因

andkylee 发表于 2014-09-03 18:59

This is an informational message and does not result in any incorrect behavior.Upon detecting the memory count mismatch, Adaptive Server corrects the appropriate counter, completes the cleanup tasks, and continues processing.

The message can be eliminated with Trace Flag 720.Boot Adaptive Server with -T720 or set it while Adaptive Server is currently running with dbcc traceon(720).

Trace Flag 720 was introduced in CR# 255880

wi_wl0909 发表于 2014-09-04 10:36

好专业啊，谢谢大神，看懂了一点儿
页: [1]
查看完整版本: Sybase 报错 求大神分析一下