We want to limiting resource intensive queries on our SQL2005 transactional system - particularly at month end.
As documented the only method to do this in 2005 appears to be the query governor cost limit config parameter or the set QUERY_GOVERNOR_COST_LIMIT connection setting.
Has anyone experience with this? Or are there any alternatives.
I will be looking at this over the next month or so and will post my experiences here.
regards
John Reidy.