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.
| 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.pdfJaveed Ahmed |
 |
|
|
paradisa
Starting Member
3 Posts |
Posted - 2014-08-21 : 11:56:26
|
| Thank you, I will take a look |
|
|
|
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?? |
|
|
|
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.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
Select good hardware