sql 2012 sharepoint instance slow to startup

Question

Post reply

sql 2012 sharepoint instance slow to startup

ManicStar

SSCoach

Points: 17992
More actions
March 16, 2015 at 6:48 am

#295957

We have our sharepoint production on sql 2012 with 2008 server. Whenever this machine is patched, the SQL instance can take over 3 minutes to start up, and it seems to have needed manual intervention to get it going the last few patch cycles.
I can't see anything thrown in the system logs or event logs for SQL. Is this an expected behavior with a sharepoint farm?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27055 More actions · Answer 1

Just guessing, but...

What is tempdb sized at?

Do you have instant file initialization enabled? To do this, the SQL Server service account needs to be granted "perform volume maintanance tasks" permissions in the local security policy.

And, I know this, but I don't remember it, I'm pretty sure that this is not unusual for SharePoint.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

ManicStar SSCoach Points: 17992 More actions · Answer 2

Hmm.... good question. Is there a recommended size of tempdb as a % of the rest of the size of the farm databases?

Right not its not overly large, initial size is 38 mb db, 10 mb log autogrow by 10%.

Tempdb is also on a different storage than the rest of the user databases in the farm.

Also, I seem to be unable to find where to set the timeout value for the initial startup connection, I'd like to bump it up to see if that will at least be enough to get the service starting on its own after reboot.

Lowell SSC Guru Points: 323518 More actions · Answer 3

also how many VLF's are there?

run DBCC LOGINFO on your Sharepoint database; you might need to reduce them.

http://blogs.msdn.com/b/saponsqlserver/archive/2012/02/22/too-many-virtual-log-files-vlfs-can-cause-slow-database-recovery.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!