RSS

SQL Server 2014 Health check DMV queries Day 5

28 Apr

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";

DMV#11

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#12

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);

DMV#13

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.

 
1 Comment

Posted by on April 28, 2015 in SQL Server 2014

 

Tags: , ,

One response to “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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s