Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Select good hardware

Author  Topic 

paradisa
Starting Member

3 Posts

Posted - 2014-08-20 : 19:05:31
I have a large database size, few tera bytes, and customer is asking me what kind of server, in terms of hardware specification he should buy...
This question is not so easy to answer... Of course I can evaluate the size of each tables, fine tune indexes, and evaluate the kind of query he will do, but since the big bottle neck is the io with the disk, how can I suggest specs to look for to my customer? I cannot just simply tell him to buy "best machine" he can find..:-):-)

I think the best thing is to evaluate the load of each request in terms of bytes written/read to the disk,how can I evaluate that for some query?
I'm using Mssql by te way,

Thank you so much for your input....

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-21 : 04:06:28
http://download.red-gate.com/ebooks/SQL/sql-server-hardware-ebook.pdf

Javeed Ahmed
Go to Top of Page

paradisa
Starting Member

3 Posts

Posted - 2014-08-21 : 11:56:26
Thank you, I will take a look
Go to Top of Page

paradisa
Starting Member

3 Posts

Posted - 2014-08-22 : 12:46:35
I have take a look and I still have questions...
I'm a software developer, so what I look for is to find metrics or some kind of values to look for to my customers when it's time to purchase hardware.

This book is really interesting when it's time to trouble shoot a pc, not really to find metrics based on my queries.

I can evaluate the count of SQL insert in tables, so I can find, based on the record length, the amount of data that can be written to the disk. But for SQL updates, can I evaluate the data size based on the field's size that need to be written??
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-23 : 02:29:01
Capacity planning is required to assess the current and future hardware requirements. carry out a load test , there are a number of methods. Read some more information here : http://www.sqlserver-dba.com/2011/07/capacity-planning.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -