missing sql alert catergory

Hi,
When you go to EM and try to define a new alert
under 'management', 'sql server agent', there should have
two types of alerts in the selection: 'sql server event
alert', and 'sql server performance condition alert'.
One of my server is missing the second type of alert (It's
not in the drop-down box).
Any thought on what happened there and how to get it back?
Thanks a lot.
JJDo you have the SQL Server perfmon counters in perfmon? Any rows in
master..sysperfinfo? Is SQL Server started with the -x switch?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> Hi,
> When you go to EM and try to define a new alert
> under 'management', 'sql server agent', there should have
> two types of alerts in the selection: 'sql server event
> alert', and 'sql server performance condition alert'.
> One of my server is missing the second type of alert (It's
> not in the drop-down box).
> Any thought on what happened there and how to get it back?
> Thanks a lot.
> JJ|||thanks, Tibor.
You are right on the target! sql server perfmon counters
are missing in perfmon on this server as well. And there
is nothing in master..sysperfinfo.
How can I get them back without risking potentially harm
the system?
SQL Server started with the -x means 'Disables the keeping
of CPU time and cache-hit ratio statistics. Allows maximum
performance.' right? I did not start sql server
explicitly this way. our server is set to be auto-restart
and I think we are just using the default settings for
startup.
Why should I choose '-x'?
thanks.
JJ
>--Original Message--
>Do you have the SQL Server perfmon counters in perfmon?
Any rows in
>master..sysperfinfo? Is SQL Server started with the -x
switch?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
>> Hi,
>> When you go to EM and try to define a new alert
>> under 'management', 'sql server agent', there should
have
>> two types of alerts in the selection: 'sql server event
>> alert', and 'sql server performance condition alert'.
>> One of my server is missing the second type of alert
(It's
>> not in the drop-down box).
>> Any thought on what happened there and how to get it
back?
>> Thanks a lot.
>> JJ
>
>.
>|||JJ,
I was thinking that perhaps the SQL Server was started with the -x switch
and that was the reason the counters was missing. EM, right-click the
server, Startup Parameters.
I suspect, however that the counters aren't properly registered in the
registry. There's an exe files that does this, but I always forget the name
of this file. I didn't find it in the SQL Server directories, so it is
probably in the windows directory somewhere. I suggest that you search the
archives or post a new thread with appropriate subject.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:058c01c3a97d$22e5d680$a401280a@.phx.gbl...
> thanks, Tibor.
> You are right on the target! sql server perfmon counters
> are missing in perfmon on this server as well. And there
> is nothing in master..sysperfinfo.
> How can I get them back without risking potentially harm
> the system?
> SQL Server started with the -x means 'Disables the keeping
> of CPU time and cache-hit ratio statistics. Allows maximum
> performance.' right? I did not start sql server
> explicitly this way. our server is set to be auto-restart
> and I think we are just using the default settings for
> startup.
> Why should I choose '-x'?
> thanks.
> JJ
> >--Original Message--
> >Do you have the SQL Server perfmon counters in perfmon?
> Any rows in
> >master..sysperfinfo? Is SQL Server started with the -x
> switch?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> >> Hi,
> >>
> >> When you go to EM and try to define a new alert
> >> under 'management', 'sql server agent', there should
> have
> >> two types of alerts in the selection: 'sql server event
> >> alert', and 'sql server performance condition alert'.
> >>
> >> One of my server is missing the second type of alert
> (It's
> >> not in the drop-down box).
> >>
> >> Any thought on what happened there and how to get it
> back?
> >>
> >> Thanks a lot.
> >>
> >> JJ
> >
> >
> >.
> >