Check for high CPU usage in SQLSERVER

SQL Server checks CPU usage. At noon today, a friend asked me to help him check the database. The operating system is Windows2008R2, the database is SQL2008R264-bit 64 GB memory, and the 16-core CPU hardware configuration is still relatively high, he said that the server is running Kingdee K3 software, and there are multiple databases in the database instance. He said it only appeared in the past few days.

SQL Server checks CPU usage. At noon today, a friend asked me to help him check the database. The operating system is Windows2008R2, the database is SQL2008R2 64-bit 64 GB memory, and the 16-core CPU hardware configuration is still relatively high, he said that the server is running Kingdee K3 software, and there are multiple databases in the database instance. He said it only appeared in the past few days.

Check for high CPU usage in SQLSERVER

At noon today, a friend asked me to help him check the database. The operating system is Windows2008R2 and the database is SQL2008R2 64-bit.

64 GB memory, 16-core CPU

The hardware configuration is still relatively high. He said that the server is running Kingdee K3 software, and there are multiple databases in the database instance.

He said it only appeared in the past few days, and there will be high CPU usage in a certain period of time every day.

Memory usage is also high. Hong Kong Space occupies 30 GB.

----------------------------------------------- Gorgeous split line -------------------------------------------------------

Generally, the following script is used for troubleshooting. The website space generally uses three views: sys. sysprocesses, dm_exec_sessions, and dm_exec_requests.

1 USE mastersys. (., Hong Kong VM