Category
Administration
Product Version
9.0
Stop Runaway Query
Answered
Is there a way to find/stop runaway queries, where the report is running to long and bogs the server down?
The same question
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
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
Chris,
Microsoft SQL Server.
Thanks,
Zack
Chris,
Microsoft SQL Server.
Thanks,
Zack
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:
Check values under CPUTime and DiskIO. Note the SPID of process having large value comparatively. Then type
kill {SPID value}Kind regards,Chris
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:
Check values under CPUTime and DiskIO. Note the SPID of process having large value comparatively. Then type
kill {SPID value}Kind regards,Chris
Thank you, Chris.
- Zack
Thank you, Chris.
- Zack
Hi Zack,
No worries! I'll mark this as answered but let me know if there's anything else.
Kind regards,
Chris
Hi Zack,
No worries! I'll mark this as answered but let me know if there's anything else.
Kind regards,
Chris
Replies have been locked on this page!