Wait_type null

Question

Post reply

Wait_type null

gana79950

Old Hand

Points: 371
More actions
August 16, 2019 at 10:24 pm

#3671985

Hi,
I' have query running an avg 14 seconds every time it gets executed and I'm trying to find what that session is waiting for.
I'm using sp_whoisactive procedure and I'm seeing wait_info as NULL. What does that mean? how to find what this session is waiting for?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

It means it's not waiting on anything. Since you're doing more than 4 million reads (more than 31GB of I/O), you likely have some performance challenged code that needs to be reworked.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

gana79950 Old Hand Points: 371 More actions · Answer 3

Thanks Jeff,

How did you convert 4 million reads to 31 GB of IO ?

Sue_H SSC Guru Points: 90860 More actions · Answer 4

A logical read is an 8K page. Divide the reads by 128 to get the MB. Divide by 1024 to get GB.

Sue

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

gana79950 wrote:

Thanks Jeff,
How did you convert 4 million reads to 31 GB of IO ?

Sue_H wrote:

A logical read is an 8K page. Divide the reads by 128 to get the MB. Divide by 1024 to get GB.
Sue

Just to clarify what Sue wrote... dividing the number of pages by 128 will return the number of MB the pages represent. You would have to divide THAT number of MB by 1024 to get GB. Or, you can just divide by 131,072, which is 128*1024.

So, 4,075,902 / 131,072 = ~31.096664GB.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)