Avatar of Aamer-
 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
SSRSMicrosoft SQL ServerSCCM

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Scott Pletcher

default instance of sql will be used.
Not a good idea, even if possible.  You should use a named instance so that you can more easily add other instances later and/or remove the initial instance.

need to know how many temp databases need to be created considering the following databases
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).

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
Vitor Montalvão

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.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy