Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server 2000 maxes out memory and inserts crawl
Message
De
17/10/2003 08:28:06
 
 
À
16/10/2003 17:11:22
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00839527
Message ID:
00839681
Vues:
22
It's definitely SQL Server. It seems like SQL is caching the table data in RAM but never freeing up the memory again. I haven't found anythng related to my problem at MS but am still looking.
Do you know of anyway to adjust the amount of time SQL Server holds data in RAM before flushing it out to the disk and freeing up the memory? I've had a few more knowledgable database people tell me that SQL NEVER gives up the memory and that every SQL server needs to be rebooted periodically - is this true?

Thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform