Most RecentMost ViewedMost LikesCalculating CPU percentage for active queries This article helps you to identify and calculate CPU percentage for active queries. Lesson Learned #45: CPU at 100% using nvarchar parameter data type in the filter against varchar column data type.First published on MSDN on May 07, 2018 These last days, I have been working in several service requests with same behavior.