mibuso.com

Microsoft Business Solutions online community
It is currently Tue Jul 29, 2014 6:38 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: How to control blocks and performance on SQL?
PostPosted: Thu Apr 03, 2008 2:28 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 2043
Location: Wilrijk, Belgium
Country: Belgium (be)
How to control blocks and performance on SQL?

http://www.mibuso.com/howtoinfo.asp?FileID=19

Discuss this How To here.


Top
 Profile  
 
 Post subject: Re: How to control blocks and performance on SQL?
PostPosted: Wed Nov 24, 2010 6:35 am 
Offline

Joined: Thu Jan 21, 2010 5:34 am
Posts: 342
Location: Surabaya
Country: Indonesia (id)
Hi,

Thank you for this useful tool.
I have download this tool, but when I click button Show Active Sessions, it result error :
Quote:
This program must be run from from 60150:"SQL Session Performance"


How to solve this error so I can open the Show Active Sessions ?
Thank you.

_________________
Best regards,

Johanna


Top
 Profile E-mail  
 
 Post subject: Re: How to control blocks and performance on SQL?
PostPosted: Thu Nov 25, 2010 7:51 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7683
Location: Milan
Country: Italy (it)
The form you run must be started from form 60150. It is not a form you can run in itself.

_________________
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

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: How to control blocks and performance on SQL?
PostPosted: Fri Nov 26, 2010 4:15 am 
Offline

Joined: Thu Jan 21, 2010 5:34 am
Posts: 342
Location: Surabaya
Country: Indonesia (id)
Hi Kriki,

Thank you for your reply. I have run form 60150 then clicked the button "Show Active Sessions" and got the error result "This program must be run from form 60150:SQL Session Performance".. How to solve this error? Thank you.

_________________
Best regards,

Johanna


Top
 Profile E-mail  
 
 Post subject: Re: How to control blocks and performance on SQL?
PostPosted: Fri Nov 26, 2010 12:06 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7683
Location: Milan
Country: Italy (it)
First you need to put "Log Active Sessions" to true.

This logs in a temptable the records where a session uses too much resources (see the fields on the form). If no logs are made, you get that error.

To have some logs easily, do this:
"Log Active Sessions"=true
"Log only blocks"=false
"Beep on heavy *"=1

Open another session (if no other session is working) and do something in there.

After some moments, you will be able to open the form and see some records.

_________________
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

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: How to control blocks and performance on SQL?
PostPosted: Mon Nov 29, 2010 5:21 am 
Offline

Joined: Thu Jan 21, 2010 5:34 am
Posts: 342
Location: Surabaya
Country: Indonesia (id)
Hi Kriki,

I have tried your directions and it has worked. Now I can access "Show Active Sessions" from SQL Server Performance. Thank you so much. :thumbsup:

_________________
Best regards,

Johanna


Top
 Profile E-mail  
 
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: