How to monitor and kill sessions in RTC?

Business Central/NAV Technical Forum
1

Hi everyone,

I want to make a page that end users can monitor and kill database sessions?

Is it possible to do so in RTC?

Thanks…

2

An easy way using just standard development tools? No.

But if you’re using some a little more advanced programming with .NET InterOps, then I’m sure it is possible.

3

In SQL Server you can query the master.dbo.sysprocesses view and look for RTC clients (program_name column) connected to the NAV database (dbid column - execute db_id(‘name of your nav database’) to find the id). If you want to kill an RTC connection you can use the kill keyword in SQL Server in conjunction with the spid you found in sysprocesses.

This will kill the session, so if you accidentally do this to an active user they might lose some data. RTC is able to automatically reconnect if the connection has been dropped, but it can’t always preserve all the state in the user’s pages.

4

Thanks for the answers, but i wonder if it’s possible to kill sessions from RTC?

Is there a simple way to make a RTC page that end users can kill sessions?

5

Hi,

Look at the following link .This is made for Classic client so you can convert it to RTC

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

http://www.samplon.com/Download.html

6

Hi there,

Check out this http://rsdynamicsnavblog.wordpress.com/2013/10/04/kill-nav-inactive-sessions-by-sql-script/

Thank you.