Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Out of Memory
Message
De
07/08/2002 09:19:56
 
 
À
06/08/2002 18:31:20
Sergio Cespedes
Productos Pelikan, S.A de C.V.
Puebla, Mexique
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
00686767
Message ID:
00687004
Vues:
53
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform