SQLServerCentral / Discuss Content Posted by Jambu Krishnamurthy / Article Discussions / Article Discussions by Author / Analysis of SQL Server Performance Data / Latest Posts

RE: Analysis of SQL Server Performance Data

David Eades — Thu, 02 Nov 2006 15:56:00 GMT

ThanksGood 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

RE: Analysis of SQL Server Performance Data

Ranga N — Wed, 01 Nov 2006 11:39:00 GMT

Thanks...You answere my question.

RE: Analysis of SQL Server Performance Data

colin.Leversuch-Roberts — Wed, 01 Nov 2006 02:02:00 GMT

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

RE: Analysis of SQL Server Performance Data

Jambu Krishnamurthy — Mon, 30 Oct 2006 14:24:00 GMT

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

RE: Analysis of SQL Server Performance Data

Ranga N — Mon, 30 Oct 2006 14:18:00 GMT

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

RE: Analysis of SQL Server Performance Data

Joshua Jin — Mon, 30 Oct 2006 10:55:00 GMT

Good Example!

RE: Analysis of SQL Server Performance Data

chinn — Mon, 30 Oct 2006 08:13:00 GMT

Great Job,

You made it so simple and clear.

Thanks,

Analysis of SQL Server Performance Data

Jambu Krishnamurthy — Thu, 26 Oct 2006 09:54:00 GMT

Comments posted here are about the content posted at temp