Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community
All Tags » Performance » Index (RSS)

Browse Site by Tags

Showing related tags and posts across the entire site.

  • MS Dynamics NAV 5.0 Service Pack 1

    Well, at Convergence 2007 in Copenhagen it was announced (Session: NAV Keynotes) that in Q1 2008 the SP1 for NAV 5.00 would be released (dates are subject to change, of course). During the "Meet the Experts" session little more information about the SP's content was published. As we had...
    Posted to Dynamics NAV Performance on SQL - My Two Cents by Jörg A. Stryk on 10-30-2007
    Filed under: SQL, Performance, Index, view, SP1, nav 5.0, indexed view

  • Included Columns vs. SIFT Tables

    Base on David's "hint, hint ) I made my promise come true and copied this from a current thread: SIFT tables include aggregated information of e.g. "Ledger Entry" tables to display these values in FlowFields. The aggregation is done via SQL Server site triggers which are programmed...
    Posted to Dynamics NAV Performance on SQL - My Two Cents by Jörg A. Stryk on 10-28-2007
    Filed under: SQL, Performance, Index, SIFT

  • Performance Experience with SATA for NAV on SQL DB (was: Navision DB)

    Hi IHAC who has deployed Navision for Retail stores. The deployment architecture is described below: Intel Blade with 1 Xeon E5320 Quad Core 1.86 GHz 16 GB memory 4x 146GB SAS Drives The App sits on the C Drive of the Blade The DB sits on an external storage connected via FC HBA The external storage...
    Posted to NAV / Navision - Microsoft SQL Server by Mitesh on 10-19-2007

  • Is Navision to stupid or is SQL to smart

    Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What...
    Posted to Mark Brummel by Marq on 08-21-2007
    Filed under: SQL, Performance, index, recompile, Navision, indexhint, bug

  • Re: Performance Issue

    Hi! Welcome to dynamicsusers.net Please, search the forums for "SQL Performance" and you'll see, that these issues are actually permanetly discussed. Performance Optimization of NAV on SQL Server is a complex task, and you will get "gazillions" of valuable advice! Good Luck! Jörg
    Posted to NAV / Navision - Microsoft SQL Server by Jörg A. Stryk on 08-16-2007
Page 1 of 1 (20 items)

Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.