We help IT Professionals succeed at work.
Get Started

question related to sql temp databases

Aamer- asked
Last Modified: 2016-03-01
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
Watch Question
IT Engineer
Distinguished Expert 2017
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE