Sql-Sever 2000 DBA HelpLocked
Their is a specific problem in my ms-sqlsever 2000
database as i am having 3 Big tables A,B,C and each table contains around 1 million record and all 3 tables contains clustered index which is always incremented and apart of that their are unclustered index also on each tables. My system is OLTP where lot of insertions and selections of data through asp page take place. Each single entry of record adds records in all the 3 tables.
But at times their are lot of timeout errors in select queries and even in the insert queries. On running sp_who2 i had found that some select queries are blocking insert operation. And Insert
queries are blocking other select queries thus
resulting in lot of timeouts. Earlier the clustered index was not incremental and thus sometimes i had to face chainlinkage error then i changed the clusted index in all the three tables
to other key but then queries start executing very slow and so i revert back my clustered index
to the previous key with the change that clustered index will be always incremental. Can
anyone suggest what need to be done to improve the situation.