Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

query statistics Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 13, 2007 5:59 AM
Points: 3, Visits: 3
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.I wish to know what are all things has to be improved based on this report.



COUNTER Value Average



Application Profile Statistics



Timer resolution (milliseconds) 0 0



Number of INSERT, UPDATE, DELETE statements 0 0



Rows effected by INSERT, UPDATE, DELETE statements 0 0



Number of SELECT statements 2 2



Rows effected by SELECT statements 1.70022e+006 1.70022e+006



Number of user transactions 7 7



Average fetch time 0 0



Cumulative fetch time 0 0



Number of fetches 0 0



Number of open statement handles 0 0



Max number of opened statement handles 0 0



Cumulative number of statement handles 0 0







Network Statistics



Number of server roundtrips 3 3



Number of TDS packets sent 3 3



Number of TDS packets received 28569 28569



Number of bytes sent 2054 2054



Number of bytes received 1.16501e+008 1.16501e+008







Time Statistics



Cumulative client processing time 974 974



Cumulative wait time on server replies 2.28888e+009 2.28888e+009
Post #410278
Posted Saturday, October 13, 2007 10:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
This is very nearly a duplicate post...

http://www.sqlservercentral.com/Forums/Topic410280-65-1.aspx

The only thing that means anything about performance for all the timers you have here is this...

Number of TDS packets received 28569 28569
Number of bytes sent 2054 2054
Number of bytes received 1.16501e+008 1.16501e+008

It means you asked for a lot of data... and got it... The number of bytes returned are in excess of 100 million bytes and you did it all with two selects. That's a lot of information to stream over a pipe...


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #410345
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse