SQL Server Performance

New hardware config.

Discussion in 'Performance Tuning for Hardware Configurations' started by Fistandantilus, Oct 23, 2003.

  1. Fistandantilus New Member

    Hi All,

    I'm new and pretty clueless here, hence the post. We are getting a new server for backup and sql2k stand. Db is currently in Access, hence the upgrade. Only 20-22 people total in company, so db(s) aren't that big and neither is overall backup.

    I'm looking for some advice in setting up the new box. Stats for new machine as follows:

    2 2.4GHz/512k 533Mhz Xeon's
    1 gig ram
    W2K3 Server
    Hardware RAID, 3 75 gig scuzi drives
    100/200 gb tape backup

    I plan on using our other server for majority of backup, but there will be some fall over onto this machine in the event that the other crashes.
  2. Luis Martin Moderator

    Working with SQL instead Access is a big difference.

    In you can give other information, about:
    More reads or writes?
    Database grow in a year, for example.
    Actual server configuration.
    New server, RAID 5 or 1 ?
    Any other information that you considerate usefull.







    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. Fistandantilus New Member

    Well, I honestly don't know about read/writes right now, since that's not my responsibility....yet. Getting feedback and doing the implementation of the hardware is what my primary focus is. The db is very small, but continues to crash everyday at least once. There are 3 db's in use at around 150 megs a piece, with about 12 people hitting them at once.

    I was considering RAID 5.
  4. Luis Martin Moderator

    Crash in Access is normal, I see this before.
    With SQL you have a really Database and I think will no crash anymore.
    Without information, I gess new server is Ok.
    Install SO and SQL with last Services Pack and run in paralel at least a month.

    I suggest to wait for anothers posts to get more about your concern.






    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  5. satya Moderator

    Take help of this KBAhttp://support.microsoft.com/support/kb/articles/Q237/9/80.ASP to convert the Access database to SQL Server and as a test run implement this on test environment to know the facts.

    In any case SQL Server is superior and have more advantages on MS Access, you will see the difference.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  6. Fistandantilus New Member

    I will def. look at that article.

    Thanks!
  7. satya Moderator

    And on general recommendation about backup/patches is to make sure you take a local backup and then use tape backup to copy/store the file.

    Make sure to patch the Win2K and SQL server with latest service packs and hotfixes.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  8. Fistandantilus New Member

    I'll look into that too. Shanks.[<img src='/community/emoticons/emotion-4.gif' alt=':p' />]

Share This Page