sysprocesses

[js]

Hi everyone,

I'm a bit new til ms sql server and hope that anyone here can answer a
question I have. I'm running a ms sql server 7.0. The server is
accessed by a application written in Access (help..) and sometimes I
experience that the server performance is slowing down. When I do a
sp_who I find alot of the processes (or sids) with the status
sleeping? Can anyone please tell med what this means, and is it ok for
me to kill these processes? Since this is happening quite often I
would like to make a script that automatically kills all sleeping
processes, is this ok?
Looking forward to hearing from anyone!

B'reg
Sql server newbee

[Greg D. Moore \(Strider\)]

"js" <jo******@start.no> wrote in message
news:52**************************@posting.google.c om...

Hi everyone,

I'm a bit new til ms sql server and hope that anyone here can answer a
question I have. I'm running a ms sql server 7.0. The server is
accessed by a application written in Access (help..) and sometimes I
experience that the server performance is slowing down. When I do a
sp_who I find alot of the processes (or sids) with the status
sleeping? Can anyone please tell med what this means, and is it ok for
me to kill these processes? Since this is happening quite often I
would like to make a script that automatically kills all sleeping
processes, is this ok?
That would probably be counter productive.

Better off looking at any blocking processes.

Looking forward to hearing from anyone!

B'reg
Sql server newbee

[Simon Hayes]

"js" <jo******@start.no> wrote in message
news:52**************************@posting.google.c om...

Hi everyone,

I'm a bit new til ms sql server and hope that anyone here can answer a
question I have. I'm running a ms sql server 7.0. The server is
accessed by a application written in Access (help..) and sometimes I
experience that the server performance is slowing down. When I do a
sp_who I find alot of the processes (or sids) with the status
sleeping? Can anyone please tell med what this means, and is it ok for
me to kill these processes? Since this is happening quite often I
would like to make a script that automatically kills all sleeping
processes, is this ok?
Looking forward to hearing from anyone!

B'reg
Sql server newbee

A sleeping process is necessarily not a problem, as it simply means the
process is idle or waiting for something. The possible values for status
aren't documented, although there is a bit of information in Books Online
under KILL. If you have performance problems you should probably look for
blocking processes instead of sleeping ones - sp_who2 and sp_lock can help
you see if any processes are blocked, and which objects are locked. Profiler
can also help identify long-running queries which may need to be tuned.

Simon