To improve the performance of data collection or reporting, consider enhancing the SQL Server memory and processor.
Ziehen Sie eine Erweiterung des Arbeitsspeichers und Prozessors von SQL Server in Betracht, um die Leistung der Datenerhebung und Berichterstellung zu verbessern.
Significant portion of SQL Server memory has been paged out
To prevent this from happening, the SQL Server memory usage can be limited by configuring the memory to be limited, instead of dynamic.
Um dies zu verhindern, kann die Speichernutzung von SQL Server begrenzt werden, indem keine dynamische, sondern eine beschränkte Speicherkonfiguration festgelegt wird.
Without this option, the operating system expe‧riencing memory pressure can page out to disk consid‧erable parts of SQL Server memory, leading to serious stability and performance issues.
Ohne diese Option kann das Betriebssystem unter Speicherbelastung beachtliche Teile des SQL Server-Speichers auf die Festplatte auslagern, was zu ernsthaften Stabilitäts- und Leistungsproblemen führt.
There is a 54.35% (559 MB) increase in memory usage with 20,000 server VDA sessions when Local Host Cache outage mode is active, mainly due to SQL server memory consumption.
The Total Server Memory(KB) counter of the SQL Server:Memory Manager performance object accurately represents the memory that is allocated for the buffer pool.
Examples are used only to help you translate the word or expression searched in various contexts. They are not selected or validated by us and can contain inappropriate terms or ideas. Please report examples to be edited or not to be displayed. Potentially sensitive, inappropriate or colloquial translations are usually marked in red or in orange.