SQL Server 2014 Health check DMV queries Day 5

28Apr

Hi guys in the Previous posti 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

EXECxp_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