mibuso.com

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

View unanswered posts | View active topics


Board index » Other » SQL Performance

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 6 posts ] 
  What's this MUID? [MUID:NUXA] Previous topic | Next topic 
Author Message
nikeman77
 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  
 
sunmorningindia
 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  
 
kriki
 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  
 
stryk
 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  
 
nikeman77
 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  
 
stryk
 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  Page 1 of 1
  [ 6 posts ] 

Board index » Other » SQL Performance

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: