• Use Activity monitor to see what is going on when you see CPU jumped to 96%.

    Also I would recommend using Adam Machanic sp_whoisactive, to see what is going on.

    You can download code from here.

    http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx