Recently, I was working on SQL Server 2014 CTP 1 and doing my usual research, and came across the new system objects shipped with CTP 1.
Given below is the list of new system objects :
S.No |
Object Name |
Object Type |
1 |
sp_set_cardinality_estimation_model_110 |
EXTENDED STORED PROCEDURE |
2 |
plan_persist_query_text |
INTERNAL TABLE |
3 |
plan_persist_query |
INTERNAL TABLE |
4 |
plan_persist_plan |
INTERNAL TABLE |
5 |
plan_persist_runtime_stats |
INTERNAL TABLE |
6 |
plan_persist_runtime_stats_interval |
INTERNAL TABLE |
7 |
plan_persist_context_settings |
INTERNAL TABLE |
8 |
fn_dump_dblog_xtp |
INLINE TABLE VALUED FUNCTION |
9 |
fn_dblog_xtp |
INLINE TABLE VALUED FUNCTION |
10 |
fn_hadr_is_primary_replica |
SCALAR FUNCTION |
11 |
sp_MSalreadyhavegeneration |
STORED PROCEDURE |
12 |
sp_xtp_merge_checkpoint_files |
STORED PROCEDURE |
13 |
sp_db_enable_clustered_columnstores |
STORED PROCEDURE |
14 |
sp_cci_tuple_mover |
STORED PROCEDURE |
15 |
syscsrowgroups |
SYSTEM TABLE |
16 |
dm_resource_governor_resource_pool_volumes |
VIEW |
17 |
dm_xtp_transaction_stats |
VIEW |
18 |
dm_xe_database_session_event_actions |
VIEW |
19 |
dm_xtp_gc_stats |
VIEW |
20 |
dm_db_xtp_index_stats |
VIEW |
21 |
dm_xe_database_session_object_columns |
VIEW |
22 |
dm_os_buffer_pool_extension_configuration |
VIEW |
23 |
dm_db_xtp_object_stats |
VIEW |
24 |
dm_db_xtp_table_memory_stats |
VIEW |
25 |
dm_xtp_consumer_memory_usage |
VIEW |
26 |
dm_io_cluster_shared_volumes |
VIEW |
27 |
dm_db_xtp_memory_consumers |
VIEW |
28 |
dm_db_xtp_checkpoint |
VIEW |
29 |
dm_xtp_threads |
VIEW |
30 |
dm_db_merge_requests |
VIEW |
31 |
dm_xtp_transaction_recent_rows |
VIEW |
32 |
dm_db_xtp_checkpoint_files |
VIEW |
33 |
dm_xtp_system_memory_consumers |
VIEW |
34 |
dm_xe_database_session_events |
VIEW |
35 |
dm_xtp_memory_stats |
VIEW |
36 |
dm_db_xtp_hash_index_stats |
VIEW |
37 |
dm_xe_database_sessions |
VIEW |
38 |
dm_xe_database_session_targets |
VIEW |
39 |
dm_db_xtp_gc_cycle_stats |
VIEW |
40 |
dm_xtp_gc_queue_stats |
VIEW |
41 |
dm_db_xtp_transactions |
VIEW |
42 |
column_store_row_groups |
VIEW |
43 |
hash_indexes |
VIEW |
44 |
event_sessions |
VIEW |
45 |
event_session_targets |
VIEW |
46 |
event_session_fields |
VIEW |
47 |
event_session_events |
VIEW |
48 |
event_session_actions |
VIEW |
Leave a Reply