Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error 512 when creating CPU Usage Alert

Author  Topic 

Nawar.Tabaa
Starting Member

2 Posts

Posted - 2011-02-02 : 02:18:42
I created a performance condition alert that monitors the "CPU Usage %" counter at the Resource Pool Stats object. Once enabled I keep getting the following entry written to the agent error log:

Message
[298] SQLServer Error: 512, Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. [SQLSTATE 21000]

Any ideas?

Thanks

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-02-02 : 05:14:35
post the script/query
Go to Top of Page

Nawar.Tabaa
Starting Member

2 Posts

Posted - 2011-02-02 : 05:36:52
EXEC msdb.dbo.sp_add_alert
@name=N'CPU Usage',
@message_id=0,
@severity=0,
@enabled=0,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@performance_condition=N'SQLServer:Resource Pool Stats|CPU usage %|default|>|25',
@job_id=N'00000000-0000-0000-0000-000000000000'


Thanks,
Go to Top of Page

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-02-02 : 06:06:09
Sorry but not sure if this could be as i think the error is due to an "Inner Select" statement of a "Script" for which you are getting more than one value.
Go to Top of Page

Cristian
Starting Member

1 Post

Posted - 2012-09-18 : 11:22:28
I have the same problem.
Go to Top of Page
   

- Advertisement -