![]() ![]() Rightsizing Memory for SQL Server and why it’s importantīefore digging into technical details, it’s a worthwhile to cite the following document: “One of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Note: For the purpose of this posts we are discussing SQL server installations on Windows Server Guest OS. The post below guides you through the usage of the memory resource by Microsoft SQL Server (SQL Server) and how we should approach the monitoring and rightsizing memory for SQL Server on VMware vSphere on in VMware powered cloud (like VMware Cloud on AWS) ![]() Very often I receive questions like this: “ SQL Server takes whatever memory is available, but what does it needs without compromising performance? What metrics to best look at that reflects what a SQL Server needs on a VM regarding memory?” Very valid question, however, not the one that could be answered straight away.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |