Enabling SQL performance monitoring objects

How do I enable the SQL performance monitoring objects to be used by
performance monitor? The objects were in the list at one time but now they
have vanished?
--
Best regards
Mark Baldwin
Software Developer"Mark Baldwin" <swozz_@.hotmail.com> wrote in message
news:XMSdnaHx_r0qLnLcRVn-hQ@.giganews.com...
> How do I enable the SQL performance monitoring objects to be used by
> performance monitor? The objects were in the list at one time but now they
> have vanished?
> --
> Best regards
> Mark Baldwin
> Software Developer
>
>
I have seen this before in prior versions and it was a matter of rerunning a
particular script from setup disk. I don't remember which one and which
version of SQL Server is applied to.
Here is a KB article however that may be of some use:
http://support.microsoft.com/kb/227662
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Counters may disappear when you don't close performance monitor before
restarting SQL Server. See MSKB 812915
<http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k>.
This is scheduled to be fixed in SP4, which is currently in beta
http://support.microsoft.com/default.aspx?scid=kb;en-us;888799.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark Baldwin" <swozz_@.hotmail.com> wrote in message
news:XMSdnaHx_r0qLnLcRVn-hQ@.giganews.com...
> How do I enable the SQL performance monitoring objects to be used by
> performance monitor? The objects were in the list at one time but now they
> have vanished?
> --
> Best regards
> Mark Baldwin
> Software Developer
>
>|||Mark
If you are able to do it, the following may fix your problem.
At the command prompt, type in the following:
unlodctr.exe MSSQLServer
Then type in the following:
lodctr.exe <SQL Server path>\binn\sqlctr.ini
Reboot the server
Hope this helps
John
"Dan Guzman" wrote:
> Counters may disappear when you don't close performance monitor before
> restarting SQL Server. See MSKB 812915
> <http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k>.
> This is scheduled to be fixed in SP4, which is currently in beta
> http://support.microsoft.com/default.aspx?scid=kb;en-us;888799.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Mark Baldwin" <swozz_@.hotmail.com> wrote in message
> news:XMSdnaHx_r0qLnLcRVn-hQ@.giganews.com...
> > How do I enable the SQL performance monitoring objects to be used by
> > performance monitor? The objects were in the list at one time but now they
> > have vanished?
> >
> > --
> > Best regards
> > Mark Baldwin
> > Software Developer
> >
> >
> >
>
>