choosing hardware

Question

choosing hardware

cross

SSCommitted

Points: 1735
More actions
October 29, 2003 at 1:02 pm

#59549

Anyone know any good books/articles about selecting hardware and configurations for SQL Server? I've got to select some new boxes soon for a production environment.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Start with Microsoft's web site for SQL Server. There you can find system requirements for each version. That will give you minimum requirements.

-SQLBill

cross SSCommitted Points: 1735 More actions · Answer 2

Thanks 🙂 Do you have any sources for more complicated configurations (# of processors, RAID, RAM to optimize performance and expand as the database gets bigger)???

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 3

There is no exact rule.

Tell us how your production environment is (database size, number of concurrent users, number of transactions per minute, type of application (OLTP, OLAP), average size of the transactions/queries, required response time...)

and we will try to tell you what we think to be the best HW infrastructure to choose.

One thing is sure: If you choose a bigger HW then required no user will complain, but if you choose a smaller one...

Bye

Gabor

Bye
Gabor

Jonathan SSC-Insane Points: 20427 More actions · Answer 4

Hiring a consultant knowledgeable in SQL Server design can be a very good idea.

--Jonathan (HP Master ASE-SQL Server )

--Jonathan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
(HP Master ASE-SQL Server)

as for acronyms, what does this stand for?

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Jonathan SSC-Insane Points: 20427 More actions · Answer 6

quote:
quote:
(HP Master ASE-SQL Server)
as for acronyms, what does this stand for?
Frank
http://www.insidesql.de

http://www.hp.com/certification/region/na/mase/iss/sql_server.html

--Jonathan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

Thanks for explanation!

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 8

Jeremy Kemp

SSCertifiable

Points: 6754

October 30, 2003 at 7:52 am

#480307

ASE - Ask Someone Else.

Jeremy

simon_hyan Ten Centuries Points: 1177 More actions · Answer 9

simon_hyan

Ten Centuries

Points: 1177

October 30, 2003 at 7:57 am

#480308

select the best as you can.

cross SSCommitted Points: 1735 More actions · Answer 10

I have 2 highly transactional DBs, 1 reporting DB, and 2 not so big DBs. They are used by a web application that should have no less than 2% downtime.

Currently I have one server on RAID 5.

I was thinking of one server with RAID 5 for data, RAID 1 for transaction logs, and RAID 1 for OS files with 4 processors.

I am the only one in my organization who knows the little bit I do about SQL Server.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 11

http://www.sql-server-performance.com/ultimate_sql_server.asp

sbalusa SSC Veteran Points: 276 More actions · Answer 12

Check this out - especially Chapter:6

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

Jonathan SSC-Insane Points: 20427 More actions · Answer 13

quote:
I have 2 highly transactional DBs, 1 reporting DB, and 2 not so big DBs. They are used by a web application that should have no less than 2% downtime.
Currently I have one server on RAID 5.
I was thinking of one server with RAID 5 for data, RAID 1 for transaction logs, and RAID 1 for OS files with 4 processors.
I am the only one in my organization who knows the little bit I do about SQL Server.

If you can end up with two servers, put the DSS databases on one and the OLTP databases on the other. It's better to use RAID 10 for the data on the OLTP server. Depending on factors you have not given us, you may want to buy fewer processors and use the money for more disks or more RAM. Your plan to use separate RAID 1 arrays for executables and tran logs is good. Buy good fault-tolerant caching array controllers.

--Jonathan