<div>
Guy,<br />
<br />
Thanks for the article and the explanation, I can now set the swap file to static 4 GB on C: drive because the <b>Server properties &gt;&nbsp;Memory </b>tab I have set the minimum to be 8 GB and maximum 80% of maximum total physical RAM.<br />
<br />
Plus the <b>Boost SQL server priority</b> has been selected as well.<br />
<br />
Is that correct ?
</div>


Guy,

Thanks for the article and the explanation, I can now set the swap file to static 4 GB on C: drive because the Server properties > Memory tab I have set the minimum to be 8 GB and maximum 80% of maximum total physical RAM.

Plus the Boost SQL server priority has been selected as well.

Is that correct ?

<div>
nothing wrong as far as I know those settings.
</div>


nothing wrong as far as I know those settings.

<div>
<div class="content wysiwyg-content">
People,<br />
<br />
I'm using physical box SQL Server 2012 SP1 with the below specification:<br />
<br />
1 sockets x 4CPU cores<br />
32 GB RAM <br />
C:\ - 2x 72 GB HDD - RAID 1 - 68 GB usable (1 GB free)<br />
D:\ - 2x 146 GB HDD - RAID 1 - 138 GB usable (15 GB free)<br />
<br />
I'm about to upgrade the RAM using the spare available into 64 GB, but the swap file on the C: drive going to kill it ?<br />
<br />
Can I set the swap file to be maximum 4 GB only before I shutdown the server ?<br />
<br />
Thanks,
</div>
</div>


People,

I'm using physical box SQL Server 2012 SP1 with the below specification:

1 sockets x 4CPU cores
32 GB RAM 
C:\ - 2x 72 GB HDD - RAID 1 - 68 GB usable (1 GB free)
D:\ - 2x 146 GB HDD - RAID 1 - 138 GB usable (15 GB free)

I'm about to upgrade the RAM using the spare available into 64 GB, but the swap file on the C: drive going to kill it ?

Can I set the swap file to be maximum 4 GB only before I shutdown the server ?

Thanks,

Physical server SQL Server swap file size and memory allocation ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.