Troubleshooting - Microsoft SQL Server 2008 R2 Administration - page 359

SET SHOWPLAN_TEXT OFF
GO
SET SHOWPLAN_TEXT ON
GO
SELECT CurrencyRateID,FromCurrencyCode,ToCurrencyCode,EndOfDayRate
FROM Sales.CurrencyRate
WHERE (CurrencyRateDate>'2005-06-30' and ModifiedDate<'2005-07-31')
GO
SET SHOWPLAN_TEXT OFF
GO
SET SHOWPLAN_TEXT ON
GO
SELECT BusinessEntityID,CreditCardID
FROM Sales.PersonCreditCard
WHERE (ModifiedDate>='2005-06-01' and ModifiedDate<='2007-07-31')
GO
SET SHOWPLAN_TEXT OFF
GO
SET SHOWPLAN_TEXT ON
GO
SELECT PersonType, FirstName,LastName,EmailPromotion,Demographics
FROM Person.Person
WHERE (ModifiedDate>'2003-01-01' and BusinessEntityID>4500)
GO
SET SHOWPLAN_TEXT OFF
GO
SET STATISTICS IO OFF
GO
--Currently executing queries
SELECT sqltext.TEXT,
der.session_id, der.status, der.command,
der.cpu_time, der.total_elapsed_time
FROM sys.dm_exec_requests der
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
The preceding queries should generate the required information to evaluate the
performance statistics.