Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system
memory to run this query.
--
Thanks,
Mr GeekWithout seeing a stack dump file , it is hard to say exactly what is causing
the problem.
Are the queries that trigger this problem , dealing with UNION ALL or IN
with largae data sets?
Have you thought about upgarding to sp4?
--
Jack Vamvas
__________________________________________________________________
"LSolve" <L0L@.newsgroups.nospam> wrote in message
news:F4561270-E1BA-4B4C-9841-DA55FE250789@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
give
> similar error message.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient
system
> memory to run this query.
> --
> Thanks,
> Mr Geek|||Hello,
Please refer to the following article which describes how to troubleshoot
the slow performance of many concurrent ad-hoc queries:
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lsolve,
If u want to check that ur sql server need more merory then check this
artical .
http://www.computerperformance.co.uk/HealthCheck/Memory_Health.htm
from
Doller