February 16, 2009 at 8:11 am
Hi to all,
my problem is that some user-generated queries run very long. This queries block the server with 100% cpu consumption.
I have tried to set the server timeout for SSAS to 30 sec. but that didn't work. 🙁
Is there any other option for setting the query-timeout?
Thank you very much!
-----------------------
SQL Server Database Copy Tool at Codeplex
February 16, 2009 at 9:29 am
This is something you have to set on the client side. If you are working with ADO, try setting the CommandTimeout property.
Regards
Gianluca
-- Gianluca Sartori
February 16, 2009 at 9:35 am
... OOOPS! ... I didn't notice you were talking about SSAS!
Well, it doesn't matter anyway: it's always left to the client to set a timeout for the queries. If you already tried to set it in SSAS, I don't know any other ways to achieve it. Since I had the same problem with some applications, I can only tell you that this MUST be done on the client side and there is no way to do this in the database engine.
-- Gianluca Sartori
February 16, 2009 at 2:14 pm
Jetro.
May I suggest you review this known bug in SSAS (2005) - as the possible source of the problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply