Re: long running queries

From: Mark Hill (mark_at_mark[dash)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 20:53:18 GMT

<rinkijain@gmail.com> wrote in message
news:1106855807.092586.38510@c13g2000cwb.googlegroups.com...
> Hi
>
> Is there a way to detect and stop long running queries either in MS
> Analysis services or through Proclarity (cube browser)? For example if
> users try to put large dimensions on rows and columns with drill down
> that would result in a large data set and complex query, we would like
> to stop them.
>
> Rinki Jain
>

In a word NO, this is a subject very close to my heart because of my own
experiences.

I don't know if you are using XMLA, if you are then there are some ways to
manage your user community, give me a shout offline if you want some more
info on that.

Some of the client tools will warn you if the query looks like its going to
return a lot of data , intelligent apps being one of those. I do not think
Proclarity does this.

I have spoken to MS in depth about this, and there appears to be no reliable
way of doing this in AS 2000 once the query has been submitted.

One other approach we did try was closing TCP connections on the server when
a certain amount of traffic had been sent down the wire, this is pretty
crude and IMHO causes more problems than its worth.

Mark

Relevant Pages