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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-10-13 : 06:36:14
|
| My query is running very slow , i used index, defragmentation, querytuning . but still performance not improved. this report is statistics report, based on this what to improve in my query.COUNTER Value AverageApplication Profile Statistics Timer resolution (milliseconds) 0 0Number of INSERT, UPDATE, DELETE statements 0 0Rows effected by INSERT, UPDATE, DELETE statements 0 0Number of SELECT statements 2 2Rows effected by SELECT statements 1.70022e+006 1.70022e+006Number of user transactions 7 7Average fetch time 0 0Cumulative fetch time 0 0Number of fetches 0 0Number of open statement handles 0 0Max number of opened statement handles 0 0Cumulative number of statement handles 0 0Network Statistics Number of server roundtrips 3 3Number of TDS packets sent 3 3Number of TDS packets received 28569 28569Number of bytes sent 2054 2054Number of bytes received 1.16501e+008 1.16501e+008Time Statistics Cumulative client processing time 974 974Cumulative wait time on server replies 2.28888e+009 2.28888e+009 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 21:40:11
|
| Did you check execution plan? Checked performance counters in perfmon? |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-10-16 : 02:45:02
|
| yes i checked execution plan .. but i have asked about execution plan also in deep knowledge.In that plan , index scan or seek shows.. but other things how to validate in execution plan.I wish to know all the terms shows in execution plan.Still , i cud not get clear reply. |
|
|
|
|
|
|
Query statistics