<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
users in sleeping mode
12 posts, Page 1 of 2
1
2
»»
users in sleeping mode
Rate Topic
Display Mode
Topic Options
Author
Message
forsqlserver
forsqlserver
Posted Monday, June 01, 2009 1:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
There are lots of users in sleeping mode in sql server are they unused or what does it mean ...are they connected....Please any one help.......
Thanks
Post #726451
GilaMonster
GilaMonster
Posted Monday, June 01, 2009 1:38 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
Means they are not currently running any queries.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #726455
Ratheesh.K.Nair
Ratheesh.K.Nair
Posted Monday, June 01, 2009 5:49 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 3:21 AM
Points: 2,415,
Visits: 3,370
They are connect but no executing anything
Post #726552
forsqlserver
forsqlserver
Posted Monday, June 01, 2009 10:20 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
If they are in sleeping mode yet can they be a reason of slow performance?
Is there any specific number that this much user could connect to sql server?
Can we restrict that after 50 or 60 users connection will not be created?
Please give the three answers seperately...Help
Thanks
Post #727124
GURSETHI
GURSETHI
Posted Monday, June 01, 2009 10:32 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, April 26, 2013 12:57 PM
Points: 92,
Visits: 280
Hello Ajay,
Here are answers to your questions.
Q: If they are in sleeping mode yet can they be a reason of
slow performance?
A: Sleeping means waiting for a event to occur. At any given
point in time there can be multiple connections in sleeping
mode as they will be waiting for IO, CPU, MEMORY etc.
The thing is we need to identify which resource is
which is waited most.
Q: Is there any specific number that this much user could
connect to sql server?
A: There is no specific number.
Q: Can we restrict that after 50 or 60 users connection will not
be created?
A: We can restict concurrent connection count on SQL by a
SP_CONFIGURE paramater named USER CONNECTIONS.
or
Right click on Instance Name in SSMS under object explorer
and select Properties.
Select Connections option under "Select a Page"
from Server Properties screen.
Right hand side provide values (default 0 unlimited)
under Maximum number of concurrent connectins options.
Regards
GURSETHI
Post #727126
forsqlserver
forsqlserver
Posted Monday, June 01, 2009 10:37 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
You have done a great job sethi...
One more thing is confusing me, I have a db server and web server.If anyone log in into website using user id password will it also make a connection in the db server?
If no then what users are login into db servers...?
Thanks
Post #727127
forsqlserver
forsqlserver
Posted Tuesday, June 02, 2009 12:38 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
Dear,
I am also not able to save the result of a query into a CSV file.After saving it doesn't give a readable format.
Thanks
Post #727176
GilaMonster
GilaMonster
Posted Tuesday, June 02, 2009 1:34 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
GURSETHI (6/1/2009)
Q: If they are in sleeping mode yet can they be a reason of
slow performance?
A: Sleeping means waiting for a event to occur. At any given
point in time there can be multiple connections in sleeping
mode as they will be waiting for IO, CPU, MEMORY etc.
The thing is we need to identify which resource is
which is waited most.
A sleeping connection is one that is not running a query at the moment. If a connection is running a query and is waiting for a resource (lock, memory, IO) it will be SUSPENDED. If it is waiting for time on the CPU it will be RUNNABLE. If it is currently executing it's status will be RUNNING
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #727190
dbuendiab
dbuendiab
Posted Tuesday, June 02, 2009 4:37 PM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:41 AM
Points: 77,
Visits: 218
The web server uses some SQL credentials to connect to the SQL Server. So, if you have such a hardwired user for your SQL connection, that one will be repeatedly setting the connections. Usually you'll get a connection, perform the query and leave the SQL Server.
Post #727787
forsqlserver
forsqlserver
Posted Tuesday, June 02, 2009 10:32 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186,
Visits: 1,852
Thanx
Thanks
Post #727864
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
