sql server 统计出来的内存，不管是这个，还是dbcc memorystatus，和进程管理器中内存差距很大，差不多有70G的差异。 具体原因不止，可能是内存泄漏，目前只能通过重启服务解决 Process/System Counts Value —————————————- ——————– Available Physical Memory 5337628672 Available Virtual Memory 8723028054016 Available Paging File 9299374080 Working Set 26316115968 Percent of Committed Memory in WS 100 Page Faults 12218866 System physical memory high 1 System physical memory low 0 Process physical memory low 0 Process virtual memory low 0 (10 rows affected) Memory Manager KB —————————————- ———– VM Reserved 70668820 VM Committed 25599992 Locked Pages Allocated 0 Large Pages Allocated 0 Emergency Memory 1024 Emergency Memory In Use 16 Target Committed 25600000 Current Committed 25599992 Pages Allocated 24728712 Pages Reserved 0 Pages Free 35552 Pages In Use 4883440 Page Alloc Potential 19436560 NUMA Growth Phase 2 Last OOM Factor 0 Last OS Error 0 (16 rows affected) Memory node Id = 0 KB —————————————- ———– VM Reserved 70668756 VM Committed 25599972 Locked Pages Allocated 0 Pages Allocated 24728712 Pages Free 35552 Target Committed 25599976 Current Committed 25599976 Foreign Committed 0 Away Committed 0 Taken Away Committed 0 (10 rows affected) Memory node Id = 64 KB —————————————- ———– VM Reserved 0 VM Committed 20 Locked Pages Allocated 0 (3 rows affected) MEMORYCLERK_SQLGENERAL (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 27480 (6 rows affected) MEMORYCLERK_SQLBUFFERPOOL (node 0) KB —————————————- ———– VM Reserved 12954432 VM Committed 655624 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 20682112 (6 rows affected) MEMORYCLERK_SQLQUERYEXEC (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 4448 (6 rows affected) MEMORYCLERK_SQLOPTIMIZER (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 1368 (6 rows affected) MEMORYCLERK_SQLUTILITIES (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 176 (6 rows affected) MEMORYCLERK_SQLSTORENG (node 0) KB —————————————- ———– VM Reserved 10048 VM Committed 10048 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 17200 (6 rows affected) MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 2608 (6 rows affected) MEMORYCLERK_SQLCLR (node 0) KB —————————————- ———– VM Reserved 6302848 VM Committed 17884 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 12384 (6 rows affected) MEMORYCLERK_SQLSERVICEBROKER (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 656 (6 rows affected) MEMORYCLERK_SQLHTTP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) MEMORYCLERK_SNI (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 144 (6 rows affected) MEMORYCLERK_SNI (node 64) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) MEMORYCLERK_SNI (Total) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 160 (6 rows affected) MEMORYCLERK_FULLTEXT (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 296 (6 rows affected) MEMORYCLERK_SQLXP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) MEMORYCLERK_BHF (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 208 (6 rows affected) MEMORYCLERK_XE_BUFFER (node 0) KB —————————————- ———– VM Reserved 4608 VM Committed 4608 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 0 (6 rows affected) MEMORYCLERK_XTP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) MEMORYCLERK_HOST (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 472 (6 rows affected) MEMORYCLERK_SOSNODE (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 55328 (6 rows affected) MEMORYCLERK_SOSNODE (node 64) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 2432 (6 rows affected) MEMORYCLERK_SOSNODE (Total) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 57760 (6 rows affected) MEMORYCLERK_SOSOS (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 192 (6 rows affected) MEMORYCLERK_SOSMEMMANAGER (node 0) KB —————————————- ———– VM Reserved 79224 VM Committed 79080 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 0 (6 rows affected) MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 96 SM Committed 96 Pages Allocated 0 (6 rows affected) MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB ———————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 192 (6 rows affected) MEMORYCLERK_FILETABLE (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) MEMORYCLERK_XE (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 3880 (6 rows affected) MEMORYCLERK_SQLLOGPOOL (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 15224 (6 rows affected) MEMORYCLERK_LWC (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 32 (6 rows affected) MEMORYCLERK_FSCHUNKER (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 48 (6 rows affected) CACHESTORE_OBJCP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 203560 (6 rows affected) CACHESTORE_SQLCP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 3322304 (6 rows affected) CACHESTORE_PHDR (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 96720 (6 rows affected) CACHESTORE_XPROC (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 208 (6 rows affected) CACHESTORE_TEMPTABLES (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 136 (6 rows affected) CACHESTORE_NOTIF (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) CACHESTORE_VIEWDEFINITIONS (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) CACHESTORE_XMLDBTYPE (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_XMLDBELEMENT (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_XMLDBATTRIBUTE (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_STACKFRAMES (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_STACKFRAMES (node 64) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_STACKFRAMES (Total) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) CACHESTORE_BROKERTBLACS (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 240 (6 rows affected) CACHESTORE_BROKERKEK (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_BROKERDSH (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_BROKERRSB (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_BROKERREADONLY (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 80 (6 rows affected) CACHESTORE_BROKERTO (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) CACHESTORE_EVENTS (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) CACHESTORE_CLRPROC (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 104 (6 rows affected) CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB —————————————– ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 2032 (6 rows affected) CACHESTORE_SYSTEMROWSET (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 4944 (6 rows affected) CACHESTORE_CONVPRI (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 80 (6 rows affected) CACHESTORE_FULLTEXTSTOPLIST (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 32 (6 rows affected) CACHESTORE_SEARCHPROPERTYLIST (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 16 (6 rows affected) CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB —————————————– ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 32 (6 rows affected) CACHESTORE_XML_SELECTIVE_DG (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 8 (6 rows affected) USERSTORE_SCHEMAMGR (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 58736 (6 rows affected) USERSTORE_DBMETADATA (node 0) KB —————————————- ———– VM Reserved 0 VM Committed 0 Locked Pages Allocated 0 SM Reserved 0 SM Committed 0 Pages Allocated 26616 (6 rows affected) USERSTORE_TOKENPERM (node 0)
赞
(0)
打赏
微信扫一扫
相关文章:
-
MSSQL 附加数据库提示“错误 823”数据恢复实操
故障：数据库报错：“mssql server 2000 附加数据库错误823”，附加数据库失败。故障分析：数据库出现“823”报错信…
2022年03月05日 • 数据库
碎片拼接技术恢复XenServer服务器SQL Server数据库数据
环境：dell poweredge服务器；xenserver虚拟化平台；4块希捷2t stat硬盘用raid卡组成的raid10；xenserver虚拟机操作系统：window…
2022年03月04日 • 数据库
sqlserver数据库加密后无法使用MDF,LDF,log文件名称被修改的数据恢复
故障：2个sql server数据库被加密，无法使用。数据库mdf、ldf、log日志文件名字被修改，如下图：数据库备份被加密，文件名字被修改。管理员联系北亚数据恢复中心进行数…
2022年03月04日 • 数据库
SQL Server查询某个字段在哪些表中存在
一、查询sql server中所有的表sql语句：name列表示所有的表名。二、查询sql server中所有的列sql语句：name列表示所有的字段名称。两张… [阅读全文]
SQL行转列与列转行
1.数据集以”连续登录”中的数据为例：结果：+—+——————————————-… [阅读全文]
版权声明：本文内容由互联网用户贡献，该文观点仅代表作者本人。本站仅提供信息存储服务，不拥有所有权，不承担相关法律责任。 如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 2386932994@qq.com 举报，一经查实将立刻删除。
发表评论
| 验证码： |
|---|