Solved

SMS 2003 Design Problem

Posted on 2007-03-30
4
267 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

If I have to fix slow responding website my first thoughts are server side optimizations: the database may not be optimized or caching is not enabled, or things like that. We often overlook another major part of our web application: the client. We o…
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
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.

707 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