• VLDB

    VLDB very large database DBCC checkDB

    Database corruption – DBCC checkDB for Very large database We know SQL server data is stored in a filesystem storage. There has been always an (I/O) input and output interaction between SQL server and storage subsystem both in the memory and disk. IO subsystem plays a major role, 99% of the time database corruption can happen with IO subsystem (Such as in the controllers, disk and driver level etc.) In this post, I am sharing few things. 1. How important is the CHECKDB. 2. How to fine tune and use the checkDB for VLDBs. 3. Methods of troubleshooting the corruption issues. Storage / VM Admin:  Sent a graph states that, IOPS…