February 25, 2015 at 8:05 am
I am getting 2 to 3 error messages per minute about Error: 512 (Subquery returned more than one result) in the Error Log. It doesn't tell me which query is causing it. I tried turning on SQL Server Profile and running a trace but I can't identify a query that is executing that often. Is there another way to determine which query is causing this error?
February 25, 2015 at 8:08 am
How specific was your Profiler Trace? It's normally pretty good at trapping stuff like this, although you've not given us any detail on the size of the database, likely throughput, nature of typical queries running, etc.
If you've just looked at the default trace or started a new one off but not tweaked it much, there's a good chance that we can help you to refine it to allow it to help.
February 25, 2015 at 8:15 am
You could create an extended event session looking for that error and returning the sql text of the query.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2015 at 8:20 am
I found the issue. It was being caused by an alert that was set up to monitor the CPU utilization. Here is a screenshot of the alert.
February 25, 2015 at 8:23 am
Not quite what I was expecting you to find, but well done!
Enjoy the rest of your day.
February 25, 2015 at 10:24 am
para40tn (2/25/2015)
I found the issue. It was being caused by an alert that was set up to monitor the CPU utilization. Here is a screenshot of the alert.
What app was this alert configured in?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2015 at 11:51 am
It wasn't created in an app. The user who set it up just right clicked on Alerts in SQL Server Management Studio and created a new alert.
February 25, 2015 at 3:13 pm
para40tn (2/25/2015)
It wasn't created in an app. The user who set it up just right clicked on Alerts in SQL Server Management Studio and created a new alert.
You should file a connect item for that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply