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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-11-03 : 15:03:29
|
| Hi,I have been told to go to a client site and find out why their sql server slows down during/after a data feed. They have a shopping site.I do know that this is abit unclear but what do I start looking into when I get there?I do have some clues but I just would like to know how you deal with such an issue.Thanks |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-11-03 : 15:09:57
|
| STATISTICS!!! The first thing I would look at is indexes. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-03 : 15:45:40
|
| During the data feed will just be due to the way they are doing it - probably just inserting into tables or heavy merging. They should either change it to work with a live site or live with it.Being slow afterwards is probably due to recovering from the load - recompiling, checkpoints etc.Why are they sending you?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
optimization