Imposing Query Timeouts

Chris's profileChris Webb's BI BlogBlogLists

< Previous Next >

11/2/2006

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

timeout=1

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.

1:22 PM | Blog it | MDX

Comments (2)

To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in

Don't have a Windows Live ID? Sign up

	Moshawrote: 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 (http://www.mosha.com/msolap) Nov. 2
	Michael Barrettwrote: 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. :-) Nov. 2

Trackbacks

The trackback URL for this entry is:

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!932.trak

Weblogs that reference this entry

None