1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

SQL Server Performance Question

Discussion in 'Windows Server System' started by Steve R Jones, 2015/03/11.

  1. 2015/03/11
    Steve R Jones

    Steve R Jones SuperGeek Staff Thread Starter

    Joined:
    2001/12/30
    Messages:
    11,848
    Likes Received:
    174
    Trophy Points:
    843
    Location:
    Dallas, TX
    Computer Experience:
    Experienced
    I’m looking for a "Best Guess" from DB Admin kind of guys.

    My company develops "“ sales and supports a high end accounting software package.

    We lease two servers from a data center to host the DB’s for some of our clients. The servers are single Xeon quad core, 4 gigs of ram and have 15k rpm SAS drives.

    The servers are currently running Windows Server 2003 and SQL Server 2000.

    Since Win 2003 is ending it's lifecycle this summer we're going to be upgrading the machines to Win Server 2012 and SQL Server 2008.

    Ideally, we'd like to put all the databases on one machine but we're concerned about the overall impact on performance of the software since it is a bit of a pig on resources.

    Currently each machine has 20 users each hitting it. Our accounting software is installed on the local clients machine which intern access databases on the servers.

    The new machines will have at least 8 gigs of ram if not 16. And I'm uncertain if we'll continue with the faster SAS drives.

    The databases are generally considered small in that they don't exceed 1.5 gigs in size.... And we use Crystal Reports Viewer to run reports.

    Any and all feedback would be welcomed.
     

Share This Page