I am dealing with 32bit Windows 2003 server which was once a physical box, but now is virtualized in vmware. There are two SQL Server instances running. One is 2000 Standard, another is 2008 R2 ...
From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
I have Microsoft SQL Server Standard Edition (64-bit) running on Windows Server 2008 R2 Standard (64-bit) with 32GB RAM. It's only database server that runs on this machine. Generally it works fine ...
I started analyzing our SQL Server PerfMon logs in Excel, and discovered this. Legend: Red - SQL Server - Target Server Memory Green - SQL Server - Total Server Memory Blue - Available System Memory ...