mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 4:11 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Performance in SQL
PostPosted: Tue May 22, 2012 4:37 am 
Offline

Joined: Wed Jun 29, 2011 3:26 am
Posts: 374
Country: Singapore (sg)
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:


Top
 Profile E-mail  
 
 Post subject: Re: Performance in SQL
PostPosted: Tue May 22, 2012 8:20 am 
Offline

Joined: Thu May 31, 2007 6:54 pm
Posts: 43
Location: Delhi
Country: India (in)
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


Top
 Profile  
 
 Post subject: Re: Performance in SQL
PostPosted: Tue May 22, 2012 10:13 am 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7496
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV/Navision Classic Client' forum to 'SQL Performance' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
 Post subject: Re: Performance in SQL
PostPosted: Tue May 22, 2012 11:13 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
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


Top
 Profile E-mail WWW  
 
 Post subject: Re: Performance in SQL
PostPosted: Tue May 22, 2012 11:43 am 
Offline

Joined: Wed Jun 29, 2011 3:26 am
Posts: 374
Country: Singapore (sg)
hi stryk,

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


Top
 Profile E-mail  
 
 Post subject: Re: Performance in SQL
PostPosted: Tue May 22, 2012 11:57 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
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


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: