In SQL Server there are many System Objects by default for
storing the metadata information of objects created on other databases in the
same instance. In this article I will be going over with high level information
as it is a vast topic to explore in a single article. Few of these objects keep changing as sql server releases a newer version the older version features are depricated. Please keep an eye out for the versions they support before using.
·
System Tables:
System Tables are
mostly used for monitoring SQL server health and activity of the services
running on the SQL server. Below is the table of various groups of tables available
in SQL Server system databases.
·
System Views
System Views are exposed
to access the metadata information and much more friendly way to access inside
each database that gets created on the instance, for example: sys.tables gives
all the tables created on a particular database. Below is the table of various
groups of views available.
·
System Stored Procedures
System
Stored Procedures have ability to administrative actions and other information
activities, for example: sp_who is used to show what all sessions are running
on sql server at that moment.
·
System Functions
System Function do help us in different ways to show various information up
on request with a particular input. These are also present in every database
that gets created on the instance. Below is a list of various groups of functions available.
Always On Availability
Groups Functions
Change Data Capture Functions
Change Tracking Functions
Data Collector Functions
Filestream and FileTable Functions
Managed Backup Functions
sys.fn_get_sql
sys.fn_MSxe_read_event_stream
sys.fn_stmt_sql_handle_from_sql_stmt
sys.fn_validate_plan_guide
sys.fn_xe_file_target_read_file
sys.fn_backup_file_snapshots
Semantic Full-Text Search Functions
System Metadata Functions
System Security Functions
System Trace Functions
Change Data Capture Functions
Change Tracking Functions
Data Collector Functions
Filestream and FileTable Functions
Managed Backup Functions
sys.fn_get_sql
sys.fn_MSxe_read_event_stream
sys.fn_stmt_sql_handle_from_sql_stmt
sys.fn_validate_plan_guide
sys.fn_xe_file_target_read_file
sys.fn_backup_file_snapshots
Semantic Full-Text Search Functions
System Metadata Functions
System Security Functions
System Trace Functions
0 comments:
Post a Comment