Insufficient Resource Space

Troubleshooting SQL Server

Troubleshooting

Insufficient Resource Space

If a Microsoft® SQL Server™ configuration option is set too high for the amount of available resources, SQL Server fails to start. For example, if the max server memory setting is too high, other applications may take some time to start.

Reset configuration options to their default values or start SQL Server with minimal configuration by using the -f startup option of the sqlservr application. For more information about setting default values, see the Setting Configuration Options or sp_configure (T-SQL).

See Also

Setting Configuration Options

sp_configure

sqlservr Application