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.