SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
System Reserved Partition and monitoring

02 December,2011 by Jack Vamvas

On Windows 2008 R2  , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step for implementing Bitlocker. The installation doesn’t install Bitlocker.  BitLocker is a disk encryption method  for full disk encryption.

The System Reserved Partition  can cause problems in some monitoring tools.  The System Reserved Partition volume is unmapped but  is monitored by default on some monitoring agents.  

Various vendors have workarounds for excluding the System Reserved Partition information and therefore false alerts.  When monitoring a Database Server such as SQL Server or DB2  accurate and effective alerts are critical.When monitoring SQL Server Database Status  this can cause much DBA stress

For example , IBM  have introduced an environment variable NT_EXCLUDE_UNMAPPED_DISKS. This variable can be configured in the Windows OS agent KNTENV configuration file and can take the values:

0 (default) = HardDiskVolume# disks are monitored, if present.

1 = HardDiskVolume# labeled disks are not be monitored.

Speak to other vendors about workarounds for excluding this information

System reserved partition

Read More

netstat monitoring and tuning performance - SQL Server DBA

SQL server 2008 R2 – Silent installation for the SSMS and client tools


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer