RS 7.0.3454 - High CPU usage on SQL Server with IsAMetaJobReady stored procedure

Article:TECH187139  |  Created: 2012-04-24  |  Updated: 2012-04-24  |  Article URL http://www.symantec.com/docs/TECH187139
Article Type
Technical Solution


Issue



High CPU usage on SQL Server with IsAMetaJobReady stored procedure is observed with a server having large amount of RS clients having Client Scheduling enabled for them (RS clients are allowed to initiate scheduled snapshot).


Environment



Applies to Recovery Solution 7.0 SP1 (7.0.3454).


Solution



Attached is a reworked (optimized) version of the problematic stored procedure. Please load in SQL Management Studio and execute against the RS database. It is recommended that RS Server service is stopped or no snapshots running at that time.


Attachments

IsAMetaJobReady.sql (13 kBytes)


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


Terms of use for this information are found in Legal Notices