The CPU usage goes to 100% on a Microsoft SQL Server that uses SSD storage to host one or more instances you are monitoring. This causes the server and its instances to have high signal waits.
There is a known issue regarding high CPU usage and the Microsoft SQL Server I/O handling mechanism that creates high I/O wait times.
As a workaround, disable I/O statistics in SolarWinds DPA for the instances hosted on that MSSQL Server. The easiest way is to disable the IO_STATS_POLL_ENABLED option. You can do this for individual instances or for all instances.
To disable I/O statistics for individual instances