Skip to Content
0
Former Member
May 14, 2014 at 01:03 PM

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

321 Views

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.865 DBMS mysyb -- SQL Text: exec myproc ... 09:35:58.896 DBMS mysyb -- DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. 09:35:58.912 DBMS mysyb -- DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role. 09:36:00.599 DBMS mysyb -- 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?