MAP + CPT SQL Consolidation Planning tools Issue

Question

I managed to run MAP normally and extracted PerfMetricResults in Excel. Now i went to Excel add-on CPT and loaded the saved Excel. the issue occured when getting compute units for sources, out of 18 servers i got only 1 compute unit.

I would like to know what is the definition for the compute unit as a start, and how to find the most accurate compute unit for some of these models

Intel(R) Xeon(TM) MP CPU 3.00GHz

Intel(R) Pentium(R) III Xeon processor

Intel(R) Pentium(R) 4 CPU 3.00GHz

Intel(R) Xeon(R) CPU E7- 4870  @ 2.40GHz

Intel(R) Pentium(R) III processor

and how the compute unit might differ from number of processors and number of cores.

All help is appreciated.

Regards,

---

Teddy Bejjani - BI Specialist @ Netways

Answer 1

Hi Teddy Bejjani,

Regarding to  your description, seems related to Excel Add-In CPT tool issue. If you have support questions or require additional information, please contact [e-mail]

If you have any problem related to SQL Server, please share the SQL error log for further troubleshooting.

---

Regards, Amber zhang

Answer 2

Im having a real problem installing the CPT tool.  I cant seem to add it as an add-in in excel. It never appears on the task bar.  Should it be a new tab on the ribbon.  Its used doesnt seem to be very well documented and I emailed [e-mail] about a week ago and havnt has a response.  Any help on this would be much appreciated.

Thanks

Answer 3

Step 2. Install CPT

"b. Open Excel. Make sure the “CPT” ribbon appears in Excel. Click on the CPT ribbon tab to view all buttons." .........From How to Get Started? What is the Fix if the ribbon doesn't show in Excel 2007? Any ideas?

Regards,