July 10, 2014 at 5:57 am
Hi,
There are more than 1500 SPIDs are sleeping status at SQL instance side. But it is not currently running and nothing to do. it will be wake up when same request come to the database from application side.
DB server hosted multiple databases to differnect application in signle instance. (default)
Application model is client based architecture not in web based system.
Is it any imapct at server resource and database instance side? suggestions pls.
How can manually remove those sleeping SPids?
Thanks
ananda
July 10, 2014 at 10:08 am
You could use KILL on them, but why? Do you know the impact of killing those connections? Do you know if the apps will handle that?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2014 at 11:42 pm
Do you know if the apps will handle that?
Yes: I verified those connection by using inputbuffer command, it is showing SQL query related to the user database. But all SPIDs sleeping I don't know when will reused those connection with same SPIDs.
how to check weather weakup or not and ruuning that sleeping SPIDs? Pls.guide me
July 11, 2014 at 10:36 am
Your reply has nothing to do with what I asked...
Have you checked and verified that the application can handle the connections being killed? If not, do you have any idea what the effects might be if you just kill the connections?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply