I have read BOL before but I was confused by that collation chart because HK SAR should use Tradition Chinese which is 950 but the chart suggests 936 which is PRC Simplified Chinese. Any idea?
We are running SQL 7 with SP2. Recently, we encountered couples of deadlock situation that a process holding an exclusive lock on an unknown resource was blocked by the process which was trying to perform a checkpoint.
Spid 27 5
Status Sleeping...
I have restarted our SQL 7.0 server many times for the last few days. I found there was a process with "LCK_M_X" lock blocked by the CHECKPOINT process. It appeared that the CHECKPOINT process was running log backup at that time. Can someone tell me while the CHECKPOINT process was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.