Slow Query In Profiler Shows 0 CPU, Reads, or Writes

Question

Slow Query In Profiler Shows 0 CPU, Reads, or Writes

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mike-306849 SSChasing Mays Points: 607 More actions · Answer 1

I found the cause of the problem, an incorrect web service was installed on a server that was making the calls. Still weird that I never saw a block or an open transaction though.

Steve Jones - SSC Editor SSC Guru Points: 739545 More actions · Answer 2

Did you have any filters applied besides the time? It's possible that something held you up, but it didn't take a long time itself to complete.

mike-306849 SSChasing Mays Points: 607 More actions · Answer 3

Duration was the only filter. I wish I knew a little more about the web service making the call, but as soon as I asked a developer a question about it they had replaced it with the current one an gave the old "move along, nothing to see here...". Oh well, it's all working properly now.