locked
SharePoint database connection locks? RRS feed

  • Question

  • I have an issue with SharePoint content database. Daily starts 3 PM emails were sent to at least 100K users. This period content database completely Locking out and No request is accepting from Web users.

    When I used below sql command on sql server content databases I can see Number of connection atleast 150 (on which emails were sending database)

    SELECT 
        DB_NAME
    (dbid) as DBName,
        COUNT
    (dbid) as NumberOfConnections,
        loginame
    as LoginName
    FROM
        sys
    .sysprocesses
    WHERE
        dbid
    > 0
    GROUP BY
        dbid
    , loginame

    If I use below SQL statement to kill connection on particular database. Immediately User can access for site.

    ALTER DATABASE WSS_Content_80_Prod SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    ALTER DATABASE WSS_Content_80_Prod SET MULTI_USER

    But problem is emails sending process takes 4 hours to complete for all users. Mean while I have kill the active connections all time.

    Guru, please help me on this to handle


    ItsMeSri MOSS, 3 WEFs

    Monday, March 12, 2012 9:56 PM

Answers

All replies