469,945 Members | 2,262 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

query is slow after inserting lots of records in some tables

Hy all,
( sql server 2000 ) I have trouble with my indexes in my database after I inserted lots of data in some user tables ( 10000 + insert ). I need to pinpoint where to look to solve my problem.

- My database have about 50 tables, for a total of a couples of mb ( testing purpose database, real production database have 10 GB + ).
- All query in the database run smootly. But after a importation process that inserted lots of data, my sql is peaking at near 100% CPU. Each time, I need to pass a maintenance plan to reindexes the indexes ( of doing the same using t-sql ).
- Auto update statistic is on in the bd.
I really think that my querys are optimized well because, without the insert in the table, they work fine.
I'm sure I not supposed to do this kind of thing in a good sql setup.

Any idea where to start looking to help to solve my problem ?



Just to mention that i'm not a newbie in SQL ( 8+ years and MCP SQL 2000 ). You can go in technical stuff in the answer ;)
Aug 25 '08 #1
1 1728
ck9663
2,878 Expert 2GB
Here are some re-indexing tips.

-- CK
Aug 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by DBNovice | last post: by
4 posts views Thread by DFS | last post: by
2 posts views Thread by mattytee123 | last post: by
7 posts views Thread by mp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.