SQLServerPedia

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.

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.