GilaMonster (5/9/2013)
sql-lover (5/9/2013)
Killing those ad-hoc queries after X minutes will release the IO pressure. So instead of hammering the SAN for 5+ minutes, if they are not done my 1 min or less , they will be killed.then the user will re-run the query and it'll hammer the SAN for another minute, be killed, be re-run, be killed, repeat until the user gets fed up and complains to management that they can't do their work.
You're addressing the symptoms, not the problem.
Hmmm... now I see your point.
Let me play a bit with resource governor. But something it is clear to me, I do not want to limit or affect other users or clients, which shares the same instance, so need to test this carefully.