Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

what's the possible reason to cause dbcc running automatically?

I have a sp which truncates a large table(large 3G) and insert data into the table again(rebuild data for this table). When I run it on a production, it is fine.

but when I run it on a dev, it is very slow. After check the info in detail, I found there are lot of dbcc running during the sp running time.

when running the sp, got output like frequently:

09:35:58.865DBMSmysyb -- SQL Text: exec myproc ...
09:35:58.896DBMSmysyb -- DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
09:35:58.912DBMSmysyb -- DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
09:36:00.599DBMSmysyb -- DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

Not sure why. Before running the sp, somebody try to partition this table and then remove the partition. not sure if this is the reason.

So how to find out the reason for this dbcc? it is running automatically. If dbcc checktable or dbcc reindex will resolve this problem?

Former Member
Not what you were looking for? View more on this topic or Ask a question