Is there a way to find out what queries or other might be causing a spike in Compilations per Second performance metric for MS SQL Server? You can see in the screen grab of my monitoring that spike started at 5am pacific time. Normally this hovers around 20/sec but since the weekend it's been trending up and even more pronounced today. I can't get anyone in our team to fess up. I need a way see what activity might be triggering this? Any tips from SQL experts?