We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a minute every 10 minutes (on the tens). Here's what it looks like:
From what I have seen so far, this is definitely the sqlserv.exe process going up to 50% (using up 1 of its 2 CPU cores). I have done a SQL profile, and not seen anything running during those times. This server is only used for mirroring the database, so my theory is that it's something related to that. Does anyone have any ideas, or other things I can do to investigate?