The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers while working with the Comprehensive Database Performance Health Check. During the consultation, I had provided the script for SQL SERVER – Measure CPU Pressure – Detect CPU Pressure.
If you look at the script carefully, you will notice The client DBA asked me the purpose of the WHERE condition where I have only retrieved schedulers which are less than 255. (click here to read the original script)
You can run the following query without WHERE condition and you will see