Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
System Reserved Partition and monitoring
02 December,2011 by Tom Collins
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
Read More
netstat monitoring and tuning performance - SQL Server DBA
SQL server 2008 R2 – Silent installation for the SSMS and client tools
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |