How to find SQL License type

Question: I’m looking for a method to check the license type in Microsoft SQL 2012. Can you show me how to find the SQL Server license type via SQL Server? Answer: Since SQL Server 2012 , you can find this information in the SQL Server Error Logs. Before SQL Server 2008 R2 there used to be some properties maintained but is now unused Mode of this instance of SQL Server. PER_SEAT = Per Seat mode PER_PROCESSOR = Per-processor mode DISABLED = Licensing is disabled. In SQL Server 2012 , a check on the SQL Server error logs will report on... Read more →

SQL Schedulers disabled

When SQL Server uses a portion of the server processors , the is_online column on the sys.dm_os_schedulers will return 0. Basically , the scheduler will not be used for query processing. The situation is caused by either affinity masking or licensing restrictions Be careful if you attempt to change these number – either be confident you know how to use affinity masking or if Virtualization is used , speak to the VM administrator about apportioning more cores per virtual socket. In either case analyse the impact and test thoroughly Read more on Amount of sql server processors with sys.dm_os_schedulers --how... Read more →

Amount of sql server processors with sys.dm_os_schedulers

I needed to establish the amount of processors available to a SQL Server. A SQL Server scheduler is mapped to a single logical processor, so using this query you can establish the amount of processors. Any scheduler_id < 255 is a scheduler. It gets lightly more complicated if hyperthreading is enabled. . Find out from the server administrator , use a product such as the coreinfo or this Powershell script - Number of physical processors with Powershell – number of cores to establish if hyperthreading is turned on. If hyperthreading is enabled – this equates to double the schedulers. SELECT... Read more →

Number of physical processors with Powershell – number of cores

I want to view the Physical Porcessor information on the server . How can I view : a) The name and amount of processors b)The DeviceID c)Number of cores d)Number of Logical Processors Use Powershell and Windows Management Instrumentation (WMI) . The Get-WMiObject cmdlet is great for system administration Get-WmiObject –class Win32_processor | ft Name,DeviceID,NumberOfCores,NumberOfLogicalProcessors Read More SQL Server – More processor speed or cpu cores CPU Count Read more →

CPU 100% - Check for Parallel Queries

If CPU is 100% for extended periods and there are performance issues– check for Parallel queries. This quick and dirty check does not replace an indepth root cause analysis , but it does give you some quick feedback . Use the feedback to take action and then focus on fixing the bottleneck The CXPACKET wait type occurs when more than one CPU core exists. Queries will run in parallel and the waits will occur when one part of the query is waiting for another thread to complete it’s workload. Read more on SQL Server - Waitstats CXPACKET wait type and... Read more →