Solved

SMS 2003 Design Problem

Posted on 2007-03-30
4
266 Views
Last Modified: 2010-04-20
We are currently using SMS 2003. The artichitecture is Central server (SMS + SQL in 1 server) -> Primary Server (SMS + SQL in 1 server)-> many Secondary Sites for Proxy MP and DP -> SMS Client

We are consider the resilient of Primary Server, what is the advantage and disadvantage of seperating the SQL to another server? Will it degrade the performance? If so, Why? If seperation is better, can I implement SQL 2005 STD with failover Cluster for SMS 2003
0
Comment
Question by:johnpun2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 3

Accepted Solution

by:
Brucemat earned 250 total points
ID: 18837309
Your sql holds all the data that your SMS needs it really depends on the size of the number of hosts you are suporting with this. you need to look and see how much db io your sql server is getting if your auditing oftern and pushing jobs out oftern you will need a high bandwidth link between your sms and the sql. I have a simalar system (3000hosts) and I have our server talking to the sql cluster over 1gigabit ethernet and all is ok. I would recomend using a separate server for your sql if both services are handeling alot of requests (more than 600 hosts) and a cluster would be a good idea for your db fault tolerance. also if you decide to put another sms box in in the future you can just point it to your cluster withought worying to much about the load.
0
 

Author Comment

by:johnpun2005
ID: 19855754
That's fine.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
This video teaches users how to migrate an existing Wordpress website to a new domain.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question