SL 2011 FP1 Slow Performance

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (15)

Answers (0)

Butch Adams 4,763 on at

Like (0)

Report

Well it isn't for the lack of hardware, that's for sure.

Was SL running on there prior to the upgrade to FP1?

I would say set up some performance counters on your raid physical and logical layers and see if you have a bottle neck somewhere. Doesn't seem likely, but I would test it just the same.

If you run SL on the server how is the performance?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Kuan Yi Wu .

You use the cash manager module?

If the answer is yes!! check the next tables ...

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

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

If you have transaction mayor to 2013 maybe this is one reazon of slow performance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Butch Adams

Currently the slow performance only happen on the server, the client does not have the performance issue.

Thank You

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ricardo Mena

Yes, we are using cash manager module and most off the records are 2013.

May i know why is the cash manager module affect the performance and is there any solution to solve this issue?

Thank You

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The result of querys. Can you see a period mayor to 201312?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Kuan witch is the total memory?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Ricardo Mena

The total memory is 64 gigabytes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
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

Start Windows Internet Explorer.

On the Tools menu, click Internet Options.

On the Advanced tab, click to clear the Check for publisher's certificate revocation check box under Security.

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:

On the workstation computers:

Click Start, click Run, type cliconfg, and then press OK.

Make sure that both "Named Pipes" and "TCP/IP" show in the Enabled Protocols area.

Make sure that the "Named Pipes" protocol is listed first.

Click OK.

On the computer that is running Microsoft SQL Server:

Click Start, point to Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

Expand SQL Native Client Configuration, and then click Client Protocols.

Make sure that both "Named Pipes" and "TCP/IP" have the Enabled column set to "Enabled."

Make sure that the "Named Pipes" protocol has an Order value of 1.

Make sure that the "TCP/IP" protocol has an Order value of 2

Try testing disabled the antivirus.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No