Defending some performance issues on a Windows based SQL Server 2008 R2 I took a look on CPU monitoring too. All green. Since months. That's good - I thought. Nagios as well as commercial tools like solarwinds comes up with average CPU usage, which means average acrosss single cores. In my case:
- 6 virtual Cores available
- 4 used by SQL Server at 90-100%
- 2 used by Windows at 2-5%
Makes an average around 60-70%. Fail. Now I'm looking for monitoring solutions per core. Any suggestions?
