we have stored procedure which process the responses from student once the student submit the test,And this stored procedure consuming time and hence hindering the concurrency.
I wouldn't usually start with asynchronous processing in this unless you had a hundred students trying to submit simultaneously, but I'd start with optimizing the query itself. What you might want to do is start a forum post in one of the optimization forums appropriate to the version of SQL server you're using. See the link in my signature on the best way to get help for index/tuning (second link down on the left).
So thought of moving to asynchronous processing of this SP.I walkthrough the article but didnt get clear idea to implement our requirement.At runtime this SP accepts parameters.
Can you please do the favour in accomplish the task.
You would need to provide a LOT more information to help you walkthrough your specific case. However, the short form of this: In regards to your parameters, what you'll end up doing is taking in the parameters as you are now, and turning that into an XML message. That message then gets sent to the 'Waiting Queue'. The 'Processing Queue' accepts messages from the 'waiting queue', turns the XML back into SQL variables, and runs your existing query. Once done, it returns an 'end dialog' message back to the 'waiting queue' to tell it to clear that message.
If you really want to get into a full SB solution for this, we should probably wander off to a dedicated thread, as it's going to be a bit of discussion and specifics to help you get where you need to be.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake. For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA