Les nouvelles DMV de Denali

SQL Server 11 alias Denali vient avec de nouvelles DMV (Dynamic Management Views). Ce qui suit, reprend ces nouveautés :

• sys.dm_os_windows_info : This DMV returns the OS related information to the user. It is good to know the properties of hosting server. Columns :
  • windows_release:
  • windows_service_pack
  • windows_sku
  • os_language_version
•  sys.dm_server_registry : This DMV returns some of the registry keys that the server uses. Columns :
  • registry key
  • value_name
  • value_data
• sys.dm_server_services : This DMV provides useful information about the SQL Server, SQL Agent and SQL FullText service related with the running server. This DMV is very helpful to track the servers status and startup configuration. Columns :
  • service_name
  • startup type
  • startup_type_desc
  • status
  • status_type_desc
  • process_id
  • last_startup_time
  • service_account
  • filename
  • is_clustered
  • cluster_nodename
• sys.dm_server_memory_dumps : This DMV returns the dumps that are generated by the server.Columns :
  • filename
  • size_in_bytes
  • creation_time

Pour en savoir plus sur les DMV, voir ici.

Bonne journée.