SQL Server 2014 Health check DMV queries Day 5

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.

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/ View all posts by Mustafa EL-Masry