If you don't frequent Euan Garden's BLOG and you're interested in a history lesson on the Workload Governor in MSDE (and the fact that it doesn't existin in SQL Express), you should check out his recent post on the subject.

http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx

Mike Wachal
SQL Express Program Manager