Server is not patched against Spectre/Meltdown vulnerability

Determine if SQL Server has been patched against Meltdown/Spectre

This only checks the SQL Server patch status, not the operating system or hardware

This works for SQL Server 2008 through SQL Server 2017

You can use a Microsoft-provided PowerShell script to check your

operating system and hardware patch status as decribed in this Microsoft KB

Windows Client Guidance for IT Pros to protect against speculative execution side-channel vulnerabilities

https://support.microsoft.com/en-us/help/4073119/protect-against-speculative-execution-side-channel-vulnerabilities-in

For more info:

https://www.sqlskills.com/blogs/glenn/checking-your-sql-server-instance-for-spectremeltdown-patches/

https://www.sqlskills.com/blogs/glenn/checking-your-meltdown-and-spectre-mitigation-status-in-windows/