Dear all,

We are running BaaN IV c4 with ms-sql server 7.0 as db on Win NT 4.0. Currently there are about 20 concurrent users

When i see the process manager of NT , i can see for each login there is a ntbshell.exe running as well as there is a mssql_srv.exe ( database process ) running for each login, using licmon I got the process id of the user and then compared
it with ntbshell process id , now my question is how do i create a
linkage between ntbshell process id and database
process id i.e. linkage betweeb ntbsheel.exe and mssql_srv.exe ??

Since at times one of the user if runs a heavy report and it takes
too much memory / cpu consumption then how can i kill his baan login ? if i try to killk ntbshell.exe or the mssql_srv.exe using Win NT then it says Access denied, how can i kill it.

If somebody know how do it at SQL Server Enterprise Manager level or at MS-SQL Server Query Analyser level, then kindly let me know.


Thanks in advance.

Regards

Learner

is it not possible in case O/S is Win NT 4.0 ??

You can usually kill the bshell by going to a command prompt and then typing "kill process.id" where process.id is the number shown in the task manager.

Sometimes you will still get access denied though. In SQL server, Baan tends to be mapped that all users are logged in as user Baan so it is hard to say which process you would kill there. Actually, as you point out it is the mssql_srv process you would want to kill anyway.

Something that might help is ProcessExplorer from www.sysinternals.com - I think it is free for personal use as well!

Hi Learner,

I can highly recommend the Process Explorer mentioned by EdHubbard. It is a very good tool providing lots of relevant information about the running processes.

You can see them in a tree-form, so that you see easily which mssql_srv.exe is linked to which ntbshell.exe, and you see exactly which process is started by which Baan-user, under which NT-user etc.

One remark:
It's not recommended to leave the Process Explorer running automatically the whole time, but rather activate it manually [View -> update speed > paused], because the tool requires a lot of cpu-usage.


Good luck!!

En.

Hello learner

It is possible!

You can us the command "tlist" to find out wich process belongs to the ntbshell process of the user.
The option -t shows a process tree. With the pid behind the process name, you know wich process to kill.

The command tlist is in the NT Resource Kit.

/lakoon

Thanks all of you, I will download and evaluate the software, since currently I don't have access to MS SQL Server.

In case of any doubt will revert accordingly.

Regards

Learner

also with the resource kit there is the executable kill.exe use -f option to force processes to stop

Have you tried to kill the proces you found with bshcmd -k <pid>
You can find the proces number <pid> with licmon -w

the bshcmd and licmon can be found in the baan\bin folder.

Hi,

Yaah it works fine, i was able to kill the respective session of a user, using bshcmd -k.

infact Process explorer also i tried, and it works like beauty.

Thanks all of u for your timely help.

Regards

Learner