[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

SMS 2003 Design Problem

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
johnpun2005
Asked:
johnpun2005
1 Solution
 
BrucematCommented:
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
 
johnpun2005Author Commented:
That's fine.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now