April 29, 2005 at 10:06 am
Hai,
I am getting the following warning message in SQL Server Logs
"Warning SQL Cache memory usage: 558 pages "
for the last three days am getting this warning in the logs.
Can anybody help me to sort out this , please.
This SQL 2K Clustering on Windows 2003
subhash
subban
April 29, 2005 at 10:12 am
Never see this type message, Do you use third party tools to admin/monitor your SQL Server?
April 29, 2005 at 10:15 am
No, am not using any third party software for monitoring.
The server is having 8 GB of memory available
subban
April 29, 2005 at 10:17 am
Check to see any trace flags eanbled.
dbcc tracestatus (-1)
April 29, 2005 at 10:20 am
i have executed dbcc tracestatus(-1), it is giving:
'Trace options() not enabled for this connection. use DBCC TRACEON()'
subban
May 1, 2005 at 9:56 pm
I assume that the message reads like the following:
Warning: SQL cache memory usage: %d (pages). If this condition persists, see the Error Log Messages topic in Troubleshooting.
Books on line has the following as an explanation of the message:
The Microsoft® SQL Server™ cache consumes memory and holds ad hoc and prepared SQL text. This message occurs if the SQL Server cache exceeds a certain number of pages of server memory. For example, this error occurs if one or more clients are preparing large numbers of SQL statements without performing corresponding unprepare operations. This lack of corresponding unprepare operations can be due to poor application design, an application bug, or repeated creation of prepared SQL text.
This message will be printed again if server memory changes significantly and if the memory consumption of the SQL Server cache remains high.
Either warn the suspected clients that server memory is at a low level or terminate suspected connections using KILL.
Hope this helps
May 2, 2005 at 5:50 am
Hai,
Ok, this can be the reason.....
thanks a lot
subban
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply