Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2010-08-05 : 17:59:14
|
| The Activity Monitor which shows SPID's in Sleeping mode, will this be any side effects if they are continued to be stationed there OR do I need to Kill them if there seems no activity on these SPID's? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-08-05 : 19:21:03
|
| I knew it, just clarified to get opinion, but there it seems the End Users complaining of not able to get the access and when I saw that there is huge piled up SPID's which do nothing.Is this applicable to 2000 / 2005 Server as well since 2005 will automatically removes the days old but not in 2000. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-08-05 : 22:17:53
|
| The Users Either kicked out or unable to get the connection through Remote Citrix or May be slowly running and accessing the data from the Instance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-06 : 02:29:57
|
| If connections not being released might you have run out of connections configured for your SQL licence - and its now rejecting connections? |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2010-08-08 : 18:18:20
|
| Strangely when I collected all the statistics from the Profiler and I/O, Memory and CPU - No Evidence all reported Normal. There is no such Licence has been Obsolete since governed by the Infrastructure Team all time and Vendors were after that for insight.The Reason I make is though 'everything' Seems normal users now and then find difficulty in getting their transactions done and rarely complain about the connectivity and speed issues.Thanks all for participating and if you have ideas which I have missed might be fruitful to me and reading this by other patrons. |
|
|
|
|
|
|
Activity Monitor