Have you looked for a problem SPID, one that is just beating the crap out of the CPU?

SELECT * FROM sys.dm_exec_sessions

SELECT * FROM sys.dm_exec_connections

SELECT * FROM sys.dm_exec_requests

On a Microsoft Connect post is was specifically asked and as usually Microsoft came out with a definitive - " The current target is Q4 2010"

So based on when Microsoft...

Due to the size of our database and the small maintenance window we have, it has been most beneficial to rebuild only those indexes with a threashold of say 30%...

We are currently utilizing VMWare on our development and test environments only. Due to hard drive constraints, we tend to have to plan large data imports on the development...

Sorry to say there just isn't much out there yet for R2, hope this link helps:

http://support.microsoft.com/kb/2072493/

I believe I mentioned the processor hit in my first post and in both of my posts I strongly suggested that the individual think twice before performing any type of...

Like the other posts, I would not be so quick to reduce the .mdf size, but if you are certain of any pending growth and are limited on space, to...

Did you release the unused space after you shrunk the database? Also, I hope you rebuilt all of your statistics and indexes as they are now completely out of...

Did you happen to restore an encrypted database from a different server to this server? If so, you need to open the master key using its password and re-encrypt...

You do not need to purchase a license for installing the SQL tools on a workstation, nor are you required to use the original media.

Have you had a chance to look through the site much - you may find this thread helpful.

http://www.sqlservercentral.com/Forums/Topic442391-146-1.aspx

Did you just recently enable the PAE/AWE? When did you first receive the error?

Take a look at this great article by Jim Mcleod on enabling and AWE

http://www.jimmcleod.net/blog/index.php/2008/06/03/sql-server-2005-and-awe-memory/

Is AWE enabled on the SQL Server? How much memory do you have allocated to SQL Server - if more then 2 GB you will recieve this error.

What version and service pack of SQL are you utilizing? The LATCH_EX is an Exclusive Latch, but the MISC is one I have never seen.

I did find a great...

I would have to agree with Gail - something in the update has to have had a negative effect. As a suggestion, since you are utilizing Windows XP, do...