ASITKAUSHIK (6/14/2012)
I would suggest pickup of any simple query and follow the below stepSET STATISTICS IO ON
<YOUR QUERY>
SET STATISTICS IO OFF
just see the if u are getting physical reads if yes and the number is good then you system hardware is been overutiized coz of that more data is been fetched from the hard disk memory to the main memory causing a slow overall system.
Hope this helps
REgards
Asit
Or you can just query the sys.dm_exec_query_stats DMO to see aggregate reads. Not a perfect measure, but quicker than actually executing each individual query.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning