Configure the server to tune performance (i)--Introduction

Source: Internet
Author: User
Tags what sql

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.