数据库无法使用:Failed to reserve contiguous memory of Size= 65536
2008-01-25 09:27:49.31 spid52 WARNING: Failed to reserve contiguous memory of Size= 65536.
2008-01-25 09:27:49.32 spid52 Buffer Distribution: Stolen=1076 Free=328 Procedures=16794
Inram=0 Dirty=560 Kept=0
I/O=0, Latched=297, Other=4961
2008-01-25 09:27:49.32 spid52 Buffer Counts: Commited=24016 Target=207864 Hashed=5818
InternalReservation=167 ExternalReservation=48 Min Free=128 Visible= 207864
2008-01-25 09:27:49.32 spid52 Procedure Cache: TotalProcs=4475 TotalPages=16794 InUsePages=7351
2008-01-25 09:27:49.32 spid52 Dynamic Memory Manager: Stolen=17859 OS Reserved=920
OS Committed=898
OS In Use=894
Query Plan=16692 Optimizer=0
General=1929
Utilities=12 Connection=67
2008-01-25 09:27:49.32 spid52 Global Memory Objects: Resource=1537 Locks=50
SQLCache=191 Replication=2
LockBytes=2 ServerGlobal=20
Xact=15
2008-01-25 09:27:49.32 spid52 Query Memory Manager: Grants=1 Waiting=0 Maximum=149587 Available=149529
环境:
W2KServer SQl2000 SP4
不定时数据库服务器无法访问,每天都要重启一下SQL才能继续运行。能帮忙分析下原因吗?网上查了很久,试了很多方法还是没解决。
[解决办法]
最近我们公司的SQL数据库也出现不定时数据库无法访问的情况,后来发现是DTC调度问题,通过配置服务的数据源JDBC连接方式由DTC方式改为直连方式解决了。