I had troubles with the Opmsgr Console performance at serveral clients. One of the most important things to boost your console performance is to reduce the Opsmgr DB size. If you want to know which tabel is taking most of your DB size run the following query: Simple query to display large tables, to determine what is taking up space in the database: SELECT so.name, 8 * Sum(CASE WHEN si.indid IN (0, 1) THEN si.reserved END) AS data_kb, Coalesce(8 * Sum(CASE WHEN si.indid NOT IN (0, 1, 255) THEN si...(read more)

Read the complete post at http://scug.be/blogs/scom/archive/2009/05/28/optimizing-the-performance-of-your-opsmgr-console-and-reducing-db-size.aspx