SQL Server 100% CPU usage?

Question

SQL Server

Hello!
There was a problem with SQL Server 2008 R2 Enterprise. After a large data change in the table (several million rows added), SQL Server began to perform internal maintenance tasks and heavily load the processor. At the same time, of course, it became an order of magnitude slower to process requests. The number of external requests is in the order of the norm (I think they can be neglected).
Questions:
1. How to understand what tasks it performs? Rebuilding indexes, updating statistics…
2. How can I disable (postpone) these tasks?

Answer 1

Another option is to use "SQL Server Profiler" - you can track what resources each query and even command in a stored procedure uses

Answer 2

Check logging. We had similar problems at work due to logging.