Hotfix for Symantec Enterprise Vault (EV), High SQL CPU Utilization during GetObjectsBySIDs/GetArchivesBySids for environments using Vault Cache.

Article:TECH155950  |  Created: 2011-03-18  |  Updated: 2011-04-27  |  Article URL http://www.symantec.com/docs/TECH155950
Article Type
Technical Solution


Environment

Issue



After upgrading to Enterprise Vault 9.0 or 9.0.1, high CPU utilization may be seen on the SQL server.


Cause



SQL Server heavily utilized CPU resources when a VaultCache synchronization was in progress


Solution



Which version of Symantec Enterprise Vault (tm) can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault for:

Enterprise Vault for Microsoft Exchange 9.0, Build 1193
Enterprise Vault for Microsoft Exchange 9.0.1, Build 1073

 

What issue does this hotfix resolve?
This supersedes the hotfix in Technote 139219: http://www.symantec.com/docs/TECH13921
High CPU Utilization from GetObjectsBySIDs and GetArchivesBySids
 

Which files does this hotfix replace?

The following stored procedures are updated/created (depending if hot fix provided in Technote 139219 is installed)
 1. GetObjectsBySids_Original
 2. GetObjectsBySids
 3. GetArchivesBySids


Files updated
Etrack_2245740.sql
 


How to Install this hotfix:
1. Stop all EnterpriseVault Directory Services
2. Ensure that the EnterpriseVaultDirectory Database has been backed up
3. Open the script Etrack_2245740.sql using an account with DB Owner credentials
4. Execute the SQL script against the EnterpriseVaultDirectory Database
5. Restart all services
 

How to Uninstall this hotfix:

If hotfix in Technote 139219 was installed:
 1. Stop all EnterpriseVault Directory Services
 2. Re-apply the hotfix in Technote 139219
 3. Restart the Services

Otherwise:
1. Stop all EnterpriseVault Directory Services
2. Rename the existing GetObjectsBySIDs Stored Procedure using SQL Enterprise Manager to GetObjectsBySIDs_old
3. Rename the new GetObjectsBySIDs_Original to GetObjectsBySIDs
4. Restart the Services


Attachments

EV 9.0 Hotfix - Etrack 2245740.zip (5 kBytes)

Supplemental Materials

SourceETrack
Value2245740
Description

High CPU Utilization from GetObjectsBySIDs/GetArchivesBySids




Article URL http://www.symantec.com/docs/TECH155950


Terms of use for this information are found in Legal Notices