Browse Site by Tags

Showing related tags and posts accross the entire site.

SQL Server and Windows Memory

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve memory not in use by other applications and the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 05-15-2008
Filed under: sql server, memory, windows, 2000, 2005, 32-bit
SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently as compared to SQL Server 2000 version. As one of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 03-07-2008
Filed under: sql server, performance, memory, dmv, windows, 2000, 2005, awe, 64 bit, monitoring, worker threads, paging out, buffers, verison

Page 1 of 1 (2 items)

Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Browse Site by Tags

SQL Server and Windows Memory

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.