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 |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2009-11-30 : 02:39:27
|
| I ran the performance tool and it made several recommendations to speed up one of the more costly queries in our web application. I implemented the recommendations and it did improve the performance of the query in question. Unfortunately, it had a horrible impact on another query and I didn't notice it until a client submitted a support request.My question is... how can you determine or at least estimate the impact of these recommendations on the dozens of existing queries that make use of the table to which you are applying the new index? You can't really test in a development environment because the data and load are not the same there. Any recommendations?Thanks. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-30 : 05:08:26
|
| Test, test, test in a representative environment. No other way to tell.p.s. If that was Database Tuning Advisor that you used, it's recommendations should be taken with a large pinch of salt and tested carefully. It makes stupid recommendations from time to time.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Impact of indexes on queries