Physical SQL Server Hardware Configuration Planning Questionnaire

Leave a comment (2) Go to comments

A DBA, need to consider the following point in mind, prior to fix Server Hardware Configuration.

1. Is this database designed for Online Transaction Processing (OLTP) or for a decision support system (DSS)?

  1. OLTP
  2. DSS
  3. OLTP and DSS both

2. Select a server platform for your database

  • a. Dell Power edge
  • b. Compaq
  • c. Open for anything

3. Do you already have the SAN?

  • a. Yes
  • b. No

4. Do you wanted to host SQL Server databases should be hosted on SAN?

  • a. YES
  • b. No

5. Storage platform for your database

  • a. Direct attached SAS
  • b. Fibre Channel
  • c. No preference

6. What is the maximum expected size of the database (include growth for next 3/5 years as opted above)

7. What sort of Queries types you are going to run on system :

  • a. Simple _____%;
  • b. Medium ______%;
  • c. Large&Complex ______%
IMPORTANT - These are high impact parameters. Please read the following definitions carefully before answering the question. In reality, not too many queries belong to ‘Large&Comlex’.

Simple
========
Indexed query; Typically retrieves 50K data; Response time goal is less than 0.1 minute.

Medium
========
Make some use of indexes; table scans and/or multi-way joins; some ORDER BY.
Typical query touches 0.1% of the data. (Please check this with Question 8.)
Response time goal is about 5 minutes.

Large & Complex
========
Full table scans; multi-way joins; a lot of ORDER BY.
Each query touches significant amount (20%) of data. (Please check this with Question 8.)
Very I/O intensive. ; Response time goal is about 120 minutes.

8. Do you save image files and sound files and large text files of the raw data in SQL Database?


_____% to total data.

9. What is the maximum number of concurrent application/user connections to the database?

10. During a typical user SESSION, on average how many requests will the user make to the application?

11. What percent of the users will initiate a session during the peak hour?

12. What are the peak hours of the application?

13. What is the maximum database transaction rate peak load (per second)?

14. What is the average row length of your DSS tables / reports?

15. On an average how many records are fetched by a DSS query / report?

16. What is the average number of queries per hour submitted to the system

17. What is the average response expected from the application report (in seconds)?

18. What response is expected from business transactions, it should in nanoseconds, mili seconds or seconds and define timeline.

19. What is the Average row length in Bytes Or, specify in more detail such as 150 bytes (60%), 10,000 bytes (10%), 50 bytes (30%)

20. Will you be virtualizing your Database environment?

  • a. Yes, With Microsoft Hyper-V
  • b. Yes, with VMWARE ESX
  • c. No, not at this time

21. Are Any of the following additional feature required ?

  • a. High availability Clustering
  • b. Tape backup solution
  • c. SQL Server advance features
  • d. Other : specify

22. Is this is a database upgrade to SQL Server 2008, which database you are upgrading from?

  • a. SQL Server 7.0 / 2000
  • b. SQL Server 2005
  • c. Oracle

23. You use some front end application instead of plain SQLs.

24. Do ETL during normal operation hours.

25. Do you want to perform database administration during normal operation hours?

26. What is the space required for the “Tempdb” database

27. What is the target processor utilization percentage for the database server in %? Default is 20-30% to allow for growth over the life of the hardware. For ERP applications, 60% is considered “full”.

28. Is High Availability required for database server? What requirements do you have for database server clustering, for example, high availability, scalability, etc.?

29. What is the maximum data loss business can afford in case of failure (in minutes)

30. What sort of scheduled maintenances windows are acceptable to business? (hours in week)

31. What recovery time business can afford, in case there is a failure? (in minutes)

32. Do you want to database services on a shared environment?

33. Any additional memory required for other application / services on the server, if on the shared server?

34. Primary objective during server sizing, Optimized for Functionality, Price/Performance or Performance?

35. Select a server platform for your database

  • a. Dell Power edge
  • b. Compaq
  • c. Other (please specify) :

36. Which processor type do you prefer?

  • a. Intel Xeon
  • b. AMD Opteron
  • c. Other (please specify) :

37. How many users will be connected from a different location? Please answer location (distance) and number of users.

38. How users/application is connected to database server? specify Internet connections between sites in more details.

39. How often do you change the database schema?

40. Do you anticipate adding additional business locations

41. Have you done any stress testing to check application load testing?, please provide details / results.

42. Please mention any relevant information related to database server, from the application prospective

Tags :sql server capacity planning,how to plan for new database server hardware, factors deciding new server hardware,Questions for Capacity Planning,New server hardware: RAM and Processors, New server conumdrum, New Server Hardware Recommendations,Determining SQL Server Hardware Requirements, Determining Database Server Hardware Requirements

EOF - Physical SQL Server Hardware Configuration Planning Questionnaire, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

2 Comments.

  1. Once we get all these data points, how do we plan it. Are there any document after this?

  2. Really useful checklist !!!
    Good work !!
    Keep going :)

    Regards,
    Datta

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.