?
Solved

SMS 2003 Design Problem

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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
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…
Suggested Courses

801 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