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.