|
|
Posted by Matik on 11/29/05 00:28
Hello 2 all,
Maybe my question can be very stupid, but I'm a little confused.
When I run sp_who on my database, I see one process (accessing remotely
my database from another database on another SQL server) many many
times.
Well, I assume that this is one process, because I cannot imagin that
the data aquiring can be done by almost 1000 (thousand) opened
connections.
This is what I have. Almost 1000 spids running (sleeping) with cmd =
awaiting command.
The best part is, that when I run sp_lock, I see, that the current
session of the client, (lets say spid 53) is locking tempdb, with
objects id below 10 (system).
As far as i know, and as far as I'm using this in my software, there is
no necessity to open-close-open-close connection.
Normaly, you can just open a connection to db, with assigned spid, and
operate within this just one. After the disconect ist done, the session
shoould be removed.
I think, there is something wrong in the way, the remote system is
connecting to my database, but i'm not sure is it normal what I'm
expieriencing or not.
below, a piece of that what sp_who returned:
SPID ECID status loginname hostname blk dbname cmd
266 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
267 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
268 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
269 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
270 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
271 0 sleeping remote_user_name host_ERP 0
PRIMARY_PROCESS_DB AWAITING COMMAND
and these are locks from sp_lock 53 which is the current running
process:
53 7 0 0 DB S GRANT
53 2 6 0 TAB IX GRANT
53 2 1 0 TAB IX GRANT
53 2 3 0 TAB IX GRANT
53 2 2 0 TAB IX GRANT
53 2 12 0 TAB IX GRANT
53 2 9 0 TAB IX GRANT
53 2 11 0 TAB IX GRANT
53 2 3 2 KEY (1902141b21c7) X GRANT
53 2 1 3 KEY (e60041ad2c6f) X GRANT
53 2 3 2 KEY (5b0233670fb9) X
GRANT
53 2 3 2 KEY (6e0212a7298c) X GRANT
53 2 3 2 KEY (97013ece81c8) X GRANT
53 2 3 1 KEY (e7006f987fb0) X GRANT
53 2 1 3 KEY (ad00a33f46b9) X GRANT
53 2 1064356070 0 TAB Sch-M GRANT
any idee?
Thanks
Mateusz
[Back to original message]
|