|
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 ;)
| 
