Apr 22, 2018 Alon

SQL: Table corrupted
MS-SQL, SQL

Symptoms : SQL cannot select, insert or update data from table.

Impact : Critical

Data cannot be selected from or inserted into one or more tables causing loss of data to the application.

Expected behavior :

This alert indicates unexpected behavior and needs to be investigated.

Possible causes

IO subsystem level problem  Priority : Critical
Failure of some hardware component handling data traffic or storage is the most likely reason for this error. The elements involved are:

  • Drives
  • Controllers
  • Incorrect Drivers

Recommended action :
Firstly, identify the faulty component and repair/replace. Next, perform database integrity checks:

    • Run SQL DBCC checkdb
    • Run Disk-Check utility

In case of damage or loss of integrity, locate most recent database backup and restore the table with assistance of DB Admin.

Background

Corruption of one or more tables will strongly affect functionality and availability. Building levels of redundancy (clustered servers, cloud-based infrastructures etc.) will minimize impact, but the only sure way to guarantee full recovery in the shortest possible time is to maintain comprehensive up-to-date backup routines.

You may also like this

Mar 24, 2018 Alon

SQL: Buffer Cache Hit Ratio

Reports the ratio of the data pages found and read from the SQL Server buffer cache and all data page requests. Pages that are not found in the buffer cache must be read from disk

MS-SQL, Performance, SQL
Apr 22, 2018 Alon

Host: CPU Utilization

Measures the load of all the tasks that are being performed by the server. CPU usage below 70% is considered normal. Unusual levels of CPU load activities may be coming from anti-virus scans, backups, restores etc.

Operating System, Performance, Windows

RECENT POSTS