Performance monitor

18 Jan 2005 5:05 PM

Bryan Schmidt

Hi All,
I have an SQL server with two instances (default and stage). I have
performance montior objects available for stage but the default objects are
gone and I have no way to generate performance stats for the default
instance. This happened after I added the stage instance. I really need the
counters for default as it is the production instance. I could do without
the MSQL$STAGE objects

--
Thanks,
Bryan Schmidt
Area101

18 Jan 2005 8:15 PM

Andrew J. Kelly

Have you tried restarting that instance? Ensure there is nothing monitoring
any of the counters when you do the restart. This may be of interest as
well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k

--
Andrew J. Kelly SQL MVP

Show quote

"Bryan Schmidt" <BryanSchm***@discussions.microsoft.com> wrote in message
news:61D538F7-26B6-46DA-AF77-D6C3094A6428@microsoft.com...
> Hi All,
> I have an SQL server with two instances (default and stage). I have
> performance montior objects available for stage but the default objects
> are
> gone and I have no way to generate performance stats for the default
> instance. This happened after I added the stage instance. I really need
> the
> counters for default as it is the production instance. I could do without
> the MSQL$STAGE objects
> --
> Thanks,
> Bryan Schmidt
> Area101

25 Jan 2005 12:23 AM

Bryan Schmidt

Thanks Andrew,

I have already looked at that one and it is not the case. I checked the
event logs and sql logs if any issues. At this point I am ging to move the
stage instance to it's own server, remove it from this server and see if that
helps.

Thanks again,
Bryan

Show quote

"Andrew J. Kelly" wrote:

> Have you tried restarting that instance? Ensure there is nothing monitoring
> any of the counters when you do the restart. This may be of interest as
> well:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Bryan Schmidt" <BryanSchm***@discussions.microsoft.com> wrote in message
> news:61D538F7-26B6-46DA-AF77-D6C3094A6428@microsoft.com...
> > Hi All,
> > I have an SQL server with two instances (default and stage). I have
> > performance montior objects available for stage but the default objects
> > are
> > gone and I have no way to generate performance stats for the default
> > instance. This happened after I added the stage instance. I really need
> > the
> > counters for default as it is the production instance. I could do without
> > the MSQL$STAGE objects
> > --
> > Thanks,
> > Bryan Schmidt
> > Area101
>
>
>