MSDE and Performance Counters

[Scott Lezberg]

Is there any reason why there are no SQL performance counters for MSDE
installations? Can these be redistributed?

Thanks

Scott Lezberg
Deltek Systems, Inc.
slez...@ma.deltek.com

[Neil Pike]

Scott - I don't believe there is any licensing issue with you installing perfmon counters yourself..

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7 - SQL Public)
or www.ntfaq.com/sql.html
or www.sql-server.co.uk
or www.mssqlserver.com/faq

[Scott Lezberg]

Thanks...how would I install the SQL performance counters? Is it a single
DLL?

Thanks

Scott

"Neil Pike" <10057...@compuserve.com> wrote in message
news:VA.0000482...@compuserve.com...

[Neil Pike]

Scott - below should give you the info you need.

> Thanks...how would I install the SQL performance counters? Is it a single

Q. I can't see the SQL performance counters in PerfMon. What could be wrong?

A. It could be a variety of things.

1. Sometimes rebuilding the registry for 6.5 and below fixes the problem. From the <sql>\binn directory run the following, making sure the case is
correct

setup /t RegistryRebuild = On

The setup routine will now run and ask you all the normal questions. Answer these as if you were performing the install again (same paths etc.) and it
will just update all the registry entries/icons etc. It will leave the databases alone.

2. For SQL 7 try unloading and reloading the counters

unlodctr.exe MSSQLServer
lodctr.exe <sql>\BINN\sqlctr.ini

3. For 6.5 machines running on NT 4.0 it could be a permissions problem.

To work around this problem, use Regedit.exe to grant READ access to the
following key of the target machine:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

Grant this to those wanting SQL counter access. As when granting any NT
access permission, you can grant based on an individual user or a group.

4. For SQL 6.5 and below the probe password is not null.

5. SQL Server is listening on an alternate pipe - not \\.\pipe\sql\query

v1.01 2000.04.09
Applies to SQL Server versions : All
FAQ Categories : Troubleshooting
Related FAQ articles : perfcountersnotappearoncluster
Related Microsoft Kb articles : Q137899 "BUG: SQL Counters Not Available Under Integrated Security"
Other related information : n/a
Authors : Neil Pike

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)

SQL FAQ (484 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7 - SQL Public)