Wednesday, September 15, 2010

Discontinuation Dates for Business Portal technical Support

Mark your calendars for the upcoming service discontinuation for the Business Portal users.

Below are the details..

Cheers.

Feradh



Product Line - Microsoft Dynamics GP

Business Portal Release Version

Dynamics
Release Version

Platform

Database

Release Date

Technical Support Discontinued
3.09.0

Windows 2003

Microsoft SQL 2/05 1/11/2011

2.5

8.0

Windows 2003

Microsoft SQL

8/04

10/13/2009

2.0

7.0, 7.5

Windows 2003

Microsoft SQL

1/04

1/09/2007

1.2

7.0, 7.5

Windows 2000

Microsoft SQL

8/03

10/01/2004

1.0

7.0, 7.5

Windows 2000

Microsoft SQL

4/03

10/01/2004



Product Line - Microsoft Dynamics SL

Business Portal Release Version

Solomon Release Version

Platform

Database

Release Date

Technical Support Discontinued
3.06.5Windows 2003Microsoft SQL1/063/31/2011

2.5

6.0

Windows 2003

Microsoft SQL

8/04

10/13/2009

2.0

5.5

Windows 2003

Microsoft SQL

1/04

10/10/2006

1.2

5.0, 5.5

Windows 2000

Microsoft SQL

5/03

10/01/2004

1.0

5.0, 5.5

Windows 2000

Microsoft SQL

5/02

10/01/2004


Recommended Maintenance with Microsoft SQL Server for Microsoft Dynamics GP Databases

Came across a recommended practice for optimized performance of Dynamics GP . Hope it helps all the DBAs.

Cheers.

<---------------------------------->

Database maintenance helps keep the inner workings of Microsoft SQL Server and the Microsoft Dynamics GP databases running at their peak level. We recommend that you use the following SQL Server maintenance procedures:

  • Use database consistency check commands
  • Update statistics
  • Recompile stored procedures

We recommend that you perform these maintenance procedures weekly for the DYNAMICS database and all company databases. However, you can vary this frequency based on your environment and the activity each database receives. We also recommend that you stagger these maintenance procedures throughout the week to handle lots of data.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Database consistency check commands

You can run database consistency check (DBCC) commands manually with SQL Server through SQL Query Analyzer or SQL Server Management Studio. To do this, follow these steps:

  1. If you use Microsoft SQL Server 2000, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    If you use Microsoft SQL Server 2005 or 2008, click Start, point to Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Management Studio.
  2. In SQL Query Analyzer or SQL Server Management Studio, run one or more of the following DBCC commands:
    • DBCC CHECKCATALOG (DBNAME)
      When you use this statement, replace DBNAME with the name of your database, such as DYNAMICS.

      Note DBCC CHECKCATALOG is included in DBCC CHECKDB for Microsoft SQL Server 2005 or later.
    • DBCC CHECKDB (DBNAME)
      When you use this statement, replace DBNAME with the name of your database, such as DYNAMICS.

      You can schedule this command within SQL Server Enterprise Manager or SQL Server Management Studio so that the maintenance process runs automatically.
    • DBCC DBREINDEX (TableName)
      When you use this statement, replace TableName with the name of the table, such as GL00100.

      The DBCC DBREINDEX command can also be executed manually against all tables at the same time by using the Reindex.sql script. You can find the Reindex.sql script in the default path for Microsoft Dynamics GP as C:\Program Files\Microsoft Dynamics\GP\SQL\Utility\0 folder.

      You can also schedule this command within SQL Server Enterprise Manager or SQL Server Management Studio so that the maintenance process runs automatically.

Update Statistics
There are several ways for you to run the update statistics procedure.

  • You can update statistics by running the UpdatSta.sql script with Microsoft SQL Server by using SQL Query Analyzer or SQL Server Management Studio. You can find the UpdatSta.sql script in the default path for Microsoft Dynamics GP as C:\Program Files\Microsoft Dynamics\GP\SQL\Utility\0 folder.
  • You can run the update statistics process within Microsoft Dynamics GP. To do this, follow these steps:
    1. On the File menu, point to Maintenance, and then click SQL.
    2. Select a database from the Database box and product for Product box.
    3. Select all the tables for that database by pressing CTRL+A within the table listing.
    4. Click Update Statistics, and then click Process.
  • You can configure SQL Server to run the update statistics process automatically within SQL Server Enterprise Manager or SQL Server Management Studio. To do this, right-click your database, click Properties, clickOptions, and then click to select Auto Create Statistics and Auto Update Statistics.
  • You can schedule the update statistics process on a recurring basis within Database Maintenance Plans.

Recompile Stored Procedures
There are several ways for you to recompile stored procedures.

  • You can recompile stored procedures by running the Recomp.sql script with Microsoft SQL Server by using SQL Query Analyzer or SQL Server Management Studio. You can find the Recomp.sql script in the default path for Microsoft Dynamics GP as C:\Program Files\Microsoft Dynamics\GP\SQL\Utility\0 folder.
  • You can also recompile stored procedures within Microsoft Dynamics GP. To do this, follow these steps:
    1. On the File menu, point to Maintenance, and then click SQL.
    2. Select a database from the Database box and product for Product box.
    3. Select all the tables for that database by pressing CTRL+A within the table listing.
    4. Click Recompile, and then click Process.
  • You can recompile stored procedures by scheduling the sp_recompile procedure by using SQL Server Agent Jobs. For more information about steps to create a job within SQL Server Enterprise Manager or SQL Server Management Studio, see SQL Server Books Online. To download SQL Server Books Online, visit the following Microsoft Web site:
    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97

Note If you receive any consistency or allocation errors when you are running these SQL maintenance procedures, you must contact Microsoft SQL Server support. This is not included in the support plan for Microsoft Dynamics GP and it would be an additional cost. Microsoft SQL Server support can be contacted at 1-800-936-5800.

Database Maintenance Procedure Definitions
The following is a list of definitions of database maintenance procedures. For more information, see SQL Server Books Online. To download SQL Server Books Online, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97

  • DBCC CHECKCATALOG: Examines the consistency in system tables and between system tables. This command checks data pages and tables in the specified database for errors.

    Note DBCC CHECKCATALOG is included in DBCC CHECKDB for Microsoft SQL Server 2005 or later.
  • DBCC CHECKDB: Examines the allocation and structural integrity of all the objects in the specified database.
  • DBCC DBREINDEX: Rebuilds all indexes. This command will help reduce page splitting and will improve data modification performance.
  • Update statistics: Updates the query optimizer with distribution information about key values of indexes. This enables the query optimizer to make efficient decisions.
  • Recompile stored procedures: Recompiles the queries and optimizes the triggers used by stored procedures. This recompile procedure updates database statistics and optimization information that can become outdated with changes to the database.

REFERENCES

For more information about how to create a database maintenance plan within SQL Server Management Studio, click the following article number to view the article in the Microsoft Knowledge Base:

875193 Information about database maintenance plans for Microsoft Dynamics GP or Microsoft Dynamics SL on Microsoft SQL Server 2000 or on Microsoft SQL Server 2005

For more information about how to use SQL Server Desktop Engine, click the following article number to view the article in the Microsoft Knowledge Base:

862589 Recommended maintenance for Microsoft SQL Server Desktop Engine (MSDE 2000) or for Microsoft SQL Server 2005 Express for Microsoft Great Plains databases



APPLIES TO

  • System Manager, when used with:
    • Microsoft Dynamics GP 2010
    • Microsoft Dynamics GP 10.0
    • Microsoft Dynamics GP 9.0

Tuesday, September 14, 2010

Upcoming Dynamics events

Just stumbled upon upcoming virtual events that the users for around the globe can attend and hey its FREE !! ..


Webcast: Microsoft Dynamics GP Light User
(formerly Microsoft Dynamics GP Client for Microsoft Office)

Location: Online

Dates: 15th September 2010 10:00 AM (PST)

Links: Register Here, More information

Blog Posts:

Decisions Fall 2010 Virtual Conference

Location: Online

Dates: Dynamics GP Day - 2nd November 2010

Links: Register Here, More information

Blog Posts:

For the full list of events in the US ,check out David Post

Upcoming Events in the Microsoft Dynamics GP Community


Cheers.
Feradh

Tuesday, September 7, 2010

Microsoft Dynamics GP 2010 RTM "CoreMR" VPC is NOW AVAILABLE!!

You guys DEFINITELY need to have a peek at the VPC of GP 2010.AWESOMEEEE!!

More details of the VPC is available at DYNGPTEAM post .

Microsoft Partners can download the VPC here.

Cheers..

Feradh Zain.

GP 9 Main Stream Support Ends in 01/2011

Just a reminder to all the GP9 users that we are coming closer to the end of support life cycle for GP 9 by Jan 2011.
Further information about end of life cycle for other versions are illustrated by Victoria Yudin's blog - http://www.victoriayudin.com/ . Good job Victoria !!

Product Version

Release Date

Mainstream Support End

Extended Support End

Link to Microsoft for more information

GP 6.0

03/31/2004

n/a

n/a

GP 7.0

03/31/2005

n/a

n/a

GP 7.5

07/01/2003

01/09/2007

n/a

Link

GP 8.0

06/01/2004

10/13/2009

n/a

Link

GP 9.0

12/19/2005

01/11/2011

n/a

Link

GP 10.0

10/09/2007

10/09/2012

10/10/2017

Link

Cheers.
Feradh Zain.

Microsoft Dynamics GP 10.0 Service Pack 5 Login Performance issue

With the release of Service Pack 5 for GP 10, there have been few performance related issues identified when used with Analytical Accounting.
Mariano's post GP 10 SP5 Login and 's POST discuss in depth details of the workaround solution.

Regards,
Feradh Zain.

Microsoft Dynamics GP 2010 Exams

Finally,the exam numbers for the GP 2010 has been released last week.

Exam Numbers are as follows:

  • MB3-859 Microsoft Dynamics GP 2010 Financials
  • MB3-860 Microsoft Dynamics GP 2010 Project Series
  • MB3-861 Microsoft Dynamics GP 2010 Installation & Configuration
  • MB3-862 Microsoft Dynamics GP 2010 Inventory & Order Processing
The Microsoft Dynamics GP 2010 exams are available at Prometric Testing Centers.Register and show your colors...

Cheers..

Publish Post