Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Agent - SQLSTATE 21000 error Expand / Collapse
Author
Message
Posted Friday, February 12, 2010 1:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
Run a standard trace and write to a table. Once the error occurs check the table around that time to see what is going on. You could also extract which objects use subqueries and start to narrow them down. If all else fails run a trace returning everything and narrow it down and start and end time
Post #864481
Posted Friday, February 12, 2010 4:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:48 AM
Points: 43, Visits: 362
The only thing I have found running a standard trace is that SQL Agents runs stored proc about every half-minute called msdb.dbo.sp_sqlagent_get_perf_counters and it also runs a select statemen... SELECT N'Testing Connection...'
Post #864538
Posted Friday, February 12, 2010 5:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:48 AM
Points: 43, Visits: 362
I did a bit of reading on google about sp_sqlagent_get_perf_counters and then deleted the demo alerts from the alerts folder in the SQL Agent and that seemed to have solved the problem!
Post #864543
Posted Friday, February 12, 2010 9:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
Hi,

Can you run DBCC on MSDB database and see if you are getting any error(s)? To me is looks some kind of Corruption is system tables.

Deepak



Post #864749
Posted Tuesday, September 11, 2012 2:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:36 PM
Points: 321, Visits: 1,278
Hi ,
Are you able to solve this problem ? i found this same error message in my production Environment .
Please share the knowledge if you have or anyone have solved this problem
Thanx


Aim to inspire rather than to teach.
SQL Server DBA
Post #1357702
Posted Tuesday, September 18, 2012 9:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 14, 2012 1:18 PM
Points: 2, Visits: 5
Hi, i have the same problem. I was looking with profiler, stored procedure with subquery, etc y didn´t find.

I found tha the problem is an Alert to check the CPU. If you disabled this Alerts, the log stop.

But, i need the alert
Post #1360850
Posted Tuesday, September 18, 2012 9:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 14, 2012 1:18 PM
Points: 2, Visits: 5
I resolved that disabled the Alert
Post #1360854
Posted Wednesday, March 20, 2013 10:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:08 PM
Points: 1, Visits: 6
I received the same message after setting up a SQL Performance Counter Alert. I disable all of my alerts and turned them back on 1 at time checking the error log until I found the offender.

Cedric
Post #1433339
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse