8 Replies Latest reply on Jun 5, 2013 2:14 PM by Jason Capriotti

    Sudden EPDM Add-In Slowdown

    Jim Sculley

      Since Monday, all of my EPDM users are seeing an annoying slow down in SolidWorks when the EPDM add-in is enabled.  Switching documents, suppressing components and many other activities are taking an order of magnitude longer than usual.  No changes were made to the system, but there was a power outage over the weekend.  Thinking that may be the cause, I restarted the database and archive server services but there was no improvement.  I have also completely rebooted the database and archive servers but the problem persists.  Rebooting clients does not eliminate the problem either.  The client log, archive server log and Windows logs do not show anything unusual.

       

      SW and EPDM versions are 2012 SP4 for all clients and servers.

       

      If anyone has any ideas on what else I can check, I would appreciate it.

       

      Jim S.

        • Re: Sudden EPDM Add-In Slowdown
          Eric Endlich

          You may want to check your network and verify that your routers/switches are working correctly. EPDM depends on a reliable network connection and if there is a router or switch that is not functioning correctly, it could cause your clients to experience "slow downs" when using EPDM. It probably couldn't hurt to have your IT reset the affected networking equipment that may have been interupted by the power outage.

            • Re: Sudden EPDM Add-In Slowdown
              Jim Sculley

              I have IT looking into that, but since we are on our own dedicated 1GB network, and we aren;t seeing slowdowns elsewhere, I suspect something inside EPDM.  I just did a database trace on th SQL server and switching between a part model and an assembly with 12 parts causes a 12 second delay before the PDM task pane is updated.  The SQL trace shows one particular event that is taking 12 seconds to complete compared to 1-10 milliseconds for everything else in the trace.  The SQL for the event is:

               

               

              ==================================

              If (object_id(N'tempdb..#InVariables') Is Not Null) Truncate Table #InVariables Else Create Table #InVariables (VarName nvarchar(260) COLLATE database_default, Idx Int)

              If (object_id(N'tempdb..#InFolders') Is Not Null) Truncate Table #InFolders Else Create Table #InFolders (FolderTmpID Int, Path nvarchar(260) COLLATE database_default, FolderID Int)

              If (object_id(N'tempdb..#InFiles') Is Not Null) Truncate Table #InFiles Else Create Table #InFiles (FileTmpID BigInt, FolderTmpID Int,FileName nvarchar(260) COLLATE database_default, ModTime DateTime, LocalVer Int, FileID Int,Cfg nvarchar(255) collate database_default,Cfg2 nvarchar(255) collate database_default)

              SET NOCOUNT ON

              Insert Into #InVariables

              Select N'Description', 1

              Insert Into #InFolders

              Select 2, N'\engineering\library\mechanical\hardware\', -1 Union All

              Select 1, N'\engineering\oracle\401xxx\', -1 Union All

              Select 3, N'\engineering\oracle\404xxx\', -1 Union All

              Select 5, N'\engineering\oracle\421xxx\', -1 Union All

              Select 4, N'\engineering\projects\209762-palo verde small bore nozzle overlays\4. mechanical wip\', -1

              Insert Into #InFiles

              Select 1, 1, N'401742.sldprt', N'2012-03-12T01:36:38.000', -1, 0, N'ACTIVATED', N'@' Union All

              Select 2, 1, N'401693.SLDPRT', N'2012-03-12T02:30:50.000', -1, 0, N'Default', N'@' Union All

              Select 3, 2, N'UNC SHCS.SLDPRT', N'2012-09-10T13:49:12.000', -1, 0, N'0.250-20 UNC-3A 0.875 LONG', N'@' Union All

              Select 4, 1, N'401788.SLDPRT', N'2012-03-12T01:36:14.000', -1, 0, N'Default', N'@' Union All

              Select 5, 3, N'404812.SLDPRT', N'2012-09-24T15:02:48.000', -1, 0, N'Default', N'@' Union All

              Select 6, 2, N'METRIC SHCS.SLDPRT', N'2012-09-05T18:13:16.000', -1, 0, N'M8 x 1.25 - 20mm LONG', N'@' Union All

              Select 7, 4, N'MAGNET MOUNT - WAS 404811.SLDASM', N'2012-09-24T21:14:04.000', -1, 0, N'Default', N'@' Union All

              Select 8, 1, N'401797.SLDPRT', N'2012-03-12T02:30:50.000', -1, 0, N'Default', N'@' Union All

              Select 9, 1, N'401798.SLDASM', N'2012-03-12T02:30:50.000', -1, 0, N'Default', N'@' Union All

              Select 10, 3, N'404813.SLDPRT', N'2012-03-06T19:21:52.000', -1, 0, N'Default', N'@' Union All

              Select 11, 5, N'421312.SLDPRT', N'2012-09-11T15:37:56.000', -1, 0, N'Default', N'@'

              Exec Doc_GetList 3, N'Description'

              ==============================

               

              Pasting that into SQL Server Management Studio and debugging it shows that all the time is spent executing the Doc_GetList stored procedure.  12 seconds to return 11 rows is not what I would consider acceptable performance.

               

              Jim S.