Last post Aug 27, 2012 08:14 AM by Ajay2707
Aug 27, 2012 06:17 AM|Siva_V|LINK
I got a new requirement:
I am using vs2010 and i have crystal reports running in server and there will be number of users accessing it and each crystal each report executes in it's own session in sql server, is it possible to stop/kill the each report process using c# code (OR)
if there any monitoring option in sql server to manually stop the crystal report process.
Is it possible to see the list of reports running in the server in a separate page(aspx page) using c# (vs 2010) and if any report is taking longer than expected to run can we stop/kill that particular crystal report. Its like having a monitoring page in
asp.net to see the list of reports running(which is executed by the users) and to stop/cancelling it.
OR is there any monitoring options in sql server to manually stop the crystal report which is taking longer time to execute?
Please any advice on this and any help will be appreciated and its urgent to have a solution on this whether it is possible or not.
Aug 27, 2012 08:14 AM|Ajay2707|LINK
to kill the process manually, there is "KILL" command in sqlserver.
but that is not good idea. Actualy the problem is making a sp or query which get the result is not proper or query optimization is needed.
you can use more and more where condition with use of index or primary column which retrieve data faster. your sub report also get execute when you use it.
Whenever report hit sqlserver , it create process for data fetch. after that it will automatically killed by sqlserver when all data will fetched.
So there is in your hand how to get data faster. so load will decrease in sqlserver.