SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Select good hardware
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

paradisa
Starting Member

Canada
3 Posts

Posted - 08/20/2014 :  19:05:31  Show Profile  Reply with Quote
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....

Edited by - paradisa on 08/20/2014 19:20:16

ahmeds08
Aged Yak Warrior

India
645 Posts

Posted - 08/21/2014 :  04:06:28  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
http://download.red-gate.com/ebooks/SQL/sql-server-hardware-ebook.pdf

Javeed Ahmed
Go to Top of Page

paradisa
Starting Member

Canada
3 Posts

Posted - 08/21/2014 :  11:56:26  Show Profile  Reply with Quote
Thank you, I will take a look
Go to Top of Page

paradisa
Starting Member

Canada
3 Posts

Posted - 08/22/2014 :  12:46:35  Show Profile  Reply with Quote
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??

Edited by - paradisa on 08/22/2014 12:50:25
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2062 Posts

Posted - 08/23/2014 :  02:29:01  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000