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.