怎么察看SQL Server正在使用多少内存？

Question

比如用查询语句看，有多少memory正在被SQL Server使用？我们要加内存，所以加前后要看看SQL Server是否使用了新的内存和服务器用内存的状况

Answer 1

除了任务管理器呢？
我想在SQL Server中查看

Answer 2

谢谢，我dbcc memorystatus
可是有好多组，好多项，不知道怎么看总得整个SQL Server占用的memory?
Memory Manager                  KB 
------------------------------ --------------------
VM Reserved                    1064380
VM Committed                   147808
AWE Allocated                  0
Reserved Memory                1024
Reserved Memory In Use         0(5 row(s) affected)Memory node Id = 0              KB 
------------------------------ --------------------
VM Reserved                    1060220
VM Committed                   143800
AWE Allocated                  0
MultiPage Allocator            8272
SinglePage Allocator           65552(5 row(s) affected)MEMORYCLERK_SQLGENERAL (Total)                                    KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            1440
 MultiPage Allocator                                             1600(7 row(s) affected)MEMORYCLERK_SQLBUFFERPOOL (Total)                                 KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     1047772
 VM Committed                                                    132032
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            0
 MultiPage Allocator                                             256(7 row(s) affected)MEMORYCLERK_SQLOPTIMIZER (Total)                                  KB 
---------------------------------------------------------------- --------------------
 VM Reserved                                                     0
 VM Committed                                                    0
 AWE Allocated                                                   0
 SM Reserved                                                     0
 SM Commited                                                     0
 SinglePage Allocator                                            264
 MultiPage Allocator                                             72......................DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Answer 3

应该看这一部分就行
Memory Manager KB  
------------------------------ --------------------
VM Reserved 1064380
VM Committed 147808
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0(5 row(s) affected)