[转帖]System Dynamic Management Views
System Dynamic Management Views
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-management-views?view=sql-server-2017
APPLIES TO: 
SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
Important
Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may change in future releases of SQL Server. Therefore, dynamic management views and functions in future releases may not be compatible with the dynamic management views and functions in this release. For example, in future releases of SQL Server, Microsoft may augment the definition of any dynamic management view by adding columns to the end of the column list. We recommend against using the syntax SELECT * FROM dynamic_management_view_name in production code because the number of columns returned might change and break your application.
There are two types of dynamic management views and functions:
Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server.
Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
Querying Dynamic Management Views
Dynamic management views can be referenced in Transact-SQL statements by using two-part, three-part, or four-part names. Dynamic management functions on the other hand can be referenced in Transact-SQL statements by using either two-part or three-part names. Dynamic management views and functions cannot be referenced in Transact-SQL statements by using one-part names.
All dynamic management views and functions exist in the sys schema and follow this naming convention dm_*. When you use a dynamic management view or function, you must prefix the name of the view or function by using the sys schema. For example, to query the dm_os_wait_stats dynamic management view, run the following query:
SELECT wait_type, wait_time_ms
FROM sys.dm_os_wait_stats;
Required Permissions
To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission. This lets you selectively restrict access of a user or login to dynamic management views and functions. To do this, first create the user in master and then deny the user SELECT permission on the dynamic management views or functions that you do not want them to access. After this, the user cannot select from these dynamic management views or functions, regardless of database context of the user.
Note
Because DENY takes precedence, if a user has been granted VIEW SERVER STATE permissions but denied VIEW DATABASE STATE permission, the user can see server-level information, but not database-level information.
In This Section
Dynamic management views and functions have been organized into the following categories.
最新文章
- 《虚拟伙伴》AR增强现实应用开发总结
- HTML中id、name、class 区别
- make: g77: Command not found
- 复利test
- InnoDB主键设计
- zookeeper系列之六—zookeeper之应用
- sql server2012 动态端口
- iOS开发——数据持久化Swift篇&使用Core Data进行数据持久化存储
- HDOJ2001计算两点间的距离
- 启动、停止、重启 MySQL 常见的操作方法：
- html弹窗，与弹出对话框
- 有个程序猿要去当CEO了：（一）事情始末
- bzoj 1814 Ural 1519 Formula 1 插头DP
- Django 系列博客（十六）
- [物理学与PDEs]第4章习题4 一维理想反应流体力学方程组的守恒律形式及其 R.H. 条件
- 【谷歌浏览器】【谷歌地球】【Adobe 软件】离线安装包的下载地址
- linux中安装oracle数据库
- 对某项目中Vuex用法的分析
- Error : Weblogic Maven Plugin deployment WebLogic 12c
- 《FPGA全程进阶---实战演练》第四章之Quartus II使用技巧