SQL Server Performance Optimization (i)--Introduction

Original: SQL Server performance Optimization (i)--Introduction

First, the reasons for performance optimization:

It sounds a bit superfluous, but let's say it in detail:

1, cost savings: Here the cost is not necessarily money, but basically can be disguised as saving money. Performance up, the hardware that would have to be invested can slow down the investment, from another point of view it is to save money.

2, increase efficiency: for customers, performance up, their efficiency is also high.

3, reduce frustration: performance under, customer complaints, is undoubtedly the impact on their own hearts.

Second, the performance error:

Performance Myths

Misunderstanding	Reality
If processor usage is high, you need to add a faster processor	A certain part of the problem is causing the performance
80% performance issues are determined by the application code	Good code helps improve performance, but good design is the most important.
Well-configured servers are key to database performance issues	You also need to consider network problems

Third, performance and troubleshooting tools:

1. Activity Monitor (active and monitor): ssms→ Right-click instance →

2. Task Manager: Ctrl+shift+esc

3. System Monitor: MMC

4. SQL Server Profiler:

5. Database Engine Tuning Advisor (DB Engines Tuning Advisor):

6. DBCC command

7. Events logs and error logs (event log and fault log):

SQL Server Performance Optimization (i)--Introduction