Survey on high CPU usage of SQL Server

I CPUReasons or possible reasons for high usageCPUHigh usage refers to the high number of queries on the physical hard disk; high memory usage refers to the physical disk-Virtual Memory-Multiple data exchanges between three memory types

1. Anti-virus software may cause faults or viruses or Trojans, especially the rapid replication of worms inside the system or inside the network, resulting in a high CPU resource usage rate;
2. The driver has not been certified or some software is not compatible with the system, resulting in 100% CPU resource usage;
3. Server hardware problems: disks, memory/virtual memory, etc;
4. Network problems: the network bandwidth is heavily occupied, resulting in less available bandwidth, thus affecting the speed;
5. Database Design Problems: triggers cause deadlocks, many and frequent jobs, large use of intermediate tables, large use of cursors, irrational index design, and frequent transaction operations;
6. Improper SQL statement design leads to low query efficiency and affects server performance;

 

IICPUHigh occupation rate SolutionFor the above reasons and possible reasons, the following solutions are available:

1. The anti-virus software is upgraded to fully and strictly antivirus the server system and the local area network;
2. Verify and organize the software installed on the server, do not install drivers without authentication, install necessary software with strong compatibility as much as possible, and remove unnecessary software; monitors the system and port of the server, regularly cleans up System junk files, and closes unused and high-risk ports;
3. Regularly and periodically checks server hardware problems, sorts out system disks, and maximizes server performance. formulates the computer usage specification, which specifies the scope of use and prohibitions, regularly checks the computer usage of each department according to the specifications, regularly checks, maintains and adjusts the network structure and switches, and upgrades hardware;
4. Use the performance analysis and tracing tool provided by SQL ServerSQL profilerAnalyze the source of problems arising from the database design and handle them accordingly;
5. Use the query performance analysis tool provided by SQL ServerSQL query
   AnalyzerOptimize Query statements that may affect performance and are frequently used;
6. Or upgrade SQL Server; reinstall SQL Server or server operating system; use auxiliary software such as CPU cooling software;

 

3.SQL ServerLink to the question

L
Sqlservr.exe CPU usage reaches 100%

Http://zhidao.baidu.com/question/3526937.html

Http://zhidao.baidu.com/question/5987577.html

L
Sqlservr.exeProcesses occupy a large amount of CPU,How can this problem be solved?

Http://topic.csdn.net/t/20050921/16/4284920.html

Http://topic.csdn.net/t/20050315/21/3853745.html

Http://topic.csdn.net/t/20030810/12/2129471.html

L
Sqlservr.exe
95% CPU time

Http://sql-server-performance.com/Community/forums/p/14093/81413.aspx

Http://support.ipswitch.com/kb/WP-20050405-DM01.htm

Http://forums.ni.com/ni/board/message? Board. ID = 190 & thread. ID = 3160

Http://support.microsoft.com/kb/909636/en-us

L
Five Ways to Improve SQL Performance

Http://www.itpub.net/thread-884761-1-1.html

L
Database optimization and SQL statement Optimization Principles

Http:// I .yoho.cn/451002/logview/1294763.html

L
Optimize SQL Server database query methods

Http://blog.163.com/qiyue_007/blog/static/72382245200912321634475/

L
How to Improve the Performance of SQL Server 2000

Http://tech.ddvip.com/2007-07/118586708730524.html

L
SQL Server 2005AndSQL Server 2000Performance Improvement

Http://topic.csdn.net/u/20071218/13/f55916c6-81d0-4102-aef5-d8f1be5fc134.html

L
SQL Server 2005 v. S. SQL Server 2000 Performance advantages

Http://blog.dic123.com/article.asp? Id = 44

L
New Features and enhancements in SQL Server 2005

Http://hi.baidu.com/ptznet/blog/item/1c4e1ef5e9ded922bc3109ea.html

L
SQL
Server 2005 new features

Http://blog.163.com/dsp_zerg@126/blog/static/5340222920091253332559/