Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

SL 2011 FP1 Slow Performance

Posted on by Microsoft Employee

Hello Everyone

We have a server running SL2011 FP1, the performance of SL2011 was too slow, open a normal screen take around 8-10 sec and for reports roi take around 30-60sec.

Our Server Spec is as below

OS : Windows Server 2012 Standard

SQL: SQL Server 2008 R2 SP2

Processor: Intel Xeon E7-4807

Memory: 64gb

Hardisk Raid: C: Raid1 (OS), D: Raid10 (Database MDF), E: Raid1 (Database LDF)

Both Solomon and SQL Server are installed in the same server, the performance of the server was slow, but the performance of other client workstation are normal.

Please advice, Thank You

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    If your servers have no internet access then this fix will work for Dynamics SL (and all other .Net applications)

    support.microsoft.com/.../936707

    change the following:

    • C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config

    Note On x64 machines, you must also change the following:

    • C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config

    From:

          </runtime>

    To:

    <configuration>

          <runtime>

                 <generatePublisherEvidence enabled="false"/>

          </runtime>

    </configuration>

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Really important question here about your server...  

    Does it have access to the internet for users who are logged into it?

    If it doesn't, that is your problem.

    You can thank Microsoft for requiring their .Net 2.0 applications to access the internet to "Check for Publisher's Certificate Revocation".  And due to other OS and/or IE related bugs (I believe Microsoft calls them features), changing the setting in IE for your users does nothing to fix the issue.

    Please read here:

    social.technet.microsoft.com/.../group-policy-preference-not-working-for-ie7-check-for-revocation

    This bug still exists in Server 2008 R2 and IE 10.  We have tried all kinds of things to force the setting for users, but it just doesn't save/work properly.

    We have found through our own testing, the only way to get the screens to load faster is to grant internet access to the users from the server.  Hope your anti-virus is good...

    :-(

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Hy Kuan Yi Wu  do you have others aplication do this server?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Hi Dwight Neate

    I had set the SQL server to use 80% of the memory, but the result still the same

    Thank You

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    HI Ricardo Mena

    All the method you mention here had been configured, but the performance still same.

    Thank You

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Your SQL server may be locking the resources on the server for other applications.  Make sure you have the max Ram for SQL set below the server max.  SQL will consume and not release ram to other applications.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Hi Kuan Yi Wu, you have a problem firts on cashsumd table, I see thant the problems is on your server and not with your clients, yours users works find, try to do this:

    I send you some solutions that you try to apply to solve the slow performace on your server.

    First on the server, delete the application and systems ODBC's, then open the dynamics and print preview any report this acction re-create your ODBC's

    Then check this options :

    To improve performance, follow these steps:

    If the computer(s) that are running Microsoft Dynamics SL do not have a connection to the Internet, or have a slow or unreliable connection, the "Check for certificate revocation" setting in Internet Explorer can cause a 5-10 second delay opening most scree

    1. Start Windows Internet Explorer.
    2. On the Tools menu, click Internet Options.
    3. On the Advanced tab, click to clear the Check for publisher's certificate revocation check box under Security.
    4. Click OK

    Named Pipes and TCP/IP should be enabled on the workstation computers and the computer that is running Microsoft SQL Server, with Named Pipes being listed first. To do this, follow these steps:

    1. On the workstation computers:
      1. Click Start, click Run, type cliconfg, and then press OK.
      2. Make sure that both "Named Pipes" and "TCP/IP" show in the Enabled Protocols area.
      3. Make sure that the "Named Pipes" protocol is listed first.
      4. Click OK.
    2. On the computer that is running Microsoft SQL Server:
      1. Click Start, point to Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.
      2. Expand SQL Native Client Configuration, and then click Client Protocols.
      3. Make sure that both "Named Pipes" and "TCP/IP" have the Enabled column set to "Enabled."
      4. Make sure that the "Named Pipes" protocol has an Order value of 1.
      5. Make sure that the "TCP/IP" protocol has an Order value of 2

    Try testing disabled the antivirus.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    HI Ricardo Mena

    The total memory is 64 gigabytes.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Below are the results i get.

    select pernbr as period, * from CashSumD order by PerNbr desc

    select pernbr as period, * from CashAvgD order by PerNbr desc

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2011 FP1 Slow Performance

    Hi  Kuan witch is the total memory?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans