Hi guys in the Previous post i explained How we can get the SQL Server NUME Information and How to get Hardware Information  put today in DAY 5 i will show new DMV in our track Instance Level configuration .

DMV#11 Getting the Server Model Number

by the below DMV we can know the capacities of database System Manufacturer

EXEC xp_readerrorlog 0, 1, "Manufacturer";


DMV12# Getting the Processor Description

You should know the type of the Processor  of your Windows Server that the SQL Server instance Hosted on it based on that check the DMV

EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'HARDWARE\DESCRIPTION\System\CentralProcessor', N'ProcessorNameString';


DMV#13 SQL Server Error Log Properties

For troubleshooting in Case on the cluster or other issues in SQL Server you should know where the location of other error and diagnostic log files

SELECT is_enabled, [path], max_size, max_files
FROM sys.dm_os_server_diagnostics_log_configurations WITH (NOLOCK) OPTION(RECOMPILE);


To check all my posts you can direct to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Website Slideshare ,Youtube Channel.

One thought on “SQL Server 2014 Health check DMV queries Day 5

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.