locked
MAP + CPT SQL Consolidation Planning tools Issue RRS feed

  • 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

    Saturday, June 9, 2012 2:20 PM

Answers

  • 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 cpthelp@microsoft.com

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

    Regards, Amber zhang

    • Marked as answer by amber zhang Monday, June 25, 2012 2:32 AM
    Monday, June 11, 2012 5:43 AM

All replies

  • 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 cpthelp@microsoft.com

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

    Regards, Amber zhang

    • Marked as answer by amber zhang Monday, June 25, 2012 2:32 AM
    Monday, June 11, 2012 5:43 AM
  • 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 cpthelp@microsoft.com about a week ago and havnt has a response.  Any help on this would be much appreciated.

    Thanks

    Friday, June 15, 2012 9:33 AM
  • 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,

    Monday, August 27, 2012 6:52 PM