Performance in SQL

nikeman77

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

sunmorningindia

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

[Topic moved from 'NAV/Navision Classic Client' forum to 'SQL Performance' forum]

stryk

Well, maybe you'll fine HERE some "inspiration"

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)

nikeman77

hi stryk,

Platform monitoring refer to windows? How different is that from Task Manager?
:roll:

stryk

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