<div>
Hi,<br />
<br />
how many Memory and CPU power you Need is dependent on the work the six instances have to do. You can look how many RAM and % CPU your sqlservr.exe currently need. I would recommend to use a SSD, this brings in most cases more Speed than CPU power.<br />
<br />
You can configure the max an min Memory usage of each instance with the SQL Server Management Studio. Just connect to the instance, right click on the instance (for example (local)\instance1) and select properties.
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
I'v got a SQL Server 2008 with 6 instances.<br />
How to know how many memory and Cpus to install in the server ? <br />
How to configure the max and min memory in SQL Server? ( values)<br />
Which parameter are important too ? (tuning SQL) <br />
<br />
Thanks
</div>
</div>


Hello
I'v got a SQL Server 2008 with 6 instances.
How to know how many memory and Cpus to install in the server ? 
How to configure the max and min memory in SQL Server? ( values)
Which parameter are important too ? (tuning SQL) 

Thanks

Hi,

how many Memory and CPU power you Need is dependent on the work the six instances have to do. You can look how many RAM and % CPU your sqlservr.exe currently need. I would recommend to use a SSD, this brings in most cases more Speed than CPU power.

You can configure the max an min Memory usage of each instance with the SQL Server Management Studio. Just connect to the instance, right click on the instance (for example (local)\instance1) and select properties.

[SQL SERVER]

Hello
I&#39;v got a SQL Server 2008 with 6 instances.
How to know how many memory and Cpus to install in the server ? 
How to configure the max and min memory in SQL Server? ( values)
Which parameter are important too ? (tuning SQL) 

Thanks

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.