SQL Server 2008 r2 dynamic views

There are two new server related dynamic management views (dmv) that are associated with the sql server fulltext, and sql server agent services in sql server 2008 r2.

These dmv are only available in sql server 2008 r2 sp1 and later versions:

sys.dm_server_services

sys.dm_server_registry
sys.dm_server_services

The sys.dm_server_services dmv returns information about the sql server and sql server agent
services in the cureent instance of sql server. you user this dmv to report status information
about the services that are running on the cureent instance of the sql server

Example :

use master
select * from sys.dm_server_services
Sys.dm_server_registry

The sys.dm_server_registry dmv returns configuration and installation information stored in the windows registry for the current instance of sql server. this function returns one row per registry key. you use this dmv to return information such as the network configuration values for the instance of sql server or the sql server services are available on the host machine.

use master
select * from sys.dm_server_services

Leave a Reply

  

  

  


7 − 4 =