• I would suggest pickup of any simple query and follow the below step

    SET 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