[cisco-voip] CIPT Optimization job causes ccm.exe to terminate unexpectedly

[Wes Sisk]

Yes,

This typically happens when one of the database transaction logs are  
large.  The job spikes the CPU and starves CM for processing time.

1. verify the size of the transaction logs.  Generally around 30-50%  
of corresponding db size is 'normal'.

2. Run the steps of the job manually to make sure you are not getting  
errors from the steps
In SQL Enterprise Manager
Management
SQL Server Agents
Jobs
right click on the job
properties
steps
edit

copy out the text of the step and paste it into SQL Query Analyzer.   
Run that job. Look at the output for anything suspicious.  Also note  
which step is taking so long to complete and taking the most CPU or  
disk I/O.  Investigate that database further.

Last time I ran into this it was because the backup destination
1. had insufficient storage space and
2. had a speed/duplex mismatch
this caused the nightly backup to fail in such a way that BARS never  
shrunk the transaction logs for the CCM and CDR databases.

/Wes

On Aug 26, 2006, at 7:20 PM, Erick Bergquist wrote:

Has anyone seen the CIPT Optimization SQL job cause CCM to crash before?
This is on a CCM 3.3(4)sr2 system w/OS 2000.2-6sr4 (SQL SP3a). Have  
tried to adjust the time of the job away from other tasks so it is  
only thing running and it still crashes. The SQL job completes  
succesfully and is taking 8 to 9 minutes on average to complete. CCM  
fails usually 4 or 5 minutes after job starts.

Thanks, Erick

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip