dynamic-management-views

DMV in SQL 2008 to replace dm_os_exec_requests

I've been going through an old SQL 2005 performance tuning document and it talks about the dynamic management view sys.dm_os_exec_requests. It looks like that view is no longer available in SQL 2008. Is there a direct replacement? Is there a standard way of selecting the same data from another DMV or group of DMVs? Thanks! ...

SQL Server - sys.dm_exec_requests Issue

In SSMS 2008 I created a new query window and issued the following statement (notice I don't commit the transaction): Begin Tran Update Master.Part Set LastModifiedUser = 'me' I then open another new query window and entered the following query: Select * From sys.dm_exec_requests The DMV does not show the query from the first query...

SQL Server DMV - sys.dm_db_missing_index_group_stats - What do these columns mean?

I am tinkering with creating a query to find missing indexes. I've taken a base query created by the Red-Gate folks in their SQL Server DMV Starter Pack eBook and am modifying it a bit. There are a couple columns in sys.dm_db_missing_index_group_stats which I don't know how to interpret. They are: avg_total_user_cost avg_user_impact A...