Saturday, February 25, 2012

Cannot connect to SQL until after service is restarted

A new database and application was installed on my SQL Server. Recently
users cannot connect to the database. I cannot even connect with Enterprise
Manager or Query Analyzer. Some users were getting an error message telling
them there was not enough memory.
I am getting the following message in the logs:
WARNING: Failed to commit contiguous memory of Size 65536.
I've configured the SQL Server system to allocated up a minimum of 512MB and
a maxium of 2GB of memory.
Are there any thoughts on how to resolve this problem? Thanks for your
attention.
Tech Details:
SQL Server 2000 Standard
OS: Windows Server 2003 (Small Business Server 2003)
2 Processors (P4 Xeon 3.06Ghz)
4GB memory
Application (Zoll Data Systems?)Can you post the output from sp_configure? Preferably also attach as a text
document to preserve
formatting.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Jonathan" <Jonathan@.discussions.microsoft.com> wrote in message
news:15715A15-D833-4C89-B8E8-6B8D12B7C18F@.microsoft.com...
>A new database and application was installed on my SQL Server. Recently
> users cannot connect to the database. I cannot even connect with Enterpri
se
> Manager or Query Analyzer. Some users were getting an error message telli
ng
> them there was not enough memory.
> I am getting the following message in the logs:
> WARNING: Failed to commit contiguous memory of Size 65536.
> I've configured the SQL Server system to allocated up a minimum of 512MB a
nd
> a maxium of 2GB of memory.
> Are there any thoughts on how to resolve this problem? Thanks for your
> attention.
> Tech Details:
> SQL Server 2000 Standard
> OS: Windows Server 2003 (Small Business Server 2003)
> 2 Processors (P4 Xeon 3.06Ghz)
> 4GB memory
> Application (Zoll Data Systems?)

No comments:

Post a Comment