SQL Server 2017 is officially out, and here’s what I’ve found so far.

New Wait Stats in 2017

• BACKUP_INMEM_DIFFLIST_READ_ACCESS
• BACKUP_INMEM_DIFFLIST_WRITE_ACCESS
• BLOB_CONTAINER_TABLE
• COLUMNSTORE_MIGRATION_BACKGROUND_TASK
• EXTERNAL_SCRIPT_NETWORK_IO
• FOREIGN_REDO
• GHOSTCLEANUP_UPDATE_STATS
• GLOBAL_QUERY_CANCEL
• GLOBAL_QUERY_CONSUMER
• GLOBAL_QUERY_PRODUCER
• HADR_THROTTLE_LOG_RATE_LOG_SIZE
• HADR_THROTTLE_LOG_RATE_SEEDING
• HADR_THROTTLE_LOG_RATE_SEND_RECV_QUEUE_SIZE
• MEMORY_GRANT_UPDATE
• MIGRATIONBUFFER
• PREEMPTIVE_OS_BCRYPTIMPORTKEY
• PREEMPTIVE_OS_NCRYPTIMPORTKEY
• PREEMPTIVE_XE_PROXY_ADDSESSION
• PREEMPTIVE_XE_PROXY_PROCESSBUFFER
• PREEMPTIVE_XE_PROXY_REMOVESESSION
• PREEMPTIVE_XE_PROXY_SESSIONCOMMIT
• PWAIT_AUDIT_CLOSE_EXPIRED_LOGS_MGR_RWLOCK
• PWAIT_AUDIT_SESSIONS_LOCK
• PWAIT_EXTERNAL_SCRIPT_LIBMGMT_DIR_PERMS
• PWAIT_PREEMPTIVE_APP_USAGE_TIMER
• PWAIT_PREEMPTIVE_XE_STUB_LISTENER
• PWAIT_SBS_FILE_OPERATION
• QDS_HOST_INIT
• RBIO_WAIT_VLF
• REMOTE_BLOCK_IO
• RESTORE_MSDA_THREAD_BARRIER
• SBS_DISPATCH
• SBS_RECEIVE_TRANSPORT
• SBS_TRANSPORT
• SECURITY_CNG_PROVIDER_MUTEX
• SLEEP_SETUP
• SNI_WRITE_ASYNC
• TEMPORAL_BACKGROUND_PROCEED_CLEANUP
• UCS_CNG_PROVIDER_MUTEX
• WAIT_XLOGREAD_SIGNAL
• WAIT_XTP_COMPILE_WAIT
• WAIT_XTP_SERIAL_RECOVERY
• XE_STUBMGR_CLOSE
• XIO_EDS_MGR_RWLOCK
• XIO_EDS_RWLOCK
• XIO_IOSTATS_BLOBLIST_RWLOCK
• XIO_IOSTATS_FCBLIST_RWLOCK

New Management Objects & Columns in 2017

I’m doing a join between a 2017 RTM server’s sys.all_columns over to a 2016 SP1 server’s, and looking for the newly added rows. I’m hyperlinking to relevant documentation that you might find interesting, too.

Internal tables & columns:

• _trusted_assemblies.create_date
• _trusted_assemblies.created_by
• _trusted_assemblies.description
• _trusted_assemblies.hash
• plan_persist_query.query_flags
• plan_persist_query_hints.batch_sql_handle
• plan_persist_query_hints.comment
• plan_persist_query_hints.context_settings_id
• plan_persist_query_hints.last_query_hint_failure_reason
• plan_persist_query_hints.object_id
• plan_persist_query_hints.query_hash
• plan_persist_query_hints.query_hint_failure_count
• plan_persist_query_hints.query_hint_id
• plan_persist_query_hints.query_hints_flags
• plan_persist_query_hints.query_hints
• plan_persist_query_hints.query_id
• plan_persist_query_hints.query_param_type
• plan_persist_query_hints.statement_sql_handle
• plan_persist_query_template_parameterization.comment
• plan_persist_query_template_parameterization.last_parameterization_failure_reason
• plan_persist_query_template_parameterization.parameterization_failure_count
• plan_persist_query_template_parameterization.query_param_type
• plan_persist_query_template_parameterization.query_template_flags
• plan_persist_query_template_parameterization.query_template_hash
• plan_persist_query_template_parameterization.query_template_id
• plan_persist_query_template_parameterization.query_template
• plan_persist_query_text.query_template_hash
• plan_persist_wait_stats.count_executions
• plan_persist_wait_stats.execution_type
• plan_persist_wait_stats.last_query_wait_time_ms
• plan_persist_wait_stats.max_query_wait_time_ms
• plan_persist_wait_stats.min_query_wait_time_ms
• plan_persist_wait_stats.plan_id
• plan_persist_wait_stats.runtime_stats_interval_id
• plan_persist_wait_stats.sumsquare_query_wait_time_ms
• plan_persist_wait_stats.total_query_wait_time_ms
• plan_persist_wait_stats.wait_category
• plan_persist_wait_stats.wait_stats_id

Inline table-valued functions:

