troubleshooting Question

question related to sql temp databases

Avatar of Aamer-
Aamer- asked on
SSRSMicrosoft SQL ServerSCCM
3 Comments1 Solution192 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros