Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL 2011 FP1 Slow Perfo...
Microsoft Dynamics SL (Archived)

SL 2011 FP1 Slow Performance

(0) ShareShare
ReportReport
Posted on by Community Member 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

*This post is locked for comments

  • 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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans