goprasad
asked on
Is there any tool to determine/check number of cores in SQL server?
Hello there,
Due to recent changes by Microsoft the way the SQL server will be licensed in SQL 2012 version, which is core based rather than Processor based.
We have been advised to generate report using MAP tool from Microsoft, to determine number of cores. We have number of Physical servers running SQL 2008, how should I go about using this tool to generate the report? OR is there any other tool available?
Please advise.
Thanks and Regards.
Due to recent changes by Microsoft the way the SQL server will be licensed in SQL 2012 version, which is core based rather than Processor based.
We have been advised to generate report using MAP tool from Microsoft, to determine number of cores. We have number of Physical servers running SQL 2008, how should I go about using this tool to generate the report? OR is there any other tool available?
Please advise.
Thanks and Regards.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go to taskmanager --> performance.
the amount of graphs next to cpu is the amount of cores.
my quad core displays 4 graphs and my i7-920 displays 8 graphs. and that's correct.
the amount of graphs next to cpu is the amount of cores.
my quad core displays 4 graphs and my i7-920 displays 8 graphs. and that's correct.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I downloaded the MAP-toolkit; set it up; pointed it to one of my 2-CPU servers; and let it rip. It came back and reported that there were 0 cores. Based on that, I am expecting a refund from Microsoft because apparently we are managing to run on air ;-)
ASKER
How to specifically point the MAP to generate report on number of cores in a specific SQL server?
<<I downloaded the MAP-toolkit; set it up; pointed it to one of my 2-CPU servers; and let it rip. It came back and reported that there were 0 cores. Based on that, I am expecting a refund from Microsoft because apparently we are managing to run on air ;-)>>
For determining the number of cores its indeed like using a canon to kill a fly.
For determining the number of cores its indeed like using a canon to kill a fly.
ASKER