Post reply

Analysis of SQL Server Performance Data

  • October 26, 2006 at 9:54 am

    #170762

    Comments posted here are about the content posted at temp

  • October 30, 2006 at 8:13 am

    #668752

    Great Job,

    You made it so simple and clear.

    Thanks,

  • October 30, 2006 at 10:55 am

    #668802

    Good Example!

  • October 30, 2006 at 2:18 pm

    #668851

    Nice article...very simple and precise.

    But, I did not understand the second report...what are P1, P2, P3 columns represent ?

    Please let me know.

     

    thanks,

    Ranga

     

  • October 30, 2006 at 2:24 pm

    #668854

    P1, P2 and P3 refer to Period1, Period2 and Period3.

    In a real situation, they could be labelled week1, week2, week3,.....weekN

    so if you have data collected for 2 years (i.e. 52 * 2 = 104 weeks) you could create a report comparing data across those 104 periods.

    Normally I do for the last 10 periods.

    hope I answered your question. If still not clear, please bug me. I will try to be more explanatory.

     

    thankz

    jambu

     

     

     

     

  • November 1, 2006 at 2:02 am

    #669146

    very nice!  adds more leverage to the power of sql server, and as you say would produce excellent olap cubes. excellent article.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 1, 2006 at 11:39 am

    #669282

    Thanks...You answere my question.

  • November 2, 2006 at 3:56 pm

    #669650

    Thanks

    Good article. Very clear and easy to understand. I am currently working my way through performance testing and how to get the best out of Performance Monitor. This is a great help to me.

    Cheers

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply