asked on
question related to sql temp databases
we have a sql cluster active/passive. this cluster will host the following databases. two luns configured, one for database and one for logs. default instance of sql will be used. need to know how many temp databases need to be created considering the following databases
1. sccm site database
2. wsus database
3. sccm reporting
4. scom operational database
5. scom data warehouse
6. audit collection services
7. scom reporting
we have some 250 servers and 5000 clients. how should I calculate the space required for the following databases. scom and sccm reporting services will not be installed on the cluster. cluster will host only the databases
1. sccm site database
2. wsus database
3. sccm reporting
4. scom operational database
5. scom data warehouse
6. audit collection services
7. scom reporting
we have some 250 servers and 5000 clients. how should I calculate the space required for the following databases. scom and sccm reporting services will not be installed on the cluster. cluster will host only the databases
SSRSMicrosoft SQL ServerSCCM
Last Comment
Vitor Montalvão
ASKER
how can I create create multiple files for temp databases. when I installed sccm and scom for example the installation creates the databases. so should I create temp files later or should I create temp database files by creating the database manually
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Since there's only one tempdb database, I'm guessing you're wondering about how many tempdb data files to use(?). If you have more than 16 cores -- extremely likely nowadays -- start with 8. If 16 or less, start with 4. Be sure that all files are exactly the same size and have the same fixed growth amount (that is, never use % growth, only a fixed amount).