Posted by Robert Klemme on 10/25/05 09:58

pardhi a via SQLMonster.com wrote:
> Hi
>
> I am a dba for sql server recently we are facing problems with the
> no of connections.
>
> we have a database called ( x ) every day almost million users is
> using that databse

Concurrently?

> after some time the cpu showing 100 percent
> utilization an error throwing like odbc error connection so in that
> case no one is able to connect to the server.when we pause it then
> restart the server for some time it looks good then again it will go
> to 100 % utilization.but there is no blocking occuring

Sounds like you have a resource problem. 1,000,000 concurrent users need
some resources (mainly mem) for managing them alone. If they start doing
transactions this will likely increase. Maybe your connections aren't
released properly afer work is done or your system is just undersized.

Kind regards

robert

[Back to original message]