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|
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).
Applies to Recovery Solution 7.0 SP1 (7.0.3454).
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.
Article URL http://www.symantec.com/docs/TECH187139