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

NETWORK PACKET ...... Expand / Collapse
Author
Message
Posted Thursday, May 14, 2009 6:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 28, 2014 5:07 AM
Points: 40, Visits: 213
Dear All,

We have banking application user run the report . During that phase application used specifiec query which take 80-90 min to run the application. during that time i check the locking and blocking it's normal. i run the sysprocesses it's seem 4 processor is used to generate query and SYNC_NETWORK_IO which send packet to client.

During that phase i chage Network packet size 4096 to 32767 but when i run the query that particular query still used 4096 bytes and otehr application used 32767.

pls help me out to more about this details;;;;;



:) :) :)
Amey ghag
<a href='http://' class='authorlink' target='_blank'></a>
Post #716848
Posted Thursday, May 14, 2009 6:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:41 AM
Points: 47, Visits: 795
Have you ruled out the network card(s) on the server? This has happened a few times in the past to me and the cards needed to be replaced or were aged
Post #716860
Posted Thursday, May 14, 2009 7:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 28, 2014 5:07 AM
Points: 40, Visits: 213
No,... Coz our database server is laying at Phinix US and we are not able to physically check the server but it is stad. server there is no such issue with network card... may be..

:) :) :)
Amey ghag
<a href='http://' class='authorlink' target='_blank'></a>
Post #716953
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse