New hardware config. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

New hardware config.

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.
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
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.
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
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

I will def. look at that article. Thanks!
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

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