- 2 Posts
- 10 Views
Auto kill long-running PSQuery?
What are your thoughts about having a script that automatically kills SQL run by PSQuery that runs beyond a certain duration?
Love it/done it
Like the idea, never done it
No opinion
Make me nervous
Never
@Charles-Benson I like the idea, never done it.
I'm not a query expert but it gives me pause. At the very least I would wonder if killing sql related to a psquery would have any affect on how Query Administration sees the query. I also wonder about a time that would work for most queries unless you're thinking about duration of an hour or more. Those might not be issues.