Expert
Expert

How to find SPECint2006 Rates value for all esxi host



How to find SPECint2006 Rates value for all esxi host ?


There is a Exchange Processor Query Tool - v1.1.xlsm file , where I can put the process typ in a field and get the specint for a server.

http://blogs.technet.com/b/exchange/archive/2012/04/30/3495285.aspx



Is there a powershell script which gets a list of the processors of all esxi host ?


I did it in a other  way : Took rvtools and export the results to excel file.


Then Pivot Table to get the processors.


Now what to match the  Exchange Processor Query Tool  with pivot table.


Target is to get the specint rate of all esxi and compare to new Intel server with new specint rate .

0 Kudos
2 Replies
Expert
Expert



Here is an expample for one of my farms :  I did this manual.










































































































Processortyp


Number of Servers


Single Specint per Server


Total Secint 


AMD Opteron(tm) Processor 6174


6


782


4692


AMD Opteron(TM) Processor 6276                 


2


973


1946


Dual-Core AMD Opteron(tm) Processor 2218


1


50.3


50.3


Intel(R) Xeon(R) CPU           E5405  @ 2.00GHz


1


108


108


Intel(R) Xeon(R) CPU           X5560  @ 2.80GHz


18


280


5040


Intel(R) Xeon(R) CPU           X5570  @ 2.93GHz


14


266


3724


Intel(R) Xeon(R) CPU           X5670  @ 2.93GHz


6


358


2148


Intel(R) Xeon(R) CPU           X7560  @ 2.27GHz


8


834


6672


Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz


2


693


1386


Intel(R) Xeon(TM) CPU 3.20GHz


2


 


0


Quad-Core AMD Opteron(tm) Processor 2384


2


134


268


Quad-Core AMD Opteron(tm) Processor 8354


9


176


1584


Six-Core AMD Opteron(tm) Processor 2431


8


194


1552


Six-Core AMD Opteron(tm) Processor 8435


30


394


11820


Total


109


 


40990.3




Next what happens when I consolidate the 109 Servers to the new Dell 920 : I devided the 40990.3 specint rate 2006 through 2390 which means 17-18 Dell 17 servers















PowerEdge R920 (Intel Xeon E7-4890 v2, 2.80 GHz)


2390


17.1507531




That is cooll

0 Kudos
Expert
Expert



Found this powercli script to get esxi host cpu

<a href="http://jreypo.wordpress.com/2011/06/07/retrieving-esxi-hardware-info-with-powercli/">http://jreypo.wordpress.com/2011/06/07/retrieving-esxi-hardware-info-with-powercli/</a>



After opening the exchange processor query tool and switch to VBA


Three is following code.


'create and execute web query to spec.org site
    With oSh.QueryTables.Add( _
        "URL;http://www.spec.org/cgi-bin/osgresults?conf=rint2006&op=fetch&field=CPU&proj-BASE=0&proj-COPIES=0&proj-CPU_MHZ=256&pattern=[""System""]" _
        , oSh.Range("$I$1"))
'get the parameter that defines the processor to query on from cell G13
        With .Parameters(1)
            .SetParam xlRange, oSh.Range("$G$32")
            .RefreshOnChange = True
        End With


Show to match this two code?

0 Kudos