• Thanks for reply

    Sir,

    I have run both the scripts , but could not get any result.

    But i diagnose the dm_os_ring_buffer exception records , i found there are many errors with code 2627 (which means can not insert duplicate records ,violation of unique key or primary key) , and sudden server's cpu utilization spikes up to 100%. After 2-3 minutes it automatically goes down.

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.