Yes.

There is no clustered index. Vendor specific database.

Thank you.

Thanks Jonathan. A followup question, why shouldn't care about index fragmentation on indexes which has 1000-5000 page count ? I have read somewhere or some video, i dont remember.  Why...

Thank you very much.

3rd party.  And some of the code they have customized.

As per app team, this query is executed several times and response times are higher (3-5 secs). We checked for blocking scenarios,

waiting for locks, what other things to be checked ...

Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think with open...

• This reply was modified 2 years, 6 months ago by vsamantha35.

Getting awareness of how these small things go bad when data increases and more concurrency and more applications access the same central database with multiple integrations. Thanks a lot Sir....

Almost without...

Hi Jeff,

This is the same sp_whoisactive job which runs every 10 secs. if we are lucky enough sometimes , we are able capture those 3 sec SLA queries. Sorry for...

oops.. my bad. once a minute for spids running over day yes.

Thanks you very much Jonathan, Grant Sir and Jeff. Thank you.

Ah... totally got it.  Thank you for the feedback.

Understood on the 3 second SLA but that doesn't seem to be the predominant issue.  The 1 or 2 day sleeping...

Frankly, speaking my intention was not KILL but want to prove that connections are kept open with locks held and blocking other spids. When we discuss the same with the...