If you have trouble installing SQL Server 2005 SP1 and you found in the log that views sys.dm_exec_query_resource_semaphores and sys.dm_exec_query_memory_grants are missing, then you have to move the Resource database into the same path of master database.

Details are explained in KB918695; I also suggest to read this thread in MSDN Forum.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2006/05/21/solved-trouble-with-sp1-setup.aspx