Cleaning the Localizedtext Table after SCOM upgrade to SCOM 2007 R2

1 minute read

After upgrading your OpsMgr 2007 components and upgrading your SQL environment to SQL Server 2008, you will need to run some post installation steps. These post installation steps are only needed if you have done an upgrade from OpsMgr 2007 to OpsMgr 2007 R2.

OpsMgr 2007 SP 1 had an issue with the localized text table continuing to grow. The main cause of this was converted MOM 2005 management packs running a lot of backwards-compatibility scripts, such as the converted Exchange 2007 management pack. The issue was that each event wrote additional data to the localized text table, which is not groomed. Over time, the Operational database continued to grow, which had a tremendous impact on OpsMgr performance. Kevin Holman writes about this at http://blogs.technet.com/kevinholman/archive/2008/10/13/does-your-opsdb-keep-growing-is-your-localizedtext-table-using-all-the-space.aspx; it is also documented on the SCUG.BE blog at http://scug.be/blogs/scom/archive/2009/05/28/optimizing-the-performance-of-your-opsmgr-console-and-reducing-db-size.aspx .

 

I’ve just did an upgrade at a customer site and after completing the post-installation steps as mentioned here http://technet.microsoft.com/nl-nl/library/dd789073(en-us).aspx and I was very surprised by the results!!

 

 

I checked the database size and the localizedtext table before running the cleanup script.

  • Database size before the cleanup script

image

28 gig of space!

image

  • 12.700.000 records in the localizedtext table before running the cleanup script.

 

In OpsMgr 2007 R2, the localizedtext table issue is gone. The table still exists but Microsoft has resolved the growing issue. Even if the issue is gone you will need to run the following SQL query once after the upgade to initially clean up the localizedtext and publishermessage tables. You can copy/paste the script from here http://technet.microsoft.com/nl-nl/library/dd789073(en-us).aspx 

 

The script has run for about 4 hours!

image

Now the results! 🙂

 

Disk space after the clean up script:

image

7 gig of disk space; So that’s a gain of 20 gig of disk space! That’s amazing!

image

780.000 records found in the localizedtext table after running the clean up script !! So that’s about 12 million records lesser!!

 

For completing the post-upgrade steps I did a reindex of the database.

image

 

 

 

 

 

 

 

And now my console is running very fast and I’ve less data to backup! So after upgrading to SCOM 2007 R2 you will definitely have to run the clean up script!!

 

Greetings,
Alexandre Verkinderen

Leave a comment