General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Sql-Sever 2000 DBA Help
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.