In my sql server version 7 database under process info i have a lot of sleeping process by different users. Can any one tell me if this a good thing or a bad thing...I think it has to do with caching and memory management but i would like some one to confirm this.
