Original: Configure the server to adjust performance (i)--Introduction
First of all:
It is important to understand that during the lifecycle of a system, servers and programs must be constantly tuned to meet the impact of system changes.
Secondly:
For best performance, start with the configuration server, then design an efficient architecture and specify optimized SQL, and finally improve the configuration by monitoring and analyzing performance loops. Process such as:
What developers need to know about performance: for a database, the foundation is "architecture"
1 |
User |
Need to know how many users, how many concurrent users, user rights, etc. |
2 |
SQL statements |
What SQL statements each user needs to execute |
3 |
Data |
To understand the data in the database and monitor the development of the data |
4 |
Robust architecture |
When designing a logical data model, you do not need to consider performance issues, only when you design a physical model, you need to consider performance |
Production DBAs need to know about performance-related knowledge: Let the system run as efficiently as possible on limited hardware. Use: Task Manager, System Performance Monitor, SQL Profiler, SSMs to complete the task.
Optimize server: Three resources must be considered: CPU, memory and IO. CPU: Except for quantity and type, the only option to consider configuration is whether you need to start
Hyper-Threading
Memory: The knowledge of memory is very complex, not detailed here.
IO: Example: 2GHz CPU speed results in a throughput of: 8gb/s. The 500MHz memory speed results in a throughput of: 2gb/s. The hard drive speed is 5~200mb/s. Configure server hardware: 1, Windows Server System Reference Architecture. 2. Windows Server directory.
Configure the server to tune performance (i)--Introduction