Post reply

Query Running at Management Studio stops SQL Server from responding to queries fired through ASP .net Application

  • August 6, 2014 at 6:10 am

    #309729

    We have a SQL Server 2008 running which provides data base access to out asp.net applications. But when we run queries on the Management Studio the Database server does not respond to the Web based accesses. This is more true for queries which takes longer time to finish.

    Is this a standard behavior?

    The operating system is Windows Server 2012 R2 Standard, Server RAM is 40 GB.

    Thanks

    Dibakar Ray

  • August 6, 2014 at 9:36 am

    #1735697

    I'm assuming that the problem is intermittent as you mentioned long running queries effecting the connection more than slow running queries.

    I came across a similar issue recently which is documented in the following link;

    http://stackoverflow.com/questions/834124/ado-net-calling-t-sql-stored-procedure-causes-a-sqltimeoutexception/839055#839055

    If the problem isn't intermittent and you can connect via ssms and not .Net then you should look at your connection string.

    Hope this helps.

    --------------------------------------------

    Laughing in the face of contention...

  • August 6, 2014 at 9:39 am

    #1735698

    Thanks for the reply. I will check and respond back

  • August 6, 2014 at 9:47 am

    #1735703

    A long running select query may temporarily block a stored procedure attempting an update, insert, or delete on same table. The opposite can also be true, an update transaction held open may block a select query. You can run sp_who2 proceure to list all processes and blocked status.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

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

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