Every single query is using some CPU. Depending on what the queries are doing, sorts, etc., more CPU is necessary to figure things out. Parallelism causes CPU because a given query uses more. Data compression. Encryption. Bad or missing indexes. Missing or out of date statistics. Bad code. All this contributes to CPU use. It's not just about compiles & recompiles.