Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Out of Memory
Message
From
07/08/2002 09:19:56
 
 
To
06/08/2002 18:31:20
Sergio Cespedes
Productos Pelikan, S.A de C.V.
Puebla, Mexico
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
00686767
Message ID:
00687004
Views:
52
>Task manager reports 75% of SQL Server memory. Can I send you a Image of this situation to believe me??? Tell me how??

I believe you. BTW this may not be a problem if the server is dedicated to SQL Server. SQL Server 7 & 2000 will manage memeory as needed. You can configure it but MS suggest that you just let it be.

>I thing that every conection to my SQL server, requires about 20Mb, if I have 30 users max., is around 700Mb including SQLserver.

You can't assume that the working set size divided by the number of connections is the amount of memory that SQL Server is using for each connection. The data cache will consume most of the memory. There are various perfmon counters that you can use to get an idea of what going on.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform