dbTalk Databases Forums  

OLAP Performance Counters not showing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OLAP Performance Counters not showing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jay
 
Posts: n/a

Default OLAP Performance Counters not showing - 10-13-2004 , 10:17 AM






Can anyone help?

I have tried to install OLAP performance counter as listed in books
on-line and the web link:
http://msdn.microsoft.com/library/de...izing_976t.asp

However, no counters are showing up.

I am using NT4 SP6a with MSAS 8.0.534

Cheers

jay

Reply With Quote
  #2  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-13-2004 , 03:58 PM






By installing - what do you mean...?

You need to go into the performance monitoring tool in windows (not AS) -
don't know the english term
and configure a monitoring session ... where you select which of the
monitoring groups + counters
you wish to examine and select how to output it. Try using text file at
first to better get a look
at the numbers.

--Michael V.

jay <jasonwattse2 (AT) hotmail (DOT) com> wrote

Quote:
Can anyone help?

I have tried to install OLAP performance counter as listed in books
on-line and the web link:

http://msdn.microsoft.com/library/de...us/olapdmad/ag
optimizing_976t.asp
Quote:
However, no counters are showing up.

I am using NT4 SP6a with MSAS 8.0.534

Cheers

jay



Reply With Quote
  #3  
Old   
jay
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-14-2004 , 02:25 AM



Hi Michael

By installing I mean exactly that, installing analysis services
performance counters, as listed in books on-line and/or the web link
in my previous posting.

When I go to performance monitor the counters are listed.

I've rebooted the machine but to no avail.

jay




"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

Quote:
By installing - what do you mean...?

You need to go into the performance monitoring tool in windows (not AS) -
don't know the english term
and configure a monitoring session ... where you select which of the
monitoring groups + counters
you wish to examine and select how to output it. Try using text file at
first to better get a look
at the numbers.

--Michael V.

Reply With Quote
  #4  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-14-2004 , 01:58 PM



My laptop broke down last night so I can't give you the exact words...but on
my operating system
it isn't enough that they are listed - you have to put them into a
monitoring session where you choose
somewhere to place the session - such as binary file, sql server etc.

The link you mention doesn't go into this - the link only tells you which
counters are available - not
how to make a monitoring process...

You can then pick which counters you want to monitor - perhaps you don't
want them all at once.

--Michael V.

jay <jasonwattse2 (AT) hotmail (DOT) com> wrote

Quote:
Hi Michael

By installing I mean exactly that, installing analysis services
performance counters, as listed in books on-line and/or the web link
in my previous posting.

When I go to performance monitor the counters are listed.

I've rebooted the machine but to no avail.

jay




"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

By installing - what do you mean...?

You need to go into the performance monitoring tool in windows (not
AS) -
don't know the english term
and configure a monitoring session ... where you select which of the
monitoring groups + counters
you wish to examine and select how to output it. Try using text file at
first to better get a look
at the numbers.

--Michael V.



Reply With Quote
  #5  
Old   
jay
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-15-2004 , 04:12 AM



yes I understand what your saying about saving the results in a file,
but what I'm saying is that the counters are not there to begin with.
I cannot monitor Analysis Services because the counters are not there
to select. I can select other counters such as processor, network,
memory etc, but not A.S counters.

The link I gave explains how to install the counters by amending the
registry and running the LODCTR msmdctr.ini command. The link also
shows the couters that should be available once the command is run,
but this is not working for me.

jay





"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

Quote:
My laptop broke down last night so I can't give you the exact words...but on
my operating system
it isn't enough that they are listed - you have to put them into a
monitoring session where you choose
somewhere to place the session - such as binary file, sql server etc.

The link you mention doesn't go into this - the link only tells you which
counters are available - not
how to make a monitoring process...

You can then pick which counters you want to monitor - perhaps you don't
want them all at once.

--Michael V.

Reply With Quote
  #6  
Old   
Michael V.
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-15-2004 , 06:43 AM



Sounds mysterious....perhaps a platform / userrights problem - I had no
problem locating the counters on my laptop (xp prof).

