Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
1  
You are using custom code to send these emails? – Toni Frankola Mar 12 '12 at 22:52
I'm not sure I understand, you have a process which sends 100k+ emails from your SharePoint server, which locks your site, and when you kill connections to your content database it resolves the lock? – Louis Mar 12 '12 at 23:01
Are these alerts, or is this a workflow - my guess is there is a delete/update method called for each item, each in a separate trans. which is locking the database. – Russell Mar 13 '12 at 5:41
1  
Need more implementation details from the OP. – Russell Mar 13 '12 at 5:41

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.