RE: Any one using Great Plains?

[Tom Miller]

I did receive some information with our consultant.  Here it is:  Q13: How do I disable the Microsoft Office Outlook content from the home page for all users? A13: Run the following script from SQL Query Analyzer, from the Support Administrator Console, or from Microsoft SQL Server Management Studio.   UPDATE A SET COLNUMBR = 0, SEQNUMBR = 0, Visible = 0 FROM DYNAMICS.dbo.SY08100 A WHERE (SectionID = 2) AND     (DICTID = 0) AND ((COLNUMBR <> 0) OR (SEQNUMBR <> 0) OR (Visible <> 0))  We are not an Outlook shop so I'll be doing this. Virus scanner setup We recommend the following exclusions. On the Microsoft Dynamics GP client Exclude the Dynamics\GP folder. By default, this folder is in the following location: C:\Program Files\Microsoft Dynamics\GP The following file name extensions should be excluded: • .cnk These files are used when service packs are installed. These files should not be in a directory for a significant time. • .dic and .chm These files are the Help files for Microsoft Dynamics GP. • .set These files are the start files. These files contain information about the products that are installed and where the products are located. • .ini These files are the configuration files. These files hold information about which user logged on most recently, what data source is used, and the paths. • .dat These files are ctree .dat files that are used with an SQL database. • .idx These files are ctree index files that are used with an SQL database. • .vba These files are used if there are Microsoft Visual Basic for Applications (VBA) modifications for Microsoft Dynamics GP. • .log These files are used by a Dexsql.log file if you use a Dexsql.log file to troubleshoot an error message. On the computer that is running SQL Server Exclude the *.ldf database files and the *.mdf database files. Performance problems that occur on the home page in version 9.0 and in version 10.0 One or more of the home page sections may cause performance problems when you log on or when you refresh the home page. To determine the cause of this problem, follow these steps: 1. On the home page, click the Customize this page link. 2. In the Mark content to display section, click to clear each area. 3. To apply the changes, click OK. 4. In the "Customize your home page" window, add items back to the home page. To do this, click to select the check box next to an item. To test how long the page takes to load, refresh the home page after you add each item. The following features may affect home page performance: • The Outlook integration Latency with the Microsoft Exchange server can cause performance problems on the home page in Microsoft Dynamics GP. • The SmartList favorites in the Reminders area of the To Do home page section Reminders that are linked to the SmartList favorites that have many returned records may cause performance problems on the home page in Microsoft Dynamics GP. For example, this problem may occur if there are more than 1,000 returned records.   >>> "Todd Lemmiksoo" <tlemmik...@all-mode.com> 4/23/2009 11:33 AM >>> This is the same response our users see every morning. We are GP 10 running on a dedicated SQL2005 server with Wennsoft service management. With 18 users logged in during the day.   Todd From: John Aldrich [mailto:jaldr...@blueridgecarpet.com] Sent: Thursday, April 23, 2009 9:26 AM To: NT System Admin Issues Subject: RE: Any one using Great Plains? I passed this along to a former colleague. He’s got GP10 in a virtual environment and he has agreed to test it out. I suggested he sign up for this list and post his results here himself, but if not, I’ll pass along anything he sends me.     From: Tom Miller [mailto:tmil...@hnncsb.org] Sent: Wednesday, April 22, 2009 4:19 PM To: NT System Admin Issues Subject: Any one using Great Plains?   Hi Everyone,   We are moving to MS Dynamics Great Plains, version 10.  We go live in a few months.  What I see is that the Great Plains client is slooooow on remote desktops and via the Terminal Servers.  The client goes non-responsive for a minute, then finally the user can log on, select the company, and go about his business.   Once in the client performance, while not blazing, is acceptable.  Closing the client is pretty quick.   The terminal servers are loaded with memory and CPUs and there is barely a performance change when the GP client loads.  On the GP SQL 2005 server, same thing.  I've been looking at performance stats all day and except for the occasional CPU spike, nothing is going on.   I'm guessing the is a SQL issue?  Any suggestions?  I have other SQL 2005 apps on other servers and don't see this sort of slow client issue.   Thanks,     Tom Miller Engineer, Information Technology Hampton-Newport News Community Services Board 757-788-0528 Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.     No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.2/2072 - Release Date: 04/22/09 08:49:00         Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.