I actually didn't need the link specified - the counters where installed on
my machine to begin with....could it be sql server version trouble ?

Have developers ... do you use standard edition ? Don't know if there is a
limitation here...

"jay" wrote:

Quote:
yes I understand what your saying about saving the results in a file,
but what I'm saying is that the counters are not there to begin with.
I cannot monitor Analysis Services because the counters are not there
to select. I can select other counters such as processor, network,
memory etc, but not A.S counters.

The link I gave explains how to install the counters by amending the
registry and running the LODCTR msmdctr.ini command. The link also
shows the couters that should be available once the command is run,
but this is not working for me.

jay





"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

My laptop broke down last night so I can't give you the exact words...but on
my operating system
it isn't enough that they are listed - you have to put them into a
monitoring session where you choose
somewhere to place the session - such as binary file, sql server etc.

The link you mention doesn't go into this - the link only tells you which
counters are available - not
how to make a monitoring process...

You can then pick which counters you want to monitor - perhaps you don't
want them all at once.

--Michael V.


Reply With Quote
  #7  
Old   
Chris Webb
 
Posts: n/a

Default RE: OLAP Performance Counters not showing - 10-15-2004 , 09:25 AM



Sounds very much like the following:
http://support.microsoft.com/default...b;en-us;313597
....even though you're using NT and not XP. Have you tried upgrading to SP3?

Regards,

Chris

"jay" wrote:

Quote:
Can anyone help?

I have tried to install OLAP performance counter as listed in books
on-line and the web link:
http://msdn.microsoft.com/library/de...izing_976t.asp

However, no counters are showing up.

I am using NT4 SP6a with MSAS 8.0.534

Cheers

jay


Reply With Quote
  #8  
Old   
jay
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-15-2004 , 01:31 PM



there could be a platform limitation, I am using NT4 - eek!

I'll try it on my laptop as I have XP, failing that I'll find a 2000 server
to try it on

thanks for your thoughts.


"Michael V." <Michael V. (AT) discussions (DOT) microsoft.com> wrote

Sounds mysterious....perhaps a platform / userrights problem - I had no
problem locating the counters on my laptop (xp prof).

I actually didn't need the link specified - the counters where installed on
my machine to begin with....could it be sql server version trouble ?

Have developers ... do you use standard edition ? Don't know if there is a
limitation here...

"jay" wrote:

Quote:
yes I understand what your saying about saving the results in a file,
but what I'm saying is that the counters are not there to begin with.
I cannot monitor Analysis Services because the counters are not there
to select. I can select other counters such as processor, network,
memory etc, but not A.S counters.

The link I gave explains how to install the counters by amending the
registry and running the LODCTR msmdctr.ini command. The link also
shows the couters that should be available once the command is run,
but this is not working for me.

jay





"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

My laptop broke down last night so I can't give you the exact
words...but on
my operating system
it isn't enough that they are listed - you have to put them into a
monitoring session where you choose
somewhere to place the session - such as binary file, sql server etc.

The link you mention doesn't go into this - the link only tells you
which
counters are available - not
how to make a monitoring process...

You can then pick which counters you want to monitor - perhaps you don't
want them all at once.

--Michael V.




Reply With Quote
  #9  
Old   
jay
 
Posts: n/a

Default Re: OLAP Performance Counters not showing - 10-20-2004 , 03:18 PM



good grief! How come that never showed up in my searches?

I am on SP2 for AS and unfortunaltely cannot upgrade it as there is a system
freeze on our servers.

Thanks for the link

j


"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote

Sounds very much like the following:
http://support.microsoft.com/default...b;en-us;313597
....even though you're using NT and not XP. Have you tried upgrading to SP3?

Regards,

Chris

"jay" wrote:

Quote:
Can anyone help?

I have tried to install OLAP performance counter as listed in books
on-line and the web link:

http://msdn.microsoft.com/library/de...us/olapdmad/ag
optimizing_976t.asp
Quote:
However, no counters are showing up.

I am using NT4 SP6a with MSAS 8.0.534

Cheers

jay




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.