Link to home
Create AccountLog in
Avatar of Aamer-
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
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

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).
Avatar of Aamer-
Aamer-

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
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account