This is our old Q&A Site. Please post any new questions and answers at ask.wireshark.org.

The problem is I'm seeing a 22 second delay coming from the pc on a sql batch. I trying to find out what is causing the delay and I know you supposely was you spot the delay you look what is happening before your frame # to see why it is delayed. My question is if the captured is interwined with out conversation do you just resort the no column and what ever frame number shows the delay you look above that to see what was going on like the picture below:

alt text

or should filtered on that stream where the delay is to determine what is causing the delay like the picture below:

alt text

Thanks

asked 29 Jun '16, 09:31

patrickwill's gravatar image

patrickwill
0445
accept rate: 0%

closed 01 Jul '16, 07:14

JeffMorriss's gravatar image

JeffMorriss ♦
6.2k572

just out of curiosity, is SQL running on a VM or physical machine?

(29 Jun '16, 13:08) net_tech

it is a vm machine

(29 Jun '16, 15:40) patrickwill

the bug described in the KB below would be responsible for sql performance degradation, but not 22 seconds delay you mentioned in your post.

it also would be helpful if you describe your environment, so we don't have to guess.

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2129176

the delay could be caused by insufficient memory, slow disk or cpu. have you looked at the perfmon values?

(29 Jun '16, 18:07) net_tech

The question has been closed for the following reason "Duplicate Question - A 2nd question was opened for this; closing this one as a duplicate since the other one has a capture file. https://ask.wireshark.org/questions/53703/slow-performance-on-aveva-software" by JeffMorriss 01 Jul '16, 07:14

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×752
×82
×21

question asked: 29 Jun '16, 09:31

question was seen: 1,331 times

last updated: 01 Jul '16, 07:14

p​o​w​e​r​e​d by O​S​Q​A