We recently encountered a SQL server with very high processor utilization. This utilization would stay near 100 percent even at night and over weekends, when very little activity should be occurring.
The server hosted numerous SQL databases, including Sharepoint. We had some concerns that search or some other similar process was continually running, causing the issue. We ran index rebuilds on the busiest databases, and on the Sharepoint search index database.
After completing those rebuilds, I noticed that the processor utilization on the server continued to be unusually high, especially considering that there should be very little activity on the server. I then did some investigation into the high CPU utilization and found the culprit. My process for doing that is outlined below:
Eyefinity is a fairly new technology developed by ATI, now owned by AMD. This technology allows you to run multiple monitors as one large resolution or several monitors running independent resolutions. It is viable for consumer and business use but is used to meet very specific needs due to its price.
For business use, this is a great solution for CAD users that need lots of desktop space to span large drawings across multiple screens. Instead of running a 1920x1080 solution, you can run 3840x1080 for two monitors or 5760x1080 for three monitors. The most common configuration is three monitors wide, but you can configure them high as well. This technology is also very flexible because you can run a five-monitor-wide solution with the monitors in a vertical position, giving you more height to work with.
