You’re offline. This is a read only version of the page.
Announcements
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
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>
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...
:-(
Hy Kuan Yi Wu do you have others aplication do this server?
Hi Dwight Neate
I had set the SQL server to use 80% of the memory, but the result still the same
Thank You
HI Ricardo Mena
All the method you mention here had been configured, but the performance still same.
Thank You
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.
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
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:
Try testing disabled the antivirus.
HI Ricardo Mena
The total memory is 64 gigabytes.
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
Hi Kuan witch is the total memory?
#1
André Arnaud de Cal...
293,998
Super User 2025 Season 1
#2
Martin Dráb
232,850
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
