Maximize Data Throughput for Network Applications
To optimize system memory use for SQL Server, you should limit the amount of memory that is used by the system for file caching. To limit the file system cache, make sure that Maximize data throughput for file sharing is not selected. You can specify the smallest file system cache by selecting Minimize memory used or Balance.
To check the current setting on your operating system
1.Click Start, then click Control Panel, double-click Network Connections, and then double-click Local Area Connection.
2.On the General tab, click Properties, select File and Printer Sharing Microsoft Networks, and then click Properties.
3.If Maximize data throughput for network applications is selected, choose any other option, click OK, and then close the rest of the dialog boxes.
And Also enable AWE on 32-bit operating systems. No need to configure on 64-bit operating systems.
Since AWE-mapped memory is supported below 3 GB, you can define the min server memory and max server memory values within the physical memory range, or use the default values for both options.
How to enable AWE
ไม่มีความคิดเห็น:
แสดงความคิดเห็น