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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2010-03-25 : 16:44:30
|
| How to optimize the query..whether i need to see the read,write,Duration or CPU |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-25 : 16:48:28
|
| Indexes, execution plan, rewriting the query, changing the database design, fixing the hardware, updating statistics, defragmenting or rebuilding idnexes... The list could go on and on.Could you be more specific? Do you have a specific query in mind that we can help you with?To see reads, writes, duration, and cpu, check SQL Profiler.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Tuning Techniques