Troubleshooting Performance issues on a Wide Area Network

A while ago, I wrote a post: Why can’t I run Microsoft Dynamics GP via ODBC over a WAN? which discussed the reasons why Microsoft Dynamics GP will not work well when trying to use an ODBC (Open Data Base Connectivity) connection over a WAN (Wide Area Network). The post mentioned that the only support…

1

How to read a Dexterity Script Profile to solve Performance Issues

Today, I thought I would spend a little time explain how to read a Dexterity Script Profile to resolve a performance issue. To demonstrate this I will use a support case I had where the customer was intermittent long delays when clicking on the checkbox on the Apply Sales Document window. The customer in this…

5

Common Support Debugging Tool Myths - Fact or Fiction?

I have just returned from Microsoft Dynamics Conference 2011 Atlanta conference, and based on the feedback during the sessions that Mariano and I presented as well as comments from the session evaluations, I thought it would be worth discussing some of the common Support Debugging Tool (SDT) myths. Here is a list compiled after a…

6

Dynamics GP Slow Login on Terminal Server

This summer I was contacted by one of my associates in our LATAM office.  He noted that their office was running into more and more cases as described below. Dynamics GP freezes during 2-3 minutes just after the login window appears (you cannot even enter the password). This only happens when the Terminal server does…

11

Microsoft Dynamics GP Performance and Version Comparison Whitepapers

If you have not been keeping track of the blogsphere you might have missed some new whitepapers that have been released…. If you ever get asked “Does Microsoft Dynamics GP scale well?”, the answer is simple… Yes.  “Can I have 2,500 users active while also have 10 external processes creating sales orders via web services?”…

0

Why can't I run Microsoft Dynamics GP via ODBC over a WAN?

I had an interesting support case last week where the partner was asking why running Microsoft Dynamics GP via ODBC over a WAN was so slow?  They had already told the customer that this was not supported, but the customer wanted reasons.  Below is my response: I should start off saying that we definitely do…


Dynamics GP Lists: Exports slowly to Excel

Breaking with my recent series on Smartlist and specifically the Smartlist: Exports slowly to Excel – Part 1 post, a comment and followup question to that post was: This is great!  But is there a similar switch for the Dynamics GP lists such as the “All Sales Transactions” or “Accounts” list? Good question and honestly…

4

Smartlist: Exports slowly to Excel - Part 2

This is the 4th post in a series of Smartlist posts in the last weeks.  In these articles, I’ve given answers and solutions to common questions about Smartlist that are typically of the “Why doesn’t Smartlist..?” variety. Last week, the question we were looking at was: Why does Smartlist export to Excel so slowly? The answer…

4

Smartlist: Exports slowly to Excel - Part 1

In the last few weeks (here and here), I’ve enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety. In this post and a few planned future posts, I’ll look at each of these questions individually and give a…

32

VSTools Performance Issue

This blog post is about a difficult Visual Studio Tools for Microsoft Dynamics GP (VSTools) performance issue that I had on a citrix server environment.  What I’m going to do is list the symptoms that I received in the case and then the troubleshooting that we did to narrow down the situation and the results of…

3

How well does Microsoft Dynamics GP scale?

Extremely well…. The answer is out there for all to read. The Microsoft Dynamics GP team is excited to announce the availability of a new White Paper documenting the successful Performance Benchmark Testing of Microsoft Dynamics GP 10.0 SP2 with SQL Server 2008 and Windows Server 2008!   This paper describes the scalability tests of Microsoft…

0

Are you using the Support Debugging Tool?

You might say that I am biased.  As the developer of the Support Debugging Tool for Microsoft Dynamics GP, I believe that every Microsoft Dynamics GP site (v8.0, v9.0 & v10.0) should have the tool installed. Even if you don’t need it straight away, it is always there when you do.  For example: You might…

5

What do the zDP_ Auto Generated Stored Procedures do?

If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials”zDP”. This article explains what the zDP stored procedures do and why they exist. Before Microsoft SQL…

11

Developer & Consultant Articles & Links

This page contains links to developer and consultant related articles and sites (not specific to a particular tool):   Developer Knowledge Base (KB) Articles Finding Table and Field Information in Microsoft Dynamics GP How to obtain the table and field information for windows in Microsoft Dynamics GP (KB 894335) How to create a Dexsql.log file…

7

General Articles & Links

This page contains links to application related articles and sites: Security Knowledge Base (KB) Articles Frequently asked questions about Advanced Security and about Field Level Security in Microsoft Dynamics GP and in Microsoft Great Plains (KB 894705)  Frequently asked questions about role-based security in Microsoft Dynamics GP 10.0 (KB 951229)   Frequently asked questions about the advanced SQL…

5