Re: Raising up numbers of Locks Request

Tech-Archive recommends: Fix windows errors by optimizing your registry

well, when i close all my application i check the connections on my DB and
see no more SPID on the activity monitor. So is not a connection non
terminated or some application non terminated. And i'd like to underline the
usually my system works very well, also when we have many connections and
many requests. every two o three days i've got this problem, as SQL Server
did not release locks or resources or something so.


"Tibor Karaszi" wrote:

To me this sounds like some application which doesn't terminate (even
though you close all applications), and is hanging with some open
transaction that has these locks open. I'd start with trying to
pinpoint if that is the case using sp_who, sp_who2, sp_lock etc.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"FrancescoCavani" <FrancescoCavani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:2B5B5A57-3503-4E5B-AE00-F7A366AF4ACC@xxxxxxxxxxxxxxxx
I've got a SQL Server 2005 DB. some clients (about 30) connected to
hime with
my applications. 5 clients use the db hard.
Some times a week i've got this problem on the server: the DB
performances
have a big degrade. My queries takes a lot of times to run. Much
more than
usual. This happens not when i've got a many requests from my
applications,
but seems random. Looking into performance monitor of the server i
can see
raising up the number of Lock Request in SQLServerLocks. When the
system work
normally this numebers changes between 0 and 30.000. When i've got
this
problem this numbers reaches more then 200.000 and remains so high.
And all
my DB queries take much time to run. I can close all my
applications, but the
server remains overloaded, the numbers of locks remains so high. To
restore
normal work condition i have to restart SQL2005 service.
My server have SQL Server standard edition. SP2.

Any help or any idea?

Thanks




.

Relevant Pages

  • Consisten kernel hang during heavy TCP connection handling load
    ... I have written a pair of applications the server side of which consistently causes my Linux Fedora Core 2 system to become ... The applications engage in the rapid opening and closing of TCP connections. ... If pointed in the right direction, I would be happy to perform further forensics after re-creating the hang. ...
    (Linux-Kernel)
  • Re: Raising up numbers of Locks Request
    ... To me this sounds like some application which doesn't terminate (even though you close all applications), and is hanging with some open transaction that has these locks open. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: DB Connections Remain Open After Application Requests Close
    ... All SQL Server providers have implemented connection pooling for some time ... If the connections are not closing within 4-8 minutes of being closed by the ... > ASP.NET applications and Web services that are holding these connections. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.NET Application Gets Frequent SQL Timeout Exceptions
    ... The first think I would do was to use the SQL profiler to see by instance what other processes are locking the connections. ... The server is fully patched with all updates, Windows, ... non-enterprise applications (I.E., applications that are written in VB6 or ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Raising up numbers of Locks Request
    ... How much does SQL Server consume? ... --- Which user has executed the SQL statement that's holding the locks? ... my applications. ... My server have SQL Server standard edition. ...
    (microsoft.public.sqlserver.server)