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.
