Post reply

link hanged from asp.net

  • December 16, 2011 at 12:09 am

    #247824

    hi folks,

    from the front end, users retrieve data from asp.net page.

    in the drop down menu there 4-5 options are there, each option retrieves their relavent data from SQL server 2005 sp2. in that 4-5 options all are working fine and retrieving data quickly except one option.

    if the user selects that option then application is getting hanged.

    i checked for any blockings/deadlocks in SQL Server. but, no findings.

    Later i restarted SQL server services then it is running fine. after a day the problem repeated again.

    any help regarding this..?

  • December 16, 2011 at 5:12 am

    #1422403

    Hello,

    are you firing a Stored Procedure or query?

    Kindly try the SP or query with the parameter directly on database and check. if the problem is there in DB as well as well just post the SP or query with the input parameter which is getting hang.

    hope i can help after that.

    Regards
    Durai Nagarajan

  • December 16, 2011 at 5:52 am

    #1422422

    durai nagarajan (12/16/2011)

    Hello,

    are you firing a Stored Procedure or query?

    Kindly try the SP or query with the parameter directly on database and check. if the problem is there in DB as well as well just post the SP or query with the input parameter which is getting hang.

    hope i can help after that.

    I'm suspecting the same thing durai is...parameter sniffing for a procedure; or maybe stale statistics, since it seems to work for a while and then progressively gets worse.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 18, 2011 at 10:30 pm

    #1422955

    Hi,

    From the database end i ran a SP for that link which is executing in 5-6 seconds.

    The problem is coming from front-end especially for one option and the other links are also accessing the same procedure which are displaying fine from front end page..

    Kindly help me on this..

  • December 18, 2011 at 11:18 pm

    #1422960

    Hello,

    can you post the SP code and the code you use to call sp( input datatype and how it runs on DB)

    Regards
    Durai Nagarajan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply