Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SMS 2003 Design Problem

Posted on 2007-03-30
4
Medium Priority
?
270 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 1000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Know what services you can and cannot, should and should not combine on your server.
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.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

636 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