+ Post New Thread
Results 1 to 4 of 4
Hardware Thread, would sims.net work better with a seperate sql server? in Technical; We are in the process of moving from msde to a full blown sql 2000 server to support sims.net. Our ...
  1. #1
    projector1's Avatar
    Join Date
    Nov 2005
    Posts
    461
    Thank Post
    70
    Thanked 1 Time in 1 Post
    Rep Power
    19

    would sims.net work better with a seperate sql server?

    We are in the process of moving from msde to a full blown sql 2000 server to support sims.net. Our network infastructure is very well designed. (1gig fibres from hp 4108 switch)
    I thought if we have sql running on a seperate server it takes some load from the A/D server that is running sims.net.
    However i was told that it would not make a difference. All we need to do is to install it on a seperate hard drive on the A/D server. Server is a 2.4 zeon machine with 2xscsi 30g hdd.
    If you have a mis system, whats your setup?
    Also how would you folks go about it?
    We have a box with sql server 2000 already that is doing nothing at the moment. However i have thought about using this with our circ server to support WSUS and sophos, veritas

    many thanks

  2. #2


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,701
    Thank Post
    279
    Thanked 787 Times in 614 Posts
    Rep Power
    226

    Re: would sims.net work better with a seperate sql server?

    we have a dedicated SIMS server handling SQL, Apps and Documents. It's a dual xeon box with 2GB of ram and 4x 36GB disks (currently in RAID5, looking to change to RAID10 at the same time we migrate from MSDE to full sql server.

    Apart from performance, our decision to use separate hardware allows us to bounce the sims box without affecting any other services.

  3. #3

    Join Date
    Oct 2005
    Location
    Lancashire
    Posts
    110
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: would sims.net work better with a seperate sql server?

    Quote Originally Posted by pete
    we have a dedicated SIMS server handling SQL, Apps and Documents. It's a dual xeon box with 2GB of ram and 4x 36GB disks (currently in RAID5, looking to change to RAID10 at the same time we migrate from MSDE to full sql server.
    Very nice, but does SIMS work any faster?

  4. #4


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,701
    Thank Post
    279
    Thanked 787 Times in 614 Posts
    Rep Power
    226

    Re: would sims.net work better with a seperate sql server?

    Quote Originally Posted by mighty.grey.eagle
    Very nice, but does SIMS work any faster?
    Than before? Definitely, but it isn't a fair test as this was all done on new hardware. Would it work faster if we had a separate SQL server? No, since it's already a dedicated box.

    So long as your server can keep most (preferably all) of the SQL database in RAM and the server's not being thrashed, you don't need separate hardware due to performance. You might consider dedicated hardware for convenience / keeping things simple, as we did.

    I was responding to "If you have a mis system, whats your setup?" :P



SHARE:
+ Post New Thread

Similar Threads

  1. Seperate server for Media Studies files
    By tosca925 in forum General Chat
    Replies: 1
    Last Post: 17th July 2007, 07:55 PM
  2. Servers: Consolidate, Seperate or virtualize?
    By thom in forum How do you do....it?
    Replies: 5
    Last Post: 1st February 2007, 03:49 PM
  3. Replies: 5
    Last Post: 10th November 2006, 09:46 AM
  4. How do you seperate your networks. Subnet / Vlan
    By drjturner in forum Wireless Networks
    Replies: 16
    Last Post: 28th September 2006, 08:24 AM
  5. Admin and Curriculum networks seperate?
    By woody in forum Wireless Networks
    Replies: 49
    Last Post: 2nd December 2005, 11:43 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •