SQL Server内存数据库内部内存结构监视

We can use a variety of available options to keep systems performing at their very best. The SQL Server In-Memory OLTP technological advancement is a great innovation to relieve tempdb contentions.  This feature is available with an additional advantage to monitor systems without incurring stress on the database servers.

我们可以使用各种可用选项来使系统保持最佳性能。 SQL Server内存中OLTP技术的进步是减轻tempdb争用的一项伟大创新。 此功能具有附加优势，可以监视系统而又不会对数据库服务器造成压力。

 This article details: 

本文详细介绍：

1. The use of the SMSS standard report to get a quick view of the available resources
   使用SMSS标准报告快速查看可用资源
2. How T-SQL can be used to monitor SQL Server In-Memory databases
   如何使用T-SQL监视SQL Server内存数据库
3. Details the internal structure of memory consumers
   详细说明内存使用者的内部结构
4. Drive space management within the SQL Server using DMFs
   使用DMF在SQL Server中进行空间管理
5. Monitor In-Memory Containers from within SQL Server
   从SQL Server监视内存中的容器
6. How to get the details of In-Memory checkpoint mode
   如何获取内存中检查点模式的详细信息
7. The determination of used/free space within the In-Memory database
   确定内存数据库中的已用/可用空间
8. And more…
   和更多…

介绍 (Introduction)

As technology advances and the landscape shifts the relational database transactions from non-volatile to volatile spaces, the complexity of database monitoring and maintenance become more intense (and sometimes, tedious). This makes database monitoring and the evaluation of database metrics important. The purpose of monitoring and evaluation is to track the implementation and outputs systematically and measure the effectiveness of the standards, in order to determine exactly what change is needed and when.

随着技术的发展和格局的变化，关系数据库事务已从非易失性空间转变为易失性空间，数据库监视和维护的复杂性变得更加强烈（有时是乏味的）。 这使得数据库监视和数据库指标评估很重要。 监视和评估的目的是系统地跟踪实施和输出，并衡量标准的有效性，以便准确确定需要进行哪些更改以及何时进行更改。

入门 (Getting Started)

Let us see how the SSMS Standard Report can be used to get high-level details of SQL Server in-memory objects. The standard SSMS report, “Memory Usage by Memory Optimized Objects” shows the memory usage details of SQL Server In-Memory optimized objects.

让我们看看如何使用SSMS标准报告获取SQL Server内存对象的高级详细信息。 标准的SSMS报告“内存优化对象的内存使用情况”显示了SQL Server内存优化对象的内存使用情况详细信息。

To view the Memory Usage by Memory Optimized Objects report:

要查看“内存优化对象的内存使用情况”报告：

1. Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. 对象资源管理器”中 ，连接到SQL Server数据库引擎的实例，然后展开该实例。
2. Databases, and then click 数据库” ，然后单击Reports “报告”。
3. Select Memory Usage By Memory Optimized Objects
   
   
   
4. 通过内存优化对象选择内存使用率
   
   

The three sections of the Memory Usage by Memory Optimized Objects are listed below

下面列出了内存优化对象的内存使用情况的三个部分：

1. Using the DMV sys.dm_db_xtp_table_memory_stats we can derive the total memory allocated to Memory Optimized objects.

   使用DMV sys.dm_db_xtp_table_memory_stats，我们可以得出分配给“内存优化”对象的总内存。

   The Below SQL generates the output which can also be generated from the SSMS reports.

   下面SQL生成的输出也可以从SSMS报告中生成。

   IF
   (
       SELECT COUNT(1)
       FROM sys.data_spaces
       WHERE type = 'FX'
   ) > 0
       BEGIN
           SELECT SUM([Total used Memory MB] + [T