Category Archives: Troubleshooting

Mirroring suspends with Assertion error

Posted on 2013/05/13 by brentm

Assume the following scenario: You are performing a Bulk Insert or BCP into a table of a database that is the principal in a database mirroring pair. The BCP or Bulk Insert succeeds but the mirror is now in a … Continue reading →

Posted in Mirroring, Troubleshooting | Comments Off on Mirroring suspends with Assertion error

Failed data collector upload job

Posted on 2012/12/11 by brentm

When the MDW data collector fails the upload job,  the cached files start building up and the MDW database starts getting out of date. If you look at the SQL agent job history for the upload job you will likely … Continue reading →

Posted in Troubleshooting | Comments Off on Failed data collector upload job

DBCC IND and DBCC PAGE

Posted on 2012/07/03 by brentm

DBCC IND – use to lookup what pages are allocated to an object Syntax: DBCC IND ( database_name, table_name, index_id ) NOTE: there must be records in the table before this will return a result set. NULL values in the … Continue reading →

Posted in Troubleshooting | Comments Off on DBCC IND and DBCC PAGE