Performance Counters on Service Broker Transmission Queue

Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

There's no perfmon counter. Something like count () or sp_spaceused would be required to query the count. The message send perfmon counters probably are a better indication of what's happening at the connection level - depending on what you're trying to measure.|||

No performance counter. See this post for an efficient query to return the number of rows in the hidden table that represents the transmission queue: http://blogs.msdn.com/remusrusanu/archive/2006/11/08/fast-way-to-check-message-count.aspx

HTH,
~ Remus

|||Thank you both

performance counters on a SAN

Hello,
Recently we moved our database servers onto a emc cx600 san. Since
the move I ran perfmon against the server for a week to try to get a
baseline of the server's performance. I am getting some curious
metrics from perfmon on the avg. disk queue lenth and %disk time for
the data drive for the sql server database. We have the same
dedicated spindle config as we did on our former system with the
difference being the greatly increased throughput of the new system.
Avg. disk queue lenth is reporting an avg. of over 30 for lengthy
periods of time(> 10 minutes) and %disk time is reporting an avg of
over 300 around the same time . The former system was not reporting
any performance bottlenecks. I wonder if the counters are skewed
somehow. Has anyone experienced any oddities with disk related
performance counter metrics on a san or am I suddenly looking at a
disk bottleneck? Is it possible that the increased throughput to the
san is now causing a disk bottleneck?
Let me know if more details are needed.
Thanks,
GregThanks for the reply. The logical drive is a 10 spindle raid 5, so
the avg. disk queue length would be 3. If I'm not mistaken an avg.
disk queue length of 2 or more for any extended period of time would
be considered a bottleneck. Also, a % disk time of 300 seems rather
high to me as well. I am just curious if these disk counters report
accurately on a san as there weren't any bottlenecks reported on the
former system which was much slower than this system all the way
around. To my knowledge there hasn't been a substantial change in
workload to suddenly cause this.
Greg
On Tue, 12 Aug 2003 05:26:31 -0400, "Wayne Snyder"
<wsnyder@.computeredservices.com> wrote:
>Remember that disk queue lengths are for the logical drive... and to get
>*real* number you care about divide 30 by the number of physical drives
> which are likely to be a larger number in the SAN)...
>"Greg" <gjackson@.thq.com> wrote in message
>news:gjagjvgsp8ogelufmret27pdddi7vi4sh4@.4ax.com...
>> Hello,
>> Recently we moved our database servers onto a emc cx600 san. Since
>> the move I ran perfmon against the server for a week to try to get a
>> baseline of the server's performance. I am getting some curious
>> metrics from perfmon on the avg. disk queue lenth and %disk time for
>> the data drive for the sql server database. We have the same
>> dedicated spindle config as we did on our former system with the
>> difference being the greatly increased throughput of the new system.
>> Avg. disk queue lenth is reporting an avg. of over 30 for lengthy
>> periods of time(> 10 minutes) and %disk time is reporting an avg of
>> over 300 around the same time . The former system was not reporting
>> any performance bottlenecks. I wonder if the counters are skewed
>> somehow. Has anyone experienced any oddities with disk related
>> performance counter metrics on a san or am I suddenly looking at a
>> disk bottleneck? Is it possible that the increased throughput to the
>> san is now causing a disk bottleneck?
>> Let me know if more details are needed.
>> Thanks,
>> Greg
>sql

Performance counters on 64 bit SSIS

On 32 bit SSIS installations, both of the following performance counter objects are visible in perfmon.

SQLServer:SSIS Service

SQLServer:SSIS Pipeline

On 64 bit SSIS installations, only the following is available.

SQLServer:SSIS Service

The SQlServer:SSIS Pipeline counters are nowhere to be found.

Should I re-install? Is this a known issue with 64 bit SSIS?

P.S. Remote or local access administrative access with perfmon makes no difference, the "SQLServer:SSIS Pipeline" performance counters don't appear in the listbox when connecting to Windows 2003 x64 server.

Try running perfmon w/ 32-bit switch like so:

mmc.exe /32 perfmon.msc

Counters should show up.

|||

Halfway answered.

Local perfmon access to x64 "SQlServer:SSIS Pipeline" counters: yes

Remote perfmon access to x64 "SQlServer:SSIS Pipeline" counters: no

As to the local SSIS performance counter access on x64, using the SysWOW64 version of perfmon.exe does pick up the"SQlServer:SSIS Pipeline" counters.(e.g. C\WINDOWS\SysWOW64\perfmon.exe), so thanks for that.

Performance Counters not displayed

SQL Server 2000 EE SP3a.
Through PerfMon the sql server specific perfomance
counters are not displayed. I have revisited the
installation CD and per the installation SQL Server
Components/Performance Counters SubComponent are installed.
Any Ideas on how I can see these counters. This is a
production machine so all maintenance is late night.
TIA,hi,
take a look at this
article
http://support.microsoft.com/?id=152513
>--Original Message--
>SQL Server 2000 EE SP3a.
>Through PerfMon the sql server specific perfomance
>counters are not displayed. I have revisited the
>installation CD and per the installation SQL Server
>Components/Performance Counters SubComponent are
installed.
>Any Ideas on how I can see these counters. This is a
>production machine so all maintenance is late night.
>TIA,
>.
>|||I have looked at this article. Again the only counters
that do not show up are the SQL Server specific counters.
Joe
>--Original Message--
>hi,
>take a look at this
>article
>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>.
>|||Did you restart the server before looking at the perfmon,
To get u'r counters back just restart the entire system
and look at it
>--Original Message--
>I have looked at this article. Again the only counters
>that do not show up are the SQL Server specific counters.
>Joe
>>--Original Message--
>>hi,
>>take a look at this
>>article
>>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>>.
>.
>

Performance Counters not available after restart Take offline-Online

After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.

Performance Counters not available after restart Take offline-Online

After stopping and starting the MSSQLSERVER service the Performance Counters are not available. After a reboot of the server they are there again. What is the proper way to shutdown the MSSQLSERVER process, starting it again and regaining access to the performance counters? The Unlodctr and lodctr sqlstr.ini trick seems not to work. A complete reboot of the server is needed.I've found that stopping and starting the MSSQL Service using the services mmc renders the performance log for SQLServer in accesible. However, stop and starting a SQLserver from the Enterprise Manger does not have that effect.

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJ
Have you tried this:
http://support.microsoft.com/?kbid=300956
Markus
|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>
|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>
|||I tried to fathom the recommended article and was completely flummoxed. That
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I found
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:

> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegr oups.com...
>
>
sql

Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?
In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:

> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>
|||The server is Windows 2003.
"Sreejith G" wrote:
[vbcol=seagreen]
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJHave you tried this:
http://support.microsoft.com/?kbid=300956
Markus|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||I tried to fathom the recommended article and was completely flummoxed. Tha
t
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I foun
d
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:

> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
>
>

Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:
> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>|||The server is Windows 2003.
"Sreejith G" wrote:
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:
> > After installing Sharepoint application on to my SQL Server 2000, all the
> > performance counters for SQL went missing.
> >
> > How do I get them back and would I need to restart SQL/Reboot afterwards?
> >
> >

Performance Counters Missing

My SQL Server 2000 (SP2) performance counters are missing/corrupted. They
seem to be in the Performance COunter drop down, as a series of 4-digit
numbers. The SQL server runs on a active/passive Windows 2000
clusterconfiguration (W2K SP3). I've tried manually reloading them with
lodctr and the sqlctr.ini file looks clean. The other (passive) cluster
node doesn't have them either, but it also doesn't have the odd 4-digit
number entries in the drop down list of counters. Any help would be
appreciated.
PJHave you tried this:
http://support.microsoft.com/?kbid=300956
Markus|||I'll give that a try and get back to the group. Thanks for the suggestion.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||Thanks for the suggestion Markus. I tried it, and it got rid of the weird
numbered counters in the Performance Monitor Counter list (except for one,
listed as 0 - ZERO). However, the SQL counters are completely missing ...
any further ideas? Thanks again.
PJ
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> Have you tried this:
> http://support.microsoft.com/?kbid=300956
> Markus
>|||I tried to fathom the recommended article and was completely flummoxed. That
called for some scary registry manipulation in a whole lot of places. Is
there not some way to get a value to plug in just to the 009 branch? I found
a large number of last counter and last help fields throughout the registry
and got scared off. Where does a mere mortal go for help on this?
"msnews.microsoft.com" wrote:
> Thanks for the suggestion Markus. I tried it, and it got rid of the weird
> numbered counters in the Performance Monitor Counter list (except for one,
> listed as 0 - ZERO). However, the SQL counters are completely missing ...
> any further ideas? Thanks again.
> PJ
>
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1133340824.530847.203620@.g44g2000cwa.googlegroups.com...
> > Have you tried this:
> > http://support.microsoft.com/?kbid=300956
> >
> > Markus
> >
>
>

Performance counters disappeared

I have an application written in C++ that querys all
available performance counters via RegQueryValueEx() API
at 10 second interval on some Windows 2000 computers that
have SQL Server 7.0 installed. After the application have
run for some period of time (several days or longer), the
SQL Server related performance counters disappeared. They
are disabeld by the OS. The knowledge base article
Q248993 mentions that the performance library of Windows
2000 disables any performance DLL that returns data in the
incorrect format, causes an unhandled program fault, or
takes too long to return the performance data (this is
usually the cause of a library being disabled). It is
obvious the incorrect format does not apply to my case
since it would have caused the problem right after it
started not several days later. Anyone knows what causes
the problem?Did you see Q812915?
"Tianxiang Zhang" <tianxiang_zhang@.bmc.com> wrote in message
news:013701c344b5$7f9caed0$a501280a@.phx.gbl...
> I have an application written in C++ that querys all
> available performance counters via RegQueryValueEx() API
> at 10 second interval on some Windows 2000 computers that
> have SQL Server 7.0 installed. After the application have
> run for some period of time (several days or longer), the
> SQL Server related performance counters disappeared. They
> are disabeld by the OS. The knowledge base article
> Q248993 mentions that the performance library of Windows
> 2000 disables any performance DLL that returns data in the
> incorrect format, causes an unhandled program fault, or
> takes too long to return the performance data (this is
> usually the cause of a library being disabled). It is
> obvious the incorrect format does not apply to my case
> since it would have caused the problem right after it
> started not several days later. Anyone knows what causes
> the problem?|||I did. They don't seem to be the same issue. Thanks for
the help.
>--Original Message--
>Did you see Q812915?
>
>"Tianxiang Zhang" <tianxiang_zhang@.bmc.com> wrote in
message
>news:013701c344b5$7f9caed0$a501280a@.phx.gbl...
>> I have an application written in C++ that querys all
>> available performance counters via RegQueryValueEx() API
>> at 10 second interval on some Windows 2000 computers
that
>> have SQL Server 7.0 installed. After the application
have
>> run for some period of time (several days or longer),
the
>> SQL Server related performance counters disappeared.
They
>> are disabeld by the OS. The knowledge base article
>> Q248993 mentions that the performance library of Windows
>> 2000 disables any performance DLL that returns data in
the
>> incorrect format, causes an unhandled program fault, or
>> takes too long to return the performance data (this is
>> usually the cause of a library being disabled). It is
>> obvious the incorrect format does not apply to my case
>> since it would have caused the problem right after it
>> started not several days later. Anyone knows what
causes
>> the problem?
>
>.
>sql

performance counters

well, it doesn't look so good.
i did all the troubleshoot i could find in the web but with a minor success.
it's not a corrupted registry, counters or something like that. out of 5
different machine - only one agreed to cooperate and allow access to those
counters remotely. the rest had varius behavior...
i tried lodctr, unlodctr, exctrlst, diskperf -Y and re-register sqlctr80.dll
with regsvr32 - with no maijor success. even though i got an error message
for the command "regsvr32 sqlctr80.dll" about an entry point that it couldnt
find, i don't think that's the problem.
any more assistance will be appreciated.
thanks, em.
"Plamen Ratchev" wrote:

