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

get a SQL alert Expand / Collapse
Author
Message
Posted Thursday, August 16, 2012 3:22 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 1,749, Visits: 3,153
I just got a SQL alert:
What does it mean, I see it generates some errors in sql log, see attachment.

It looks it is related with sharepoint serach account. But I see our sharepoint server runs OK.
It did not tell me what database name though, this is going to be hard for me to troubleshoot, because we have quite a few sharepoit databases on the server.

What to do to troubleshoot this?


It looks like the
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 5243
Date: 8/16/2012
Time: 1:21:50 PM
User: mydomain\sys$searchshptportal
Computer: SQL1

Description:
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 14 00 00 16 00 00 00 {.......
0008: 09 00 00 00 53 00 4e 00 ....S.N.
0010: 4f 00 43 00 53 00 51 00 O.C.S.Q.
0018: 32 00 30 00 00 00 1a 00 2.0.....
0020: 00 00 53 00 68 00 61 00 ..S.h.a.
0028: 72 00 65 00 64 00 53 00 r.e.d.S.
0030: 65 00 72 00 76 00 69 00 e.r.v.i.
0038: 63 00 65 00 73 00 32 00 c.e.s.2.
0040: 5f 00 53 00 65 00 61 00 _.S.e.a.
0048: 72 00 63 00 68 00 5f 00 r.c.h._.
0050: 44 00 42 00 00 00 D.B...


  Post Attachments 
Capture.GIF (10 views, 40.72 KB)
Post #1346268
Posted Thursday, August 16, 2012 4:25 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:59 PM
Points: 23,000, Visits: 31,482
Contact Customer Support at Microsoft.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1346284
Posted Friday, August 17, 2012 4:13 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 15,517, Visits: 27,895
And make sure your backups have been running for the last several days. Make a copy of the backups. If you have log backups prior to the error, make sure you have a copy of those too. You may be going into a DR scenario soon.

Personal choice, I'd run DBCC on the database to see if I can spot an error or a problem even before I'd call Microsoft.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1346450
Posted Sunday, August 19, 2012 6:30 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:26 AM
Points: 1,749, Visits: 3,153
It turns out everything works fine.
We did a DBCC check on each database, there is no error.

So not sure what happened.

Thanks,
Post #1346969
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse