Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1588

Re: Increase Service Startup Timeout Value?

Show all headers | View raw

Joe Cool (joecool1969@live.com) writes:
> I do all of my development work in a 64bit Windows 7 Virtual Machine
> using VMWare. In order to test software in multiple versions of SQL
> Server I have four instances running in it, a SQl Express and SQL
> Server instance for both 2005 and 2008.
> 
> Mmost of the time one or more instances will fail to start at boot
> time. The event log indicates that it failed to start in the alloted
> time, 30000 milliseconds.
> 
> I looked through all of the instances properties but could not find
> anywhere that I could boost that value up any. I tried checking the
> boost priority checkbox on the processor page but that didn't help.
 
This timeout is not SQL Server-specifc, but a general Windows parameter. 
You can control it through the registy. The key name is
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SerivcesPipeTimeout. It 
should be a DWORD, and the value is in milliseconds.

Beware that the name has "Services" in plural. I had it spelt in singular
on my machine, and it was driving me crazy why it did not work, when
it worked on another machine.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Increase Service Startup Timeout Value? Joe Cool <joecool1969@live.com> - 2011-02-01 11:08 -0800
  Re: Increase Service Startup Timeout Value? Erland Sommarskog <esquel@sommarskog.se> - 2011-02-01 22:42 +0100

csiph-web