SQL Server Performance Forum – Threads Archive

case studies about hardware

I am looking for case studies describing deploying MS SQL Server 2000 in different environments, on different machines. I have been assigned a task of finding a new server for one of our customers and I am looking for information about what kind of hardware is needed for SQL Server to run smoothly (of course, I know it depends on the way it is used). — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

You might search the website of the big vendors like IBM, Dell, HP, EMC… I know, at least, IBM, HP and EMC have such case studies there, vut I only downloaded them and do ot have the URL’s right now. Another starting point would be to look at the homepage of SQL Server at Microsoft. They have also a case study section.
–Frank
http://www.insidesql.de

---

I’ve checked IBM, Dell and MS. The problem is that I need really detailed information — number of users, application characteristics, hardware used, etc. — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

Try to find:
1) Application is more input than output.
2) " is I/O balanced?
3) More CPU than I/O?
4) How database will grow in time?
5) Are you planning backup transactions log frequently?
6) The application is well tuning or you have to improve performance after?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

If you can offer some more specifics about the use, then perhaps those DBAs who have similar systems can offer to describe what hardare they have to run a similar system. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

I have very detailed information about the application. However, I need some examples like ‘when there are X1 users, X2 reads per sec, X3 writes per sec and the database is X4 GB, then you probably need a machine with Y1 CPUs, Y2 GB of RAM and X3 disks’. — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

There are 7 databases:
8GB — 100+ users
20GB — 30 users
5x 3GB — 5 users each Each database is used by the same application — it is an OLTP application with some reporting capabilities. — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

What you describe is smaller than all of the SQL Servers I manage. Our system, closest to yours, is a 4CPU XEON, with 8GB RAM, and RAID 5 SAN for storage. On our particular system, we have no hardware bottlenecks. If you purchase a system as big, or bigger than ours, then you will probably see no performance issues. In fact, I imagine that a smaller system will also so as well, such as a 4 CPU Xeon, 4GB RAM, and RAID 5 on the local server. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

Thanks for your answer — that it exactly the kind of information I need. Of course, I realize that nobody is able to give me precise answer based only on my short desription. But, since it is the first system that I am designing, I need some starting point. Could you tell me something more about the disk subsystem?
How do you have OS, paging file, transaction logs, data logs and tempdb placed? — Marek ‘chopeen’ Grzenkowicz, MCP
Poland

---

Refer to these articles from this website for information:
http://www.sql-server-performance.com/sql_server_configuration_settings.asp
http://www.sql-server-performance.com/sql_2000.asp
http://www.sql-server-performance.com/database_settings.asp
http://www.sql-server-performance.com/sql_server_setup.asp
http://www.sql-server-performance.com/tempdb.asp
http://www.sql-server-performance.com/operating_system_tuning_w2k.asp http://www.sql-server-performance.com/glossary.asp – glossary. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>