Missing Performance Counters

I know that some of you have not only seen this happen, but have also
replied to similar posts. I have tried the whole unlodctr --> lodctr thing
several times and have read through MS documentation regarding possible
registry issues. I am at a standstill. Has anyone else been unsuccessful
in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
did you find a workaround? ThanksNot sure if this can help you :
http://www.extremeexperts.com/sql/faq/EnablingPerCounters.aspx
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Sean" <sdmgill@.hotmail.com> wrote in message
news:eAJpI1DmDHA.2000@.TK2MSFTNGP12.phx.gbl...
> I know that some of you have not only seen this happen, but have also
> replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> several times and have read through MS documentation regarding possible
> registry issues. I am at a standstill. Has anyone else been unsuccessful
> in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> did you find a workaround? Thanks
>|||Sean,
Do you see any error messages in the errorlog when starting sqlserver? Does
it say anyting about unable to allocate shared memory eraly on or doesn;t it
start the global collection task somehow?
--
regards,
Mario
http://www.sqlinternals.com
"Sean" <sdmgill@.hotmail.com> wrote in message
news:eAJpI1DmDHA.2000@.TK2MSFTNGP12.phx.gbl...
> I know that some of you have not only seen this happen, but have also
> replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> several times and have read through MS documentation regarding possible
> registry issues. I am at a standstill. Has anyone else been unsuccessful
> in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> did you find a workaround? Thanks
>|||On Tue, 21 Oct 2003 18:37:22 -0700, "Sean" <sdmgill@.hotmail.com>
wrote:
>I know that some of you have not only seen this happen, but have also
>replied to similar posts. I have tried the whole unlodctr --> lodctr thing
>several times and have read through MS documentation regarding possible
>registry issues. I am at a standstill. Has anyone else been unsuccessful
>in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
>did you find a workaround? Thanks
I just noticed something.
I have one copy of perfmon in my startup folder. I checked, and it
lacked the SQLServer counters.
I do not automatically start SQLServer on my workstation. I manually
started it, then started a second instance of perfmon. SQLServer
counters were there.
Your mileage may vary.
Joshua Stern|||But eh.., isn't that how it should work? If there's no sqlserver there are
no counters..
--
regards,
Mario
http://www.sqlinternals.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:301gpvodc69j5cmc3gvsg8fqm6agbl21om@.4ax.com...
> On Tue, 21 Oct 2003 18:37:22 -0700, "Sean" <sdmgill@.hotmail.com>
> wrote:
> >I know that some of you have not only seen this happen, but have also
> >replied to similar posts. I have tried the whole unlodctr --> lodctr
thing
> >several times and have read through MS documentation regarding possible
> >registry issues. I am at a standstill. Has anyone else been
unsuccessful
> >in regaining SQL Counters using the Unlodctr and Lodctr commands? If so,
> >did you find a workaround? Thanks
> I just noticed something.
> I have one copy of perfmon in my startup folder. I checked, and it
> lacked the SQLServer counters.
> I do not automatically start SQLServer on my workstation. I manually
> started it, then started a second instance of perfmon. SQLServer
> counters were there.
> Your mileage may vary.
> Joshua Stern
>|||On Thu, 23 Oct 2003 18:48:09 +0200, "Mario" <nospam@.sqlinternals.com>
wrote:
>But eh.., isn't that how it should work? If there's no sqlserver there are
>no counters..
If you ask me, no, that is not how it should work.
Should be based more on what is installed, than on what it sees at
startup. After all, my first instance still didn't see the started
SQLServer. And if the server is remote, and not started, or gets
bounced, you get all kinds of interesting permutations. Etc.
J.|||I see your point. But anyway, that's how it works on my testserver too..
--
regards,
Mario
http://www.sqlinternals.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:tg4gpvk693u4dv5u16d9utlio884lg3fos@.4ax.com...
> On Thu, 23 Oct 2003 18:48:09 +0200, "Mario" <nospam@.sqlinternals.com>
> wrote:
> >But eh.., isn't that how it should work? If there's no sqlserver there
are
> >no counters..
> If you ask me, no, that is not how it should work.
> Should be based more on what is installed, than on what it sees at
> startup. After all, my first instance still didn't see the started
> SQLServer. And if the server is remote, and not started, or gets
> bounced, you get all kinds of interesting permutations. Etc.
> J.
>