Analysis of SQL Server Performance Data

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  October 26, 2006 at 9:54 am

  #170762

  Comments posted here are about the content posted at temp

• chinn

  SSCrazy

  Points: 2840

  More actions

  October 30, 2006 at 8:13 am

  #668752

  Great Job,

  You made it so simple and clear.

  Thanks,

• Joshua Jin

  SSC Rookie

  Points: 25

  More actions

  October 30, 2006 at 10:55 am

  #668802

  Good Example!

• Ranga N

  SSChasing Mays

  Points: 642

  More actions

  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

   

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  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

   

   

   

   

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  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/

• Ranga N

  SSChasing Mays

  Points: 642

  More actions

  November 1, 2006 at 11:39 am

  #669282

  Thanks...You answere my question.

• David Eades

  SSC Journeyman

  Points: 85

  More actions

  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