<div>
and how can i configure the size of that files and create them? over the console of the sql database or is there a nice powershell command?
</div>


and how can i configure the size of that files and create them? over the console of the sql database or is there a nice powershell command?

<div>
ok cool, thank you very much.<br />
<br />
one last question. Does the SQL server automatically recognize the count of files and use them?
</div>


ok cool, thank you very much.

one last question. Does the SQL server automatically recognize the count of files and use them?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
is there a recommandation to configure the SQL tempDB for SCCM?<br />
I know that i can configure one per core, but i dont understand how to size them.<br />
<br />
And hows the correct way to configure the size?
</div>
</div>


Hi,

is there a recommandation to configure the SQL tempDB for SCCM?
I know that i can configure one per core, but i dont understand how to size them.

And hows the correct way to configure the size?

SCCM recommendation for SQL tempDB

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.

SCCM

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.