SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

No Comments

There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

This message is displayed when DBCC command is ran for any database. It is harmless and displayed for information purpose only. For each database DBCC commands displays number of rows and number of pages it is using. DBCC CHECKALLOC is an exception of this message.

Use the REPAIR options only as a last resort. NOINDEX is maintained for backward compatibility only and does not affect DBCC CHECKALLOC. DBCC CHECKALLOC does not check FILESTREAM data. FILESTREAM stores binary large objects (BLOBS) on the file system. If you must use REPAIR, run DBCC CHECKDB without a repair option to find the repair level to use. The DBCC CHECKALLOC functionality is included in DBCC CHECKDB and DBCC CHECKFILEGROUP. This means that you do not have to run DBCC CHECKALLOC separately from these statements.

Running DBCC CHECKALLOC against tempdb does not perform any checks. If DBCC CHECKALLOC reports any errors, Microsoft recommends that you restore the database from the database backup instead of running a repair. A repair can be performed in a user transaction. This allows for changes to be rolled back.

Please leave a comment with your feedback in the comments section.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Exit mobile version