| Tibor Karaszi 2006-10-24, 6:38 pm |
| How much memory in the machine?
A lot of apps using memory on the machine?
Did you specify max server memory for SQL Server? If so, what value?
Try starting SQL Server using the /f switch and specify a reasonable value for max server memory
(see sp_configure for that).
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/60e8ef0a-0851-41cf-a6d8-cca1e04cbcdb.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Sachin" < annonymous@microsoft
.com> wrote in message news:em%235ur88GHA.4348@TK2MSFTNGP03.phx.gbl...
> Hi All,
>
> I am using SQL Server 2005. It was working fine.
> However all of a sudden I am getting following error.
>
> It fails to start the MSSQLSERVER and SQL Server Agent services with and
> error: The request failed or the service did not respond in a timely
> fashion. Consult the event log or other applicable error logs for details.
>
> In the log I discover other error:
>
> a.. Unable to allocate enough memory to start 'Query Processor'. Reduce
> non-essential memory load or increase system memory.
> Any help or pointer?
>
> Thanks in advance
> Sachin
>
>
|