> The following steps may help (but not always):
> - At the command prompt run: unlodctr.exe MSSQLServer
> - Then run: lodctr.exe <SQL Server path>\binn\sqlctr.ini
> - Reboot the computer
> If you have a named instance you should use the named instance name (for
> example: unlodctr.exe MSSQL$InstanceName).
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "em" <em@.discussions.microsoft.com> wrote in message
> news:C2C1B0E8-2FE0-488F-A085-C392CDA89E5C@.microsoft.com...
>
>
Can you please clarify if you can access the performance counters on the
local machine and the problem is with remote access? How is that one machine
that works fine different than the others? Are there any related messages in
Event Log or the log files?
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"em" <em@.discussions.microsoft.com> wrote in message
news:8DA8FEEC-77F4-451C-9508-280F5F038745@.microsoft.com...[vbcol=seagreen]
> well, it doesn't look so good.
> i did all the troubleshoot i could find in the web but with a minor
> success.
> it's not a corrupted registry, counters or something like that. out of 5
> different machine - only one agreed to cooperate and allow access to those
> counters remotely. the rest had varius behavior...
> i tried lodctr, unlodctr, exctrlst, diskperf -Y and re-register
> sqlctr80.dll
> with regsvr32 - with no maijor success. even though i got an error message
> for the command "regsvr32 sqlctr80.dll" about an entry point that it
> couldnt
> find, i don't think that's the problem.
> any more assistance will be appreciated.
> thanks, em.
> "Plamen Ratchev" wrote:

Performance Counters

Hi all.
I've got a SQL Server 2k sp3 on Win 2003.
It has the Performance Counters listed for SQL Server, but when I select any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
Hi
You may want to check your event logs to see if anything is being
logged.
Check sysperfinfo to see what information is there.
Rebuild the performance counters:
http://support.microsoft.com/default...b;en-us;300956
John
|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1109147319.860891.81450@.f14g2000cwb.googlegro ups.com...
> Hi
> You may want to check your event logs to see if anything is being
> logged.
> Check sysperfinfo to see what information is there.
> Rebuild the performance counters:
> http://support.microsoft.com/default...b;en-us;300956
> John
>
Okay... nothing in the sysperinfo table. That would explain why the
counters are reading 0. I'm still trying to track down the problems
though. I will try the rebuild later today and see what happens.
Rick

Performance counters

Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/defaul...kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>

Performance Counters

Hi all.
I've got a SQL Server 2k sp3 on Win 2003.
It has the Performance Counters listed for SQL Server, but when I select any
of the counters, they don't show any activity.
Any ideas?
Thanks,
RickHi
You may want to check your event logs to see if anything is being
logged.
Check sysperfinfo to see what information is there.
Rebuild the performance counters:
http://support.microsoft.com/defaul...kb;en-us;300956
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1109147319.860891.81450@.f14g2000cwb.googlegroups.com...
> Hi
> You may want to check your event logs to see if anything is being
> logged.
> Check sysperfinfo to see what information is there.
> Rebuild the performance counters:
> http://support.microsoft.com/defaul...kb;en-us;300956
> John
>
Okay... nothing in the sysperinfo table. That would explain why the
counters are reading 0. I'm still trying to track down the problems
though. I will try the rebuild later today and see what happens.
Rick

Performance Counters

This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all.
I've got a SQL Server 2k sp3 on Win 2003.
It has the Performance Counters listed for SQL Server, but when I select = any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi all.

I've got a SQL Server 2k sp3 on Win = 2003.

It has the Performance Counters listed for SQL = Server, but when I select any of the counters, they don't show any activity.

Any ideas?


Thanks,


Rick

--=_NextPart_000_0011_01C5191B.23066440--Hi
You may want to check your event logs to see if anything is being
logged.
Check sysperfinfo to see what information is there.
Rebuild the performance counters:
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1109147319.860891.81450@.f14g2000cwb.googlegroups.com...
> Hi
> You may want to check your event logs to see if anything is being
> logged.
> Check sysperfinfo to see what information is there.
> Rebuild the performance counters:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
> John
>
Okay... nothing in the sysperinfo table. That would explain why the
counters are reading 0. I'm still trying to track down the problems
though. I will try the rebuild later today and see what happens.
Ricksql

Performance counters

Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>

Performance Counter Problems

Hi,
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/defaul...0&Product=sql2k
Steve|||Steve,
Thanks a lot!
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!sql

Performance Counter Problems

Hi,
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827260&Product=sql2k
Steve