Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning To create the trace for CPU and memory performance RE: To create the trace for CPU and memory performance

  • May 8, 2015 at 7:50 pm

    #1796786

    bubby (5/8/2015)

    My Server is slow, I am planning add the memory and CPU as it is virtual, I just want track the performance just for those 2 things, will be running some heavy queries to test,

    Can I get a help with this as a simple query to create the trace, as I do not want to select everything,

    Thanks in Advance,

    Regards,

    Bubby

    I doubt that your server is slow. The code on it is slow. Adding memory and CPU might help a little bit but not as much as finding the slow code and fixing it.

    Start by opening the Object Explorer in SSMS (press the {f8} key if it's not already open), right click on the instance name, select reports, and then follow your nose through the standard performance reports. It'll not only tell you which queries are the worst but which parts of the queries are the worst.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)