Imposing Query Timeouts

I’m currently having an interesting email conversation about the lack of a query governor in Analysis Services and how useful it would be, and Darren Gosbell mentioned a new connection string property I wasn’t aware of: timeout, which allows you to specify a timeout in seconds for your queries. To test this you’ll need to open a tool which supports AS connection string properties (SQLMS doesn’t) like MDX Sample app, and simply put
in the connection string. This means that any query which takes longer than one second to execute will fail in one second. How could I not know about something as useful as this?
UPDATE: I’ve just heard from Mosha that apparently all XMLA command properties can be used in the connection string.

4 thoughts on “Imposing Query Timeouts

  1. OMG! That IS useful! However, like the XMLA "Cancel" command, I think it will suffer from the fact that apparently not all sub-routines in AS are built to handle the cancelling of a query – hence it will not always terminate immediately on the server. It\’s still a great tip, though. :-)

  2. Just to clarify – Timeout is not the new connection string property. It existed since AS2000 SP4. Also, since AS2005 uses XMLA as underlying protocol, _ALL_ XMLA command properties are available as connection string properties both in OLEDB and ADOMD.NET.
    Mosha (

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s