Tuesday, November 07, 2006

Chris Webb's BI Blog: Imposing Query Timeouts

Chris Webb's BI Blog: 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?"

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home