Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Analysis of SQL Server Performance Data Expand / Collapse
Author
Message
Posted Thursday, October 26, 2006 9:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 12, 2014 8:54 AM
Points: 195, Visits: 80
Comments posted here are about the content posted at temp
Post #318396
Posted Monday, October 30, 2006 8:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:57 PM
Points: 127, Visits: 542

Great Job,

You made it so simple and clear.

Thanks,




Post #319021
Posted Monday, October 30, 2006 10:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 20, 2007 10:40 AM
Points: 1, Visits: 1
Good Example!
Post #319081
Posted Monday, October 30, 2006 2:18 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 18, 2013 11:20 AM
Points: 67, Visits: 135


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

 




Post #319143
Posted Monday, October 30, 2006 2:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 12, 2014 8:54 AM
Points: 195, Visits: 80

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

 

 

 

 

Post #319147
Posted Wednesday, November 1, 2006 2:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
very nice!  adds more leverage to the power of sql server, and as you say would produce excellent olap cubes. excellent article.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #319518
Posted Wednesday, November 1, 2006 11:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 18, 2013 11:20 AM
Points: 67, Visits: 135
Thanks...You answere my question.


Post #319677
Posted Thursday, November 2, 2006 3:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 21, 2007 9:16 PM
Points: 5, Visits: 1
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



Post #320133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse