Update improves DMV sys.dm_server_services and sys.dm_os_sys_info in SQL Server 2016

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Summary


This update makes the following changes in Microsoft SQL Server 2016:

  • Changes the data type of the "instant_file_initialization_enabled" column in the sys.dm_server_services dynamic management view from nvarchar(256) to nvarchar(2). Additionally, it becomes not nullable.
  • Changes the "sql_memory_model" column in the sys.dm_os_sys_info dynamic management view to be not nullable.
  • Changes the value "Conventional" of the "sql_memory_model_desc" column in the sys.dm_os_sys_info dynamic management view to all upper-cased ("CONVENTIONAL").

More information


This update is included in Cumulative Update 2 for SQL Server 2016 Service Pack 1.

References


Learn about the terminology Microsoft uses to describe software updates.