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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2008-09-24 : 02:40:18
|
| I have to query a database and ensure the query does not impact too much on the performance of the database/server.Could anyone advise as to the best way forward? could/should I sample a small dataset first, if so how/what would be the best way to do it? and how could I measure possible impact? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 02:46:32
|
| Just run your query on test databse and see how it performs by analysing query execution plan or by running profiler. Identify costly steps and try rewriting query to reduce the execution time. See if you could add indexes on your table to make query retrive results faster. |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2008-09-24 : 05:32:40
|
| Thanks. |
|
|
|
|
|
|
Query impact on live database