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

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


asked 29 Jun '16, 09:31

patrickwill's gravatar image

accept rate: 0%

closed 01 Jul '16, 07:14

JeffMorriss's gravatar image

JeffMorriss ♦

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.

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." 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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 29 Jun '16, 09:31

question was seen: 1,597 times

last updated: 01 Jul '16, 07:14

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