Skip to main content
S
soerton12-Amethyst
12-Amethyst
May 27, 2015
Question

Poor Windchill Performance after upgrade to 10.2 M030 CPS02

  • May 27, 2015
  • 5 replies
  • 6371 views

This past weekend we updated our Windchill System from 10.2 M020 to 10.2 M030 CPS02.  Since then we have been experiencing significantly slow performance with multiple Method Servers becoming deadlocked and the DB maxing out.

Is anyone here running 10.2 M030 CPS02 and have/are you experiencing similar issues?

5 replies

P
PaulCollins10-Marble
10-Marble
May 28, 2015

We are yet to go live with M030 but have experienced several issues as a result of that specific Maintenance release, as a result we are waiting for CPS04 and will revisit the update to M030 at that point.

What Windchill OS and DB are you using?

I am interested to hear if you uncover the root cause of the issues and any resolutions.

S
soerton12-AmethystAuthor
12-Amethyst
May 28, 2015

Our OS is Windows Server 2008 R2 and our DB is SQL Server 2008 R2.

Its currently looking like the upgrade script removed some indexes from the DB that Windchill was using to assist with performance issues.  We recreated the missing Indexes in the DB and that has significantly improved our performance.  We are still have some issues with deadlocked methodservers but PTC is working on getting us a hotfix for it.  Being told this hot fix is coming out with CPS04

    L
    LoriSood23-Emerald I
    23-Emerald I
    June 5, 2015

    We recently published a bulletin regarding deadlocked Method Servers. It would be useful to follow the progress of it. Information is located here:

    http://support.ptc.com/appserver/wcms/standards/freefull.jsp?&im_dbkey=166606&im_language=en

    M
    MichaelStertz10-Marble
    10-Marble
    May 28, 2015

    We have deployed 10.2 M030 CPS01 on a development system. This seems to perform reasonable but there is not much load on the system. We are using Redhat Linux and an Oracle 11g Database.

    We will need functionality fixed in CPS04 so I am interested on the reason to this performance problems. So I am interested in the root cause, too. The release notes for CPS03 still gave no clue about fixed performance problems.

    Deadlocked method servers are likely the result of database locks and/or insufficient db connections. Maybe you get a clue by looking at the database.

    B
    BineshKumar11-Visitor
    1-Visitor
    May 31, 2015

    Do you see anything in the activity monitor? We experienced a deadlock scenario with severe performance issue. This was due to a deadlocked caused by publisher queue.

    We used some of the reports from SQL Server to trace back to the transaction.

    blocking_transaction.jpg

    Upgrade Manger deletes/creates indices at its course of run. Did you notice any error in upgrade manager in this step?

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    June 9, 2015

    I Just discovered that server network card (Windchill 10.2 M030 virtualized) have a big amount of traffic (sometimes more than 200 MB!) when the worker is downloading a big assembly.

    When this happens, the traffic from Windchill and Apache reverse proxy explode and Windchill become extremely slow.

    If I shutdown the worker (Creo 3 M030), than all it's OK.

    Marco
    S
    soerton12-AmethystAuthor
    12-Amethyst
    June 11, 2015

    We are still trying to fix our issue.  We are finding some poorly optimized, both user & non-user initiated, SQL queries that can easily run for over an hour.  When these queries run, the DB CPU spikes near 100% and all traffic seems to stop.  We have also found that a WC restart takes close to 2 hours to bring it back to life because some of the startup queries can easily take over an hour to complete.

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    June 11, 2015

    Thanks for your info.

    We have a different issue, I explain in my previous comment.

    Have you noticed the same behavior?

    Marco
    S
    soerton12-AmethystAuthor
    12-Amethyst
    August 26, 2015

    After upgrading to CPS04, we are back to functioning normally.   Thank you everyone for you help.

      Terms & ConditionsCookie settingsAccessibility statement