How To read Error Logs using Query | How to read Registry using sql query

-- Gives you some useful information about the composition and relative load on your NUMA nodes -- You want to see an equal number of schedulers on each NUMA node -- Watch out if SQL Server 2012 Standard Edition has been installed on a machine with more than 16 physical cores -- Watch out if you have a VM with more than 4 NUMA nodes with SQL Server Standard Edition, since there is a four-socket license limit -- Balancing Your Available SQL Server Core Licenses Evenly Across NUMA Nodes -- Hardware information from SQL Server 2012 (Query 15) (Hardware Info) SELECT cpu_count AS [Logical CPU Count], scheduler_count, hyperthread_ratio AS [Hyperthread Ratio], cpu_count/hyperthread_ratio AS [Physical CPU Count], physical_memory_kb/1024 AS [Physical Memory (MB)], committed_kb/1024 AS [Committed Memory (MB)], committed_target_kb/1024 AS [Committed Target Memory (MB)], max_workers_count AS [Max Workers Count], affinity_type_desc AS [Affinity Type], sqlserver_start_time AS [SQL Server Start Time], virtual_machine_type_desc AS [Virtual Machine Type] FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE); ------ -- Gives you some good basic hardware information about your database server -- Cannot distinguish between HT and multi-core -- Note: virtual_machine_type_desc of HYPERVISOR does not automatically mean you are running SQL Server inside of a VM -- It merely indicates that you have a hypervisor running on your host -- Get BIOS date from Windows Registry (Query 17) (BIOS Date) EXEC sys.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'HARDWARE\DESCRIPTION\System\BIOS', N'BiosReleaseDate'; -- Get BIOS date from Windows Registry Get processor description -- Get System Manufacturer and model number from SQL Server Error log EXEC sys.xp_readerrorlog 0, 1, N'Manufacturer'; ------ -- You can use CPU-Z to get your actual CPU core speed and a lot of other useful information -- http://www.cpuid.com/softwares/cpu-z.html