Windows 2003
SQL Server 2000 SP4 8.0.2055
在log中发现一些错误如下, 机器内存为 40G , 分配给SQL Server的为30G, 设置了AWE大内存 。 不知道
是否设置AWE的问题 ? 查询了一下, 是 Bug #: 364188 (SHILOH_BUGS) ,
详见 http://support.microsoft.com/kb/815114 FIX: 额外的优化内存消耗量可能出现的具有多个 OUTER 联接的查询
但是后面说明: 此问题最早在 Microsoft SQL Server 2000 Service Pack 4 中得到了解决。 我们的SQL Server2000已经是
SP4 8.0.2055 了 , 怎么还会出这样的问题呢 ?
2009-07-30 14:51:21.96 spid102 Dynamic Memory Manager: Stolen=133353 OS Reserved=1160 ...
2009-07-30 14:51:21.96 spid102 Procedure Cache: TotalProcs=59524 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.96 spid102 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.96 spid102 Buffer Distribution: Stolen=46640 Free=21890 Procedures=86713...
2009-07-30 14:51:21.95 spid131 Insufficient memory available..
2009-07-30 14:51:21.95 spid131 Error: 17803, Severity: 20, State: 8
2009-07-30 14:51:21.95 spid131 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.95 spid131 Global Memory Objects: Resource=2650 Locks=229 ...
2009-07-30 14:51:21.95 spid131 Dynamic Memory Manager: Stolen=133360 OS Reserved=1160 ...
2009-07-30 14:51:21.95 spid131 Procedure Cache: TotalProcs=59520 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.95 spid131 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.95 spid131 Buffer Distribution: Stolen=46648 Free=21882 Procedures=86713...
2009-07-30 14:51:21.87 spid133 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.87 spid133 Global Memory Objects: Resource=2656 Locks=229 ...
2009-07-30 14:51:21.87 spid133 Dynamic Memory Manager: Stolen=137409 OS Reserved=1160 ...
2009-07-30 14:51:21.87 spid133 Procedure Cache: TotalProcs=61063 TotalPages=90746 InUsePages=42484
2009-07-30 14:51:21.87 spid133 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.87 spid133 Buffer Distribution: Stolen=46675 Free=17822 Procedures=90746...
2009-07-30 14:51:21.76 spid100 Insufficient memory available..
2009-07-30 14:51:21.76 spid100 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.76 spid100 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.76 spid100 Global Memory Objects: Resource=2660 Locks=229 ...
2009-07-30 14:51:21.76 spid100 Dynamic Memory Manager: Stolen=144657 OS Reserved=1160 ...
2009-07-30 14:51:21.76 spid100 Procedure Cache: TotalProcs=62931 TotalPages=97986 InUsePages=45735
2009-07-30 14:51:21.76 spid100 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.76 spid100 Buffer Distribution: Stolen=46688 Free=10569 Procedures=97986...
2009-07-30 14:51:21.73 spid111 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.73 spid111 Global Memory Objects: Resource=2661 Locks=229 ...
2009-07-30 14:51:21.73 spid111 Dynamic Memory Manager: Stolen=146582 OS Reserved=1160 ...
2009-07-30 14:51:21.73 spid111 Procedure Cache: TotalProcs=62220 TotalPages=99845 InUsePages=46448
2009-07-30 14:51:21.73 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.73 spid111 Buffer Distribution: Stolen=46748 Free=8653 Procedures=99845...
2009-07-30 14:51:21.63 spid124 Insufficient memory available..
2009-07-30 14:51:21.63 spid124 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.63 spid124 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid124 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid124 Dynamic Memory Manager: Stolen=152744 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid124 Procedure Cache: TotalProcs=63806 TotalPages=105919 InUsePages=49532
2009-07-30 14:51:21.63 spid124 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid124 Buffer Distribution: Stolen=46944 Free=2380 Procedures=105919...
2009-07-30 14:51:21.63 spid67 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid134 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid67 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid134 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid67 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid134 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid67 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid134 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid67 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid134 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid67 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 spid134 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 server Insufficient memory available..
2009-07-30 14:51:21.63 server Error: 17803, Severity: 20, State: 14
2009-07-30 14:51:21.63 server Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 server Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 server Dynamic Memory Manager: Stolen=152911 OS Reserved=1160 ...
2009-07-30 14:51:21.63 server Procedure Cache: TotalProcs=63805 TotalPages=106074 InUsePages=49628
2009-07-30 14:51:21.63 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 server Buffer Distribution: Stolen=46947 Free=2222 Procedures=106074...
2009-07-30 14:51:21.60 spid127 BPool::Map: no remappable address found.
2009-07-30 14:51:21.60 spid115 BPool::Map: no remappable address found.
2009-07-30 14:51:21.59 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.56 spid111 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.56 spid111 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.56 spid111 Dynamic Memory Manager: Stolen=155138 OS Reserved=1160 ...
2009-07-30 14:51:21.56 spid111 Procedure Cache: TotalProcs=63819 TotalPages=108288 InUsePages=50762
2009-07-30 14:51:21.56 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776916...
2009-07-30 14:51:21.56 spid111 Buffer Distribution: Stolen=46955 Free=0 Procedures=108288...
2009-07-30 14:51:21.51 spid71 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid102 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid119 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid136 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid134 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid133 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 spid100 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server 3 pages have a bstat of 000209
2009-07-30 14:51:21.43 server 103 pages have a bstat of 00000b
2009-07-30 14:51:21.43 server 268 pages have a bstat of 000009
2009-07-30 14:51:21.43 server 63819 pages have a bstat of 001001
2009-07-30 14:51:21.43 server 91415 pages have a bstat of 000000
2009-07-30 14:51:21.41 server There are 155608 pages in the AWE window
2009-07-30 14:51:21.41 server AWE mapping status:
2009-07-30 14:51:21.41 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid131 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid67 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid69 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid124 BPool::Map: no remappable address found.
2009-07-30 14:50:06.27 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 14:45:04.05 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:45:03.18 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:44:10.64 spid99 Insufficient memory available..
2009-07-30 11:44:10.64 spid99 Error: 17803, Severity: 20, State: 8
2009-07-30 11:44:10.64 spid99 Query Memory Manager: Grants=2 Waiting=0 Maximum=30163 Available=29943
2009-07-30 11:44:10.64 spid99 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid99 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid99 Procedure Cache: TotalProcs=63112 TotalPages=101774 InUsePages=46494
2009-07-30 11:44:10.64 spid99 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid99 Buffer Distribution: Stolen=52285 Free=1194 Procedures=101774...
2009-07-30 11:44:10.64 spid89 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.64 spid89 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid89 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid89 Procedure Cache: TotalProcs=63239 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.64 spid89 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid89 Buffer Distribution: Stolen=52282 Free=1194 Procedures=101777...
2009-07-30 11:44:10.53 spid78 Insufficient memory available..
2009-07-30 11:44:10.53 spid78 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid78 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid78 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid78 Dynamic Memory Manager: Stolen=151088 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid78 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid78 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid78 Buffer Distribution: Stolen=49427 Free=4049 Procedures=101777...
2009-07-30 11:44:10.53 spid119 Insufficient memory available..
2009-07-30 11:44:10.53 spid119 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid119 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid119 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid119 Dynamic Memory Manager: Stolen=151051 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid119 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid119 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid119 Buffer Distribution: Stolen=49405 Free=4071 Procedures=101777...
2009-07-30 11:44:10.51 spid113 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.51 spid113 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.51 spid113 Dynamic Memory Manager: Stolen=150592 OS Reserved=1160 ...
2009-07-30 11:44:10.51 spid113 Procedure Cache: TotalProcs=64144 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.51 spid113 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.51 spid113 Buffer Distribution: Stolen=48932 Free=4544 Procedures=101777...
2009-07-30 11:44:10.50 spid79 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.50 spid79 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.50 spid79 Dynamic Memory Manager: Stolen=150182 OS Reserved=1160 ...
2009-07-30 11:44:10.50 spid79 Procedure Cache: TotalProcs=64326 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.50 spid79 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.50 spid79 Buffer Distribution: Stolen=48517 Free=4959 Procedures=101777...
2009-07-30 11:44:10.45 spid69 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid69 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid69 Dynamic Memory Manager: Stolen=148599 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid69 Procedure Cache: TotalProcs=64912 TotalPages=101764 InUsePages=46494
2009-07-30 11:44:10.45 spid69 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid69 Buffer Distribution: Stolen=47052 Free=6437 Procedures=101764...
2009-07-30 11:44:10.45 spid109 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid109 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid109 Dynamic Memory Manager: Stolen=148597 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid109 Procedure Cache: TotalProcs=64129 TotalPages=101761 InUsePages=46494
2009-07-30 11:44:10.45 spid109 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid109 Buffer Distribution: Stolen=47053 Free=6439 Procedures=101761...
2009-07-30 11:44:10.43 spid115 Insufficient memory available..
2009-07-30 11:44:10.43 spid115 Error: 17803, Severity: 20, State: 12
2009-07-30 11:44:10.43 spid115 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid126 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid115 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid126 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid115 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid126 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid115 Procedure Cache: TotalProcs=64666 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid126 Procedure Cache: TotalProcs=64612 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid115 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid126 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid115 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.43 spid126 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.39 spid112 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.39 spid112 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.39 spid112 Dynamic Memory Manager: Stolen=150401 OS Reserved=1160 ...
2009-07-30 11:44:10.39 spid112 Procedure Cache: TotalProcs=65207 TotalPages=103561 InUsePages=47324
2009-07-30 11:44:10.39 spid112 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.39 spid112 Buffer Distribution: Stolen=47065 Free=4627 Procedures=103561...
2009-07-30 11:44:10.31 server Insufficient memory available..
2009-07-30 11:44:10.31 server Error: 17803, Severity: 20, State: 14
2009-07-30 11:44:10.31 spid95 Insufficient memory available..
2009-07-30 11:44:10.31 spid95 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.31 spid95 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.31 spid95 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.31 spid95 Dynamic Memory Manager: Stolen=153217 OS Reserved=1160 ...
2009-07-30 11:44:10.31 spid95 Procedure Cache: TotalProcs=65654 TotalPages=106363 InUsePages=48694
2009-07-30 11:44:10.31 spid95 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.31 spid95 Buffer Distribution: Stolen=47082 Free=1808 Procedures=106363...
2009-07-30 11:44:10.29 server Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.29 server Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.29 server Dynamic Memory Manager: Stolen=153317 OS Reserved=1160 ...
2009-07-30 11:44:10.29 server Procedure Cache: TotalProcs=65654 TotalPages=106461 InUsePages=48752
2009-07-30 11:44:10.29 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.29 server Buffer Distribution: Stolen=47083 Free=1709 Procedures=106461...
2009-07-30 11:44:10.21 spid119 BPool::Map: no remappable address found.
2009-07-30 11:44:10.20 spid99 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid109 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid69 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 3 pages have a bstat of 000209
2009-07-30 11:44:10.17 spid126 116 pages have a bstat of 00000b
2009-07-30 11:44:10.17 spid126 270 pages have a bstat of 000009
2009-07-30 11:44:10.17 spid126 65671 pages have a bstat of 001001
2009-07-30 11:44:10.17 spid126 89548 pages have a bstat of 000000
2009-07-30 11:44:10.17 spid126 There are 155608 pages in the AWE window
2009-07-30 11:44:10.17 spid126 AWE mapping status:
2009-07-30 11:44:10.17 spid79 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid95 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 server BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid115 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid78 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid89 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid112 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid113 BPool::Map: no remappable address found.
2009-07-30 11:40:04.69 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:35:03.02 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
SQL Server 2000 SP4 8.0.2055
在log中发现一些错误如下, 机器内存为 40G , 分配给SQL Server的为30G, 设置了AWE大内存 。 不知道
是否设置AWE的问题 ? 查询了一下, 是 Bug #: 364188 (SHILOH_BUGS) ,
详见 http://support.microsoft.com/kb/815114 FIX: 额外的优化内存消耗量可能出现的具有多个 OUTER 联接的查询
但是后面说明: 此问题最早在 Microsoft SQL Server 2000 Service Pack 4 中得到了解决。 我们的SQL Server2000已经是
SP4 8.0.2055 了 , 怎么还会出这样的问题呢 ?
2009-07-30 14:51:21.96 spid102 Dynamic Memory Manager: Stolen=133353 OS Reserved=1160 ...
2009-07-30 14:51:21.96 spid102 Procedure Cache: TotalProcs=59524 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.96 spid102 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.96 spid102 Buffer Distribution: Stolen=46640 Free=21890 Procedures=86713...
2009-07-30 14:51:21.95 spid131 Insufficient memory available..
2009-07-30 14:51:21.95 spid131 Error: 17803, Severity: 20, State: 8
2009-07-30 14:51:21.95 spid131 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.95 spid131 Global Memory Objects: Resource=2650 Locks=229 ...
2009-07-30 14:51:21.95 spid131 Dynamic Memory Manager: Stolen=133360 OS Reserved=1160 ...
2009-07-30 14:51:21.95 spid131 Procedure Cache: TotalProcs=59520 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.95 spid131 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.95 spid131 Buffer Distribution: Stolen=46648 Free=21882 Procedures=86713...
2009-07-30 14:51:21.87 spid133 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.87 spid133 Global Memory Objects: Resource=2656 Locks=229 ...
2009-07-30 14:51:21.87 spid133 Dynamic Memory Manager: Stolen=137409 OS Reserved=1160 ...
2009-07-30 14:51:21.87 spid133 Procedure Cache: TotalProcs=61063 TotalPages=90746 InUsePages=42484
2009-07-30 14:51:21.87 spid133 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.87 spid133 Buffer Distribution: Stolen=46675 Free=17822 Procedures=90746...
2009-07-30 14:51:21.76 spid100 Insufficient memory available..
2009-07-30 14:51:21.76 spid100 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.76 spid100 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.76 spid100 Global Memory Objects: Resource=2660 Locks=229 ...
2009-07-30 14:51:21.76 spid100 Dynamic Memory Manager: Stolen=144657 OS Reserved=1160 ...
2009-07-30 14:51:21.76 spid100 Procedure Cache: TotalProcs=62931 TotalPages=97986 InUsePages=45735
2009-07-30 14:51:21.76 spid100 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.76 spid100 Buffer Distribution: Stolen=46688 Free=10569 Procedures=97986...
2009-07-30 14:51:21.73 spid111 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.73 spid111 Global Memory Objects: Resource=2661 Locks=229 ...
2009-07-30 14:51:21.73 spid111 Dynamic Memory Manager: Stolen=146582 OS Reserved=1160 ...
2009-07-30 14:51:21.73 spid111 Procedure Cache: TotalProcs=62220 TotalPages=99845 InUsePages=46448
2009-07-30 14:51:21.73 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.73 spid111 Buffer Distribution: Stolen=46748 Free=8653 Procedures=99845...
2009-07-30 14:51:21.63 spid124 Insufficient memory available..
2009-07-30 14:51:21.63 spid124 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.63 spid124 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid124 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid124 Dynamic Memory Manager: Stolen=152744 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid124 Procedure Cache: TotalProcs=63806 TotalPages=105919 InUsePages=49532
2009-07-30 14:51:21.63 spid124 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid124 Buffer Distribution: Stolen=46944 Free=2380 Procedures=105919...
2009-07-30 14:51:21.63 spid67 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid134 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid67 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid134 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid67 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid134 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid67 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid134 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid67 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid134 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid67 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 spid134 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 server Insufficient memory available..
2009-07-30 14:51:21.63 server Error: 17803, Severity: 20, State: 14
2009-07-30 14:51:21.63 server Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 server Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 server Dynamic Memory Manager: Stolen=152911 OS Reserved=1160 ...
2009-07-30 14:51:21.63 server Procedure Cache: TotalProcs=63805 TotalPages=106074 InUsePages=49628
2009-07-30 14:51:21.63 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 server Buffer Distribution: Stolen=46947 Free=2222 Procedures=106074...
2009-07-30 14:51:21.60 spid127 BPool::Map: no remappable address found.
2009-07-30 14:51:21.60 spid115 BPool::Map: no remappable address found.
2009-07-30 14:51:21.59 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.56 spid111 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.56 spid111 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.56 spid111 Dynamic Memory Manager: Stolen=155138 OS Reserved=1160 ...
2009-07-30 14:51:21.56 spid111 Procedure Cache: TotalProcs=63819 TotalPages=108288 InUsePages=50762
2009-07-30 14:51:21.56 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776916...
2009-07-30 14:51:21.56 spid111 Buffer Distribution: Stolen=46955 Free=0 Procedures=108288...
2009-07-30 14:51:21.51 spid71 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid102 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid119 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid136 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid134 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid133 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 spid100 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server 3 pages have a bstat of 000209
2009-07-30 14:51:21.43 server 103 pages have a bstat of 00000b
2009-07-30 14:51:21.43 server 268 pages have a bstat of 000009
2009-07-30 14:51:21.43 server 63819 pages have a bstat of 001001
2009-07-30 14:51:21.43 server 91415 pages have a bstat of 000000
2009-07-30 14:51:21.41 server There are 155608 pages in the AWE window
2009-07-30 14:51:21.41 server AWE mapping status:
2009-07-30 14:51:21.41 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid131 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid67 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid69 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid124 BPool::Map: no remappable address found.
2009-07-30 14:50:06.27 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 14:45:04.05 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:45:03.18 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:44:10.64 spid99 Insufficient memory available..
2009-07-30 11:44:10.64 spid99 Error: 17803, Severity: 20, State: 8
2009-07-30 11:44:10.64 spid99 Query Memory Manager: Grants=2 Waiting=0 Maximum=30163 Available=29943
2009-07-30 11:44:10.64 spid99 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid99 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid99 Procedure Cache: TotalProcs=63112 TotalPages=101774 InUsePages=46494
2009-07-30 11:44:10.64 spid99 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid99 Buffer Distribution: Stolen=52285 Free=1194 Procedures=101774...
2009-07-30 11:44:10.64 spid89 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.64 spid89 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid89 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid89 Procedure Cache: TotalProcs=63239 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.64 spid89 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid89 Buffer Distribution: Stolen=52282 Free=1194 Procedures=101777...
2009-07-30 11:44:10.53 spid78 Insufficient memory available..
2009-07-30 11:44:10.53 spid78 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid78 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid78 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid78 Dynamic Memory Manager: Stolen=151088 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid78 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid78 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid78 Buffer Distribution: Stolen=49427 Free=4049 Procedures=101777...
2009-07-30 11:44:10.53 spid119 Insufficient memory available..
2009-07-30 11:44:10.53 spid119 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid119 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid119 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid119 Dynamic Memory Manager: Stolen=151051 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid119 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid119 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid119 Buffer Distribution: Stolen=49405 Free=4071 Procedures=101777...
2009-07-30 11:44:10.51 spid113 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.51 spid113 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.51 spid113 Dynamic Memory Manager: Stolen=150592 OS Reserved=1160 ...
2009-07-30 11:44:10.51 spid113 Procedure Cache: TotalProcs=64144 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.51 spid113 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.51 spid113 Buffer Distribution: Stolen=48932 Free=4544 Procedures=101777...
2009-07-30 11:44:10.50 spid79 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.50 spid79 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.50 spid79 Dynamic Memory Manager: Stolen=150182 OS Reserved=1160 ...
2009-07-30 11:44:10.50 spid79 Procedure Cache: TotalProcs=64326 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.50 spid79 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.50 spid79 Buffer Distribution: Stolen=48517 Free=4959 Procedures=101777...
2009-07-30 11:44:10.45 spid69 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid69 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid69 Dynamic Memory Manager: Stolen=148599 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid69 Procedure Cache: TotalProcs=64912 TotalPages=101764 InUsePages=46494
2009-07-30 11:44:10.45 spid69 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid69 Buffer Distribution: Stolen=47052 Free=6437 Procedures=101764...
2009-07-30 11:44:10.45 spid109 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid109 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid109 Dynamic Memory Manager: Stolen=148597 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid109 Procedure Cache: TotalProcs=64129 TotalPages=101761 InUsePages=46494
2009-07-30 11:44:10.45 spid109 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid109 Buffer Distribution: Stolen=47053 Free=6439 Procedures=101761...
2009-07-30 11:44:10.43 spid115 Insufficient memory available..
2009-07-30 11:44:10.43 spid115 Error: 17803, Severity: 20, State: 12
2009-07-30 11:44:10.43 spid115 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid126 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid115 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid126 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid115 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid126 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid115 Procedure Cache: TotalProcs=64666 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid126 Procedure Cache: TotalProcs=64612 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid115 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid126 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid115 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.43 spid126 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.39 spid112 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.39 spid112 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.39 spid112 Dynamic Memory Manager: Stolen=150401 OS Reserved=1160 ...
2009-07-30 11:44:10.39 spid112 Procedure Cache: TotalProcs=65207 TotalPages=103561 InUsePages=47324
2009-07-30 11:44:10.39 spid112 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.39 spid112 Buffer Distribution: Stolen=47065 Free=4627 Procedures=103561...
2009-07-30 11:44:10.31 server Insufficient memory available..
2009-07-30 11:44:10.31 server Error: 17803, Severity: 20, State: 14
2009-07-30 11:44:10.31 spid95 Insufficient memory available..
2009-07-30 11:44:10.31 spid95 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.31 spid95 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.31 spid95 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.31 spid95 Dynamic Memory Manager: Stolen=153217 OS Reserved=1160 ...
2009-07-30 11:44:10.31 spid95 Procedure Cache: TotalProcs=65654 TotalPages=106363 InUsePages=48694
2009-07-30 11:44:10.31 spid95 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.31 spid95 Buffer Distribution: Stolen=47082 Free=1808 Procedures=106363...
2009-07-30 11:44:10.29 server Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.29 server Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.29 server Dynamic Memory Manager: Stolen=153317 OS Reserved=1160 ...
2009-07-30 11:44:10.29 server Procedure Cache: TotalProcs=65654 TotalPages=106461 InUsePages=48752
2009-07-30 11:44:10.29 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.29 server Buffer Distribution: Stolen=47083 Free=1709 Procedures=106461...
2009-07-30 11:44:10.21 spid119 BPool::Map: no remappable address found.
2009-07-30 11:44:10.20 spid99 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid109 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid69 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 3 pages have a bstat of 000209
2009-07-30 11:44:10.17 spid126 116 pages have a bstat of 00000b
2009-07-30 11:44:10.17 spid126 270 pages have a bstat of 000009
2009-07-30 11:44:10.17 spid126 65671 pages have a bstat of 001001
2009-07-30 11:44:10.17 spid126 89548 pages have a bstat of 000000
2009-07-30 11:44:10.17 spid126 There are 155608 pages in the AWE window
2009-07-30 11:44:10.17 spid126 AWE mapping status:
2009-07-30 11:44:10.17 spid79 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid95 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 server BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid115 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid78 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid89 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid112 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid113 BPool::Map: no remappable address found.
2009-07-30 11:40:04.69 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:35:03.02 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-662561/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-662561/