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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-24 : 09:44:40
|
| Dave writes "I have a very large table (44 million rows) to which I add about 2.5 million rows each month. After inserting, queries which normally run in about 8 seconds will run slower -- taking up to a minute to complete. After a day or so everything returns to normal.The table has a couple of non-clusetered indicies (nothing is clustered).Why does this happen? Would partiioning the table help? Any other suggestions to improve performance?Thanks!" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-24 : 10:15:46
|
| "...a day-or-so"...after statistics are updated overnight/ after database reorg is run overnight??please post regular execution plan and if available execution plan during slowdown. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-24 : 13:26:18
|
| Sounds like stats update to me too ... or possibly SProc recompileKristen |
|
|
|
|
|
|
Performance lags, then improves after large inserts