var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: new to MS SQL - fine tune SQL2000
Lock Type request wait time signal waitime
LCK_M_IX 86.0 102985.0 141.0
LCK_M_S 324.0 971591.0 64.0
I have the above information for my server 2000 and what are these lock type and where should I look and correct to reduce the total wait time of them?
It is a heavily insert application and the database can grow 2 GB a day for OLTP transactions.