Stop Runaway Query

Zack Wilson shared this question 3 months ago
Answered

Is there a way to find/stop runaway queries, where the report is running to long and bogs the server down?

Comments (5)

photo
1

Hi Zack,

There might be a timeout limit for queries. I'm just going to verify this for you.

What database system are you running Yellowfin on?

Kind regards,

Chris

photo
1

Chris,

Microsoft SQL Server.


Thanks,

Zack

photo
1

Hi Zack,

So a long running report usually has an option to either wait or cancel, otherwise you can open your RDBMS software and type:

sp_who2 'active'

Check values under CPUTime and DiskIO. Note the SPID of process having large value comparatively. Then type


kill {SPID value}
Kind regards,

Chris

photo
1

Thank you, Chris.

- Zack

photo
1

Hi Zack,

No worries! I'll mark this as answered but let me know if there's anything else.

Kind regards,

Chris