This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing one SQL Script to find the information about CPU or processor, which is used by the SQL Server.
We have deployed different SQL Servers and instances at the client’s data center.
Now our team is required to find and generate a small report about the CPU information of all the running SQL Server.
Using xp_instance_regread, we can find the CPU information from the registry.
1 2 3 4 |
EXEC xp_instance_regread 'HKEY_LOCAL_MACHINE', 'HARDWARE\DESCRIPTION\System\CentralProcessor\0', 'ProcessorNameString'; |
Leave a Reply