Performance in SQL

nikeman77nikeman77 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

  • sunmorningindiasunmorningindia 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
  • krikikriki Member, Moderator Posts: 9,039
    [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!

  • strykstryk 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
  • nikeman77nikeman77 Member Posts: 517
    hi stryk,

    Platform monitoring refer to windows? How different is that from Task Manager?
    :roll:
  • strykstryk 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
Sign In or Register to comment.