• dm_db_log_info.database_id
• dm_db_log_info.file_id
• dm_db_log_info.vlf_active
• dm_db_log_info.vlf_begin_offset
• dm_db_log_info.vlf_create_lsn
• dm_db_log_info.vlf_first_lsn
• dm_db_log_info.vlf_parity
• dm_db_log_info.vlf_sequence_number
• dm_db_log_info.vlf_size_mb
• dm_db_log_info.vlf_status
• dm_db_log_stats.active_log_size_mb
• dm_db_log_stats.active_vlf_count
• dm_db_log_stats.current_vlf_sequence_number
• dm_db_log_stats.current_vlf_size_mb
• dm_db_log_stats.database_id
• dm_db_log_stats.log_backup_lsn
• dm_db_log_stats.log_backup_time
• dm_db_log_stats.log_checkpoint_lsn
• dm_db_log_stats.log_end_lsn
• dm_db_log_stats.log_min_lsn
• dm_db_log_stats.log_recovery_lsn
• dm_db_log_stats.log_recovery_size_mb
• dm_db_log_stats.log_since_last_checkpoint_mb
• dm_db_log_stats.log_since_last_log_backup_mb
• dm_db_log_stats.log_truncation_holdup_reason
• dm_db_log_stats.recovery_model
• dm_db_log_stats.recovery_vlf_count
• dm_db_log_stats.total_log_size_mb
• dm_db_log_stats.total_vlf_count
• dm_os_enumerate_filesystem.creation_time
• dm_os_enumerate_filesystem.file_or_directory_name
• dm_os_enumerate_filesystem.full_filesystem_path
• dm_os_enumerate_filesystem.has_integrity_stream
• dm_os_enumerate_filesystem.is_directory
• dm_os_enumerate_filesystem.is_hidden
• dm_os_enumerate_filesystem.is_read_only
• dm_os_enumerate_filesystem.is_sparse
• dm_os_enumerate_filesystem.is_system
• dm_os_enumerate_filesystem.is_temporary
• dm_os_enumerate_filesystem.last_access_time
• dm_os_enumerate_filesystem.last_write_time
• dm_os_enumerate_filesystem.level
• dm_os_enumerate_filesystem.parent_directory
• dm_os_enumerate_filesystem.size_in_bytes
• dm_os_file_exists.file_exists
• dm_os_file_exists.file_is_a_directory
• dm_os_file_exists.parent_directory_exists
• dm_sql_referenced_entities.is_incomplete
• fn_full_dblog.AllocUnitId
• fn_full_dblog.AllocUnitName
• fn_full_dblog.Article ID
• fn_full_dblog.Begin Time
• fn_full_dblog.Beginlog Status
• fn_full_dblog.Bulk allocated extent count
• fn_full_dblog.Bulk allocated extent ids
• fn_full_dblog.Bulk allocation first IAM Page ID
• fn_full_dblog.Bulk AllocUnitId
• fn_full_dblog.Bulk RowsetId
• fn_full_dblog.Byte Offset
• fn_full_dblog.Bytes Freed
• fn_full_dblog.Checkpoint Begin
• fn_full_dblog.Checkpoint End
• fn_full_dblog.CHKPT Begin DB Version
• fn_full_dblog.CHKPT End DB Version
• fn_full_dblog.CI Index Id
• fn_full_dblog.CI Table Id
• fn_full_dblog.Column Offset
• fn_full_dblog.Command Type
• fn_full_dblog.Command
• fn_full_dblog.Compression Info
• fn_full_dblog.Compression Log Type
• fn_full_dblog.Context
• fn_full_dblog.CopyVerionInfo Source Page Id
• fn_full_dblog.CopyVerionInfo Source Page LSN
• fn_full_dblog.CopyVerionInfo Source Slot Count
• fn_full_dblog.CopyVerionInfo Source Slot Id
• fn_full_dblog.Current LSN
• fn_full_dblog.Database Name
• fn_full_dblog.Description
• fn_full_dblog.Dirty Pages
• fn_full_dblog.End AGE
• fn_full_dblog.End Time
• fn_full_dblog.File ID
• fn_full_dblog.File Status
• fn_full_dblog.FileGroup ID
• fn_full_dblog.Flag Bits
• fn_full_dblog.Flags
• fn_full_dblog.Format LSN
• fn_full_dblog.InvalidateCache Id
• fn_full_dblog.InvalidateCache keys
• fn_full_dblog.Last Distributed Backup End LSN
• fn_full_dblog.Last Distributed End LSN
• fn_full_dblog.Lock Information
• fn_full_dblog.Log Record Fixed Length
• fn_full_dblog.Log Record Length
• fn_full_dblog.Log Record
• fn_full_dblog.Log Reserve
• fn_full_dblog.LogBlockGeneration
• fn_full_dblog.Logical Name
• fn_full_dblog.LSN before writes
• fn_full_dblog.Mark Name
• fn_full_dblog.Master DBID
• fn_full_dblog.Master XDESID
• fn_full_dblog.Max XDESID
• fn_full_dblog.Meta Status
• fn_full_dblog.Minimum LSN
• fn_full_dblog.Modify Size
• fn_full_dblog.New Size
• fn_full_dblog.New Split Page
• fn_full_dblog.New Value
• fn_full_dblog.NewAllocUnitId
• fn_full_dblog.Next Replicated End LSN
• fn_full_dblog.Num Elements
• fn_full_dblog.Num Transactions
• fn_full_dblog.Number of Locks
• fn_full_dblog.Offset in Row
• fn_full_dblog.Offset
• fn_full_dblog.Old Size
• fn_full_dblog.Old Value
• fn_full_dblog.Oldest Active LSN
• fn_full_dblog.Oldest Active Transaction ID
• fn_full_dblog.Oldest Replicated Begin LSN
• fn_full_dblog.Operation
• fn_full_dblog.Page ID
• fn_full_dblog.PageFormat FormatOption
• fn_full_dblog.PageFormat PageFlags
• fn_full_dblog.PageFormat PageLevel
• fn_full_dblog.PageFormat PageStat
• fn_full_dblog.PageFormat PageType
• fn_full_dblog.Pages Written
• fn_full_dblog.Parent Transaction ID
• fn_full_dblog.Partial Status
• fn_full_dblog.PartitionId
• fn_full_dblog.Physical Name
• fn_full_dblog.Prepare Time
• fn_full_dblog.Preplog Begin LSN
• fn_full_dblog.Previous LSN
• fn_full_dblog.Previous Page LSN
• fn_full_dblog.Previous Savepoint
• fn_full_dblog.Publication ID
• fn_full_dblog.Repl CSN
• fn_full_dblog.Repl Epoch
• fn_full_dblog.Repl Flags
• fn_full_dblog.Repl Min Hold LSN
• fn_full_dblog.Repl Msg
• fn_full_dblog.Repl Partition ID
• fn_full_dblog.Repl Source Commit Time
• fn_full_dblog.Replicated Records
• fn_full_dblog.Rowbits Bit Count
• fn_full_dblog.Rowbits Bit Value
• fn_full_dblog.Rowbits First Bit
• fn_full_dblog.RowFlags
• fn_full_dblog.RowLog Contents 0
• fn_full_dblog.RowLog Contents 1
• fn_full_dblog.RowLog Contents 2
• fn_full_dblog.RowLog Contents 3
• fn_full_dblog.RowLog Contents 4
• fn_full_dblog.RowLog Contents 5
• fn_full_dblog.Rows Deleted
• fn_full_dblog.RowsetId
• fn_full_dblog.Savepoint Name
• fn_full_dblog.Server Name
• fn_full_dblog.Server UID
• fn_full_dblog.Slot ID
• fn_full_dblog.SPID
• fn_full_dblog.Tag Bits
• fn_full_dblog.Text Size
• fn_full_dblog.TextPtr
• fn_full_dblog.Transaction Begin
• fn_full_dblog.Transaction ID
• fn_full_dblog.Transaction Name
• fn_full_dblog.Transaction SID
• fn_full_dblog.Virtual Clock
• fn_full_dblog.VLFs added
• fn_full_dblog.Xact ID
• fn_full_dblog.Xact Node ID
• fn_full_dblog.Xact Node Local ID
• fn_full_dblog.Xact Type
• fn_get_audit_file.affected_rows
• fn_get_audit_file.application_name
• fn_get_audit_file.client_ip
• fn_get_audit_file.duration_milliseconds
• fn_get_audit_file.response_rows
• fn_xe_file_target_read_file.timestamp_utc

System Tables:

• syscscolsegments.container_id
• syscsdictionaries.container_id

User Tables:

• MSreplication_options.install_failures
• MSreplication_options.major_version
• MSreplication_options.minor_version
• MSreplication_options.optname
• MSreplication_options.revision
• MSreplication_options.value
• spt_monitor.connections
• spt_monitor.cpu_busy
• spt_monitor.idle
• spt_monitor.io_busy
• spt_monitor.lastrun
• spt_monitor.pack_errors
• spt_monitor.pack_received
• spt_monitor.pack_sent
• spt_monitor.total_errors
• spt_monitor.total_read
• spt_monitor.total_write

Views:

• all_columns.graph_type_desc
• all_columns.graph_type
• availability_groups.cluster_type_desc
• availability_groups.cluster_type
• availability_groups.required_synchronized_secondaries_to_commit
• availability_groups.sequence_number
• columns.graph_type_desc
• columns.graph_type
• computed_columns.graph_type_desc
• computed_columns.graph_type
• database_automatic_tuning_mode.actual_state_desc – not a GUI for this just yet, but you can change a database’s tuning mode with ALTER DATABASE SET commands. Right now it’s about forcing the last good plan in the event that you hit a parameter sniffing issue.
• database_automatic_tuning_mode.actual_state
• database_automatic_tuning_mode.desired_state_desc
• database_automatic_tuning_mode.desired_state
• database_automatic_tuning_options.actual_state_desc
• database_automatic_tuning_options.actual_state
• database_automatic_tuning_options.desired_state_desc
• database_automatic_tuning_options.desired_state
• database_automatic_tuning_options.name
• database_automatic_tuning_options.reason_desc
• database_automatic_tuning_options.reason
• database_credentials.principal_id
• database_files.is_persistent_log_buffer
• database_query_store_options.wait_stats_capture_mode_desc
• database_query_store_options.wait_stats_capture_mode
• database_scoped_configurations.is_value_default
• database_scoped_credentials.principal_id
• databases.is_temporal_history_retention_enabled
• dm_db_column_store_row_group_physical_stats.closed_time
• dm_db_column_store_row_group_physical_stats.created_time
• dm_db_column_store_row_group_physical_stats.deleted_rows
• dm_db_column_store_row_group_physical_stats.delta_store_hobt_id
• dm_db_column_store_row_group_physical_stats.generation
• dm_db_column_store_row_group_physical_stats.has_vertipaq_optimization
• dm_db_column_store_row_group_physical_stats.index_id
• dm_db_column_store_row_group_physical_stats.object_id
• dm_db_column_store_row_group_physical_stats.partition_number
• dm_db_column_store_row_group_physical_stats.row_group_id
• dm_db_column_store_row_group_physical_stats.size_in_bytes
• dm_db_column_store_row_group_physical_stats.state_desc
• dm_db_column_store_row_group_physical_stats.state
• dm_db_column_store_row_group_physical_stats.total_rows
• dm_db_column_store_row_group_physical_stats.transition_to_compressed_state_desc
• dm_db_column_store_row_group_physical_stats.transition_to_compressed_state
• dm_db_column_store_row_group_physical_stats.trim_reason_desc
• dm_db_column_store_row_group_physical_stats.trim_reason
• dm_db_file_space_usage.modified_extent_page_count
• dm_db_mirroring_connections.address
• dm_db_tuning_recommendations.details
• dm_db_tuning_recommendations.execute_action_duration
• dm_db_tuning_recommendations.execute_action_initiated_by
• dm_db_tuning_recommendations.execute_action_initiated_time
• dm_db_tuning_recommendations.execute_action_start_time
• dm_db_tuning_recommendations.is_executable_action
• dm_db_tuning_recommendations.is_revertable_action
• dm_db_tuning_recommendations.last_refresh
• dm_db_tuning_recommendations.name
• dm_db_tuning_recommendations.reason
• dm_db_tuning_recommendations.revert_action_duration
• dm_db_tuning_recommendations.revert_action_initiated_by
• dm_db_tuning_recommendations.revert_action_initiated_time
• dm_db_tuning_recommendations.revert_action_start_time
• dm_db_tuning_recommendations.score
• dm_db_tuning_recommendations.state
• dm_db_tuning_recommendations.type
• dm_db_tuning_recommendations.valid_since
• dm_db_xtp_checkpoint_internals.checkpoint_id
• dm_db_xtp_checkpoint_internals.checkpoint_timestamp
• dm_db_xtp_checkpoint_internals.is_synchronized
• dm_db_xtp_checkpoint_internals.last_segment_lsn
• dm_db_xtp_checkpoint_internals.recovery_lsn
• dm_exec_query_stats.last_columnstore_segment_reads
• dm_exec_query_stats.last_columnstore_segment_skips
• dm_exec_query_stats.max_columnstore_segment_reads
• dm_exec_query_stats.max_columnstore_segment_skips
• dm_exec_query_stats.min_columnstore_segment_reads
• dm_exec_query_stats.min_columnstore_segment_skips
• dm_exec_query_stats.total_columnstore_segment_reads
• dm_exec_query_stats.total_columnstore_segment_skips
• dm_exec_requests.is_resumable
• dm_os_enumerate_fixed_drives.drive_type_desc
• dm_os_enumerate_fixed_drives.drive_type
• dm_os_enumerate_fixed_drives.fixed_drive_path
• dm_os_enumerate_fixed_drives.free_space_in_bytes
• dm_os_host_info.host_distribution
• dm_os_host_info.host_platform
• dm_os_host_info.host_release
• dm_os_host_info.host_service_pack_level
• dm_os_host_info.host_sku
• dm_os_host_info.os_language_version
• dm_os_memory_objects.partition_type_desc
• dm_os_nodes.cpu_count
• dm_os_sys_info.cores_per_socket
• dm_os_sys_info.numa_node_count
• dm_os_sys_info.process_physical_affinity
• dm_os_sys_info.socket_count
• dm_os_worker_local_storage.gq_address
• dm_tran_global_transactions.max_csn
• dm_tran_global_transactions_enlistments.snapshot_timestamp
• dm_tran_global_transactions_log.commit_timestamp
• dm_tran_version_store_space_usage.database_id
• dm_tran_version_store_space_usage.reserved_page_count
• dm_tran_version_store_space_usage.reserved_space_kb
• dm_xe_session_targets.bytes_written
• dm_xe_sessions.buffer_full_count
• dm_xe_sessions.buffer_processed_count
• dm_xe_sessions.total_bytes_generated
• external_libraries.external_library_id
• external_libraries.language
• external_libraries.name
• external_libraries.principal_id
• external_libraries.scope_desc
• external_libraries.scope
• external_library_files.content
• external_library_files.external_library_id
• external_library_files.platform_desc
• external_library_files.platform
• hash_indexes.auto_created
• hash_indexes.is_ignored_in_optimization
• identity_columns.graph_type_desc
• identity_columns.graph_type
• index_resumable_operations.index_id
• index_resumable_operations.last_max_dop_used
• index_resumable_operations.last_pause_time
• index_resumable_operations.name
• index_resumable_operations.object_id
• index_resumable_operations.page_count
• index_resumable_operations.partition_number
• index_resumable_operations.percent_complete
• index_resumable_operations.sql_text
• index_resumable_operations.start_time
• index_resumable_operations.state_desc
• index_resumable_operations.state
• index_resumable_operations.total_execution_time
• indexes.auto_created
• indexes.is_ignored_in_optimization
• indexes.suppress_dup_key_messages
• key_constraints.is_enforced
• masked_columns.graph_type_desc
• masked_columns.graph_type
• master_files.is_persistent_log_buffer
• query_store_plan.plan_forcing_type_desc
• query_store_plan.plan_forcing_type
• query_store_runtime_stats.avg_log_bytes_used
• query_store_runtime_stats.avg_num_physical_io_reads
• query_store_runtime_stats.avg_tempdb_space_used
• query_store_runtime_stats.last_log_bytes_used
• query_store_runtime_stats.last_num_physical_io_reads
• query_store_runtime_stats.last_tempdb_space_used
• query_store_runtime_stats.max_log_bytes_used
• query_store_runtime_stats.max_num_physical_io_reads
• query_store_runtime_stats.max_tempdb_space_used
• query_store_runtime_stats.min_log_bytes_used
• query_store_runtime_stats.min_num_physical_io_reads
• query_store_runtime_stats.min_tempdb_space_used
• query_store_runtime_stats.stdev_log_bytes_used
• query_store_runtime_stats.stdev_num_physical_io_reads
• query_store_runtime_stats.stdev_tempdb_space_used
• query_store_wait_stats.avg_query_wait_time_ms
• query_store_wait_stats.execution_type_desc
• query_store_wait_stats.execution_type
• query_store_wait_stats.last_query_wait_time_ms
• query_store_wait_stats.max_query_wait_time_ms
• query_store_wait_stats.min_query_wait_time_ms
• query_store_wait_stats.plan_id
• query_store_wait_stats.runtime_stats_interval_id
• query_store_wait_stats.stdev_query_wait_time_ms
• query_store_wait_stats.total_query_wait_time_ms
• query_store_wait_stats.wait_category_desc
• query_store_wait_stats.wait_category
• query_store_wait_stats.wait_stats_id
• sequences.last_used_value
• spatial_indexes.auto_created
• spatial_indexes.is_ignored_in_optimization
• spt_values.high
• spt_values.low
• spt_values.name
• spt_values.number
• spt_values.status
• spt_values.type
• syscscontainers.blob_container_id
• syscscontainers.blob_container_type
• syscscontainers.blob_container_url
• system_columns.graph_type_desc
• system_columns.graph_type
• tables.history_retention_period_unit_desc
• tables.history_retention_period_unit
• tables.history_retention_period
• tables.is_edge
• tables.is_node
• trusted_assemblies.create_date
• trusted_assemblies.created_by
• trusted_assemblies.description
• trusted_assemblies.hash
• xml_indexes.auto_created
• xml_indexes.is_ignored_in_optimization