Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harpalsgh
Starting Member
1 Post |
 Posted - 2008-09-13 : 02:55:23
|
| sometimes i am facing insertion/selection/updation problem in our database problem.i think its due to indexing because our database transactions/sec is to high.thousand of records insert and same time selection and deletion queries are also fire on table.as i think its due to only indexing and due to lot of updation,insertion and deletion index need to rebuild.can any body suggest me what i do and how to rebuild all index on all tables in database.Harpal Singh s/w devveloperHi-Tec Point Technologies Pvt. Ltd.S.C.O. 96-97, Sector 34-AChandigarh - 160022Mobile : +91-9216957609 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-13 : 23:41:05
|
| If Database is highly OLTP(transactional),then you shouldn't have more indexes . As you perform high DML operation, all index pages and data pages gets updated/inserted as well, so the result will be highly fragmented index. You can find lots of script to see the fragmentation level ,Reorg or Rebuild based on fragmentation level. |
 |
|
|
|
|
|
data insertion problem