Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

users in sleeping mode Expand / Collapse
Author
Message
Posted Monday, June 1, 2009 1:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
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
Posted Monday, June 1, 2009 1:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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
Posted Monday, June 1, 2009 5:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
They are connect but no executing anything
Post #726552
Posted Monday, June 1, 2009 10:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
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
Posted Monday, June 1, 2009 10:32 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, December 14, 2014 10:08 AM
Points: 93, Visits: 342
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
Posted Monday, June 1, 2009 10:37 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
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
Posted Tuesday, June 2, 2009 12:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
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
Posted Tuesday, June 2, 2009 1:34 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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
Posted Tuesday, June 2, 2009 4:37 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Tuesday, June 2, 2009 10:32 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946
Thanx

Thanks

Post #727864
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse