<div>
Thanks very much Kevin3NF. <br />
<br />
But when it does the swapping and paging on constant basis, <br />
it would affect the application and causes to crash, wouldln't it?
</div>


Thanks very much Kevin3NF.

But when it does the swapping and paging on constant basis,
it would affect the application and causes to crash, wouldln't it?

<div>
Only if it did it to the degree that the application started timing out. &nbsp;SQL Server in itself cannot crash another application.
</div>


Only if it did it to the degree that the application started timing out.  SQL Server in itself cannot crash another application.

<div>
<div class="content wysiwyg-content">
if anybody out there is a DBA, please give me some inputs on my question:<br />
<br />
does the SQL server page virtual memory? <br />
if it does, it is normal to some extend, but wouldn't it kill the performance if <br />
too much paging? <br />
<br />
when the memory maxed out, what other options if no more memory can be<br />
added to the server? buy another server?
</div>
</div>


if anybody out there is a DBA, please give me some inputs on my question:

does the SQL server page virtual memory? 
if it does, it is normal to some extend, but wouldn't it kill the performance if 
too much paging? 

when the memory maxed out, what other options if no more memory can be
added to the server? buy another server?

database performance and memory

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.