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

Browse Site by Tags

Showing related tags and posts across the entire site.

  • 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.