SCVMM 2007: Clear up for SQL Server Database

Following several deployments of hundreds of VM’s, thousands of Jobs were created and stored in the SCVMM 2007 database. That coupled with the regular checks made by SCVMM (a job for each one) our database had over 100k jobs. This causes a big problem: when launching the SCVMM 2007 console, this would use up more […]

Following several deployments of hundreds of VM’s, thousands of Jobs were created and stored in the SCVMM 2007 database. That coupled with the regular checks made by SCVMM (a job for each one) our database had over 100k jobs. This causes a big problem: when launching the SCVMM 2007 console, this would use up more than 900MB of RAM to run, in the past we have experience instability when this goes over 1.2GB

Here’s the solution:

  1. Open SQL Management Studio
  2. Open New Query Screen
  3. Run the following Query to clear entire list of Jobs on SCVMM Admin Console
  4. UPDATE tbl_TR_TaskTrail SET IsVisible = 0
  5. Rre-open the SCVMM Admin console – entire list of jobs should be clear

Now, when the console launches it only uses 120MB of RAM. This process is run every 2 hours to keep the list of jobs down. There is a downside to this in that we no longer have the useful information that comes from some of the jobs, but that is better than having the console crash regularly.

Source:→ Microsoft