<div>
Oh and you dont need to assign a db file to a cpu. The whole point is that if you have 2 x Quad core CPU's then thats 8 threads. Wach thread can access 1 file, so in theory 8 threads = 8 files in a group = the setup shown above.<br />

</div>


Oh and you dont need to assign a db file to a cpu. The whole point is that if you have 2 x Quad core CPU's then thats 8 threads. Wach thread can access 1 file, so in theory 8 threads = 8 files in a group = the setup shown above.


<div>
Great, Greate Answer Neilsr thank very Much with this I have my problem solved.<br />
<br />
Thanks Expert.
</div>


Great, Greate Answer Neilsr thank very Much with this I have my problem solved.

Thanks Expert.

<div>
Thanks very Much Neilsr.<br />
<br />
This answer help me &nbsp;for to night on my change. Thanks
</div>


Thanks very Much Neilsr.

This answer help me  for to night on my change. Thanks

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
What is the way to create a TEMPDB database for each CPU on the Server? and then how assign every database to each CPU?<br />
<br />
thanks.
</div>
</div>


Hi Experts
What is the way to create a TEMPDB database for each CPU on the Server? and then how assign every database to each CPU?

thanks.

Create a TEMPDB Database to each CPU on Server

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.