Performance in SQL

nikeman77
nikeman77 Member Posts: 517
edited 2012-05-22 in SQL Performance
hi guys,

anyone knows how to view performance in SQL, afaik in navision we will go into database session and take a look at the
blocking id... but at times no blocking id indicated yet userS still feedback is slow...
:cry:

Comments

  • sunmorningindia
    sunmorningindia Member Posts: 65
    Hi,

    Try with SQL Server Performance dashboard.
    http://www.microsoft.com/en-us/download ... x?id=22602

    You need to study the help file and further do the investigation.

    Thanks,
    Manish
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision Classic Client' forum to 'SQL Performance' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • stryk
    stryk Member Posts: 645
    Well, maybe you'll fine HERE some "inspiration" :wink:

    For Platform Monitoring you could use "Windows Performance Monitor" and PAL
    For Application Monitoring you could use "SQL Profiler" an Qure

    And of curse there are specialized NAV/SQL Performance Tools around 8)
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • nikeman77
    nikeman77 Member Posts: 517
    hi stryk,

    Platform monitoring refer to windows? How different is that from Task Manager?
    :roll:
  • stryk
    stryk Member Posts: 645
    The "Task Manager" just provides very basic information, not really telling much about the system.
    The full truth about the platform (hardware, os, etc.) is revealed by "perfmon.exe" ...
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories