Chinaunix

标题: Sybase 报错 求大神分析一下 [打印本页]

作者: wi_wl0909    时间: 2014-09-03 13:52
标题: Sybase 报错 求大神分析一下
00:00000:00024:2014/09/03 13:48:14.85 server  WARNING: 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 server  WARNING: 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 server  WARNING: 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 server  WARNING: 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
好专业啊,谢谢大神,看懂了一点儿




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2