Hi all
when i cancelled the report , report will close but query(data) is running backend Server.
how can i stop this
Thanks & Regards
ANIL K.MARRI
Quote from: anilkumar on 12 Oct 2010 01:40:51 AM
Hi all
when i cancelled the report , report will close but query(data) is running backend Server.
how can i stop this
Thanks & Regards
ANIL K.MARRI
it happens all the time, bcoz ur running the report at presentation layer, when u going to Canceling /Terminating the report from web interface,it can't stop the report query firing on data sources.bcoz that request is parsed through the dispatcher to execute on the data sources
all this happens because dispatcher acts asynchronous when the requests & responses submitted at a atime.
Guru's correct me if i'm wrong
is there any way to stop
Yes, at the backend itself. You do not state what database you are using , but in general each database will have Governor settings that allow for a certain degree of control
Hi blom0344
Thank u for help iam using sybase database, in database where we can set governance,
we can set in framework manager
Thanks & Regards
ANIL K.MARRI
From a DB perspective your DBA would need to look up on:
http://www.databasejournal.com/features/sybase/article.php/3866671/Using-the-Sybase-ASE-Resource-Governor.htm