472,119 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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 1806
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.