If a sql server session running for long time (active) state. can it cause a CPU spike. There is a process in our database that reads transactions from the transaction log using fn_dblog and transfer those changes to mysql database tables. Sometimes process runs for long time 2-3 hours and at that time CPU utilization hits very high. so may question is if a active process runs for a long time can it cause cpu spike as compared to one running for 5-10 mins. Another point to note that we are using resource governor so that any sessions from this particular user should not be using more than 20% cpu.