Home » 2015 » July

Monthly Archives: July 2015

Translate:

Archives

Troubleshooting Database Latency & Disk Space Issues Using (.\Troubleshoot.Ps1) Scripts

This blog will help you to Troubleshoot Issues related to Database Latency and Disk space. Also this will be helpful to find the root cause.

Managing Exchange 2010 server organization in a production environment Exchange Administrator needs to keep track of things like

1: Database Latency

2: Disk Space problems

3: Search issues etc…..

 

To isolate and resolve such issues most of the Admin use Event id and use EMC rather than these there most useful to Admin is such scenarios is EMS. Yes, PowerShell like booster to admin to solve such scenarios much faster with less effort. To help the Exchange Admin there is inbuilt scripts in our Exchange server itself.

These scripts are available in Scripts folder.

 

TPs1

 

 

These PowerShell scripts are located in the \Program Files\Microsoft\Exchange Server\V14\Scripts folder.

And they are ready to use few scripts shown below:

  • Database Latency Troubleshooter(Troubleshoot-DatabaseLatancy.ps1)
  • Database Disk Space troubleshooter(Troubleshoot-DatabaseSpace.ps1)
  • Content Index Troubleshooter(Troubleshoot-CI.ps1)

TPs2

Let’s start with

The Database Latency Troubleshooter:

The Database Latency Troubleshooter (Troubleshoot-DatabaseLatency.ps1) is designed to monitor and perform troubleshooting on database latency. This script will check the below tasks and resolves.

  • Disk latency
  • Active Directory Latency
  • RPC Latency
  • Top CPU user

The below script will provide the latency and EventId as shown below:

Example

Troubleshoot-Databaselatency.ps1 -MailboxDatabaseName <DatabaseID> [-latencyThreshold <1-200>] [-TimeinServerThreshold <1-600000>] [-Quarantine <switch>] [-MonitoringContext <switch>]

TPs3

Below are few events that are generated

Logs generated on Database Space and Latency

TPs4

Events related to Database Latency

TPs5

The Database Disk Space Troubleshooter:

The Database Disk Space Troubleshooter (Troubleshoot-DatabaseSpace.ps1) is designed to monitor and perform troubleshooting on database disk space issues. This script will check and show the cause and this will be helpful for the Exchange Administrators:

  • It tracks the top users that are generating logs
  • It tracks the available disk space for both logs and database

Based on a disk space and time threshold, the troubleshooter has the option to Quarantine the top users.

Examples

Troubleshoot-DatabaseSpace.ps1 -MailboxDatabaseName <DatabaseID> [-PercentEdbFreeSpaceThreshold <1-99>] [-PercentLogFreeSpaceThreshold <1-99>] [-HourThreshold <1- 100000000>] [-Quarantine <switch>] [-MonitoringContext <switch>]

So after running this command you will get the information with eventid for more information about the events you can check in Event Viewer

TPs6

Troubleshoot-DatabaseSpace.ps1 -Server <ServerID> [-PercentEdbFreeSpaceThreshold <1-99>] [-PercentLogFreeSpaceThreshold <1-99>] [-HourThreshold <1- 1000000000>] [-Quarantine <switch>] [-MonitoringContext <switch>]

TPs7

Event Log

TPs8

 

The Content Index Troubleshooter:

The CI Troubleshooter (Troubleshoot-CI.ps1) is designed to monitor and perform troubleshooting on Content Index catalogs. It detects and resolves the following symptoms like :

  • Deadlock: Exchange Search deadlocks waiting on threads from MSSearch
  • Corruption: One or more search indices are corrupted
  • Stall: Similar to deadlock in that the indices are not getting updated
  • Backlog: The Search catalog is backlogged resulting in missing index searches

This troubleshooter can be used against the Database or the Server, also useful to detect and resolve.

Examples

C:\PS> .\Troubleshoot-CI.ps1 -database EX01-DB05

Detects and reports if there’s any problem with catalog for

database DB05. Does not attempt any Resolution.

TPs9

C:\PS> .\Troubleshoot-CI.ps1 -database DB05 -symptom Stall

Detects if indexing on catalog for database DB05 is stalled. Does not attempt any Resolution.

TPs10

C:\PS> .\Troubleshoot-CI.ps1 -database EX01-DB05 -Action DetectAndResolve

Detects and reports if there’s any problem with catalog for database DB01.

Attempts a Resolution of the problem.

Event Log

TPs11

TPs12

Great with this we have learned Troubleshooting Database and related Issues.

For more Info about the Parameters used in this blog you can get in the below article

https://technet.microsoft.com/en-us/library/ff798271%28v=exchg.141%29.aspx

 

Praveen Kumar

MCTS, MCITP | Exchange Server

Publisher @ Techrid.com

Translate »