Posted by pardhi a via SQLMonster.com on 10/25/05 10:18

currently we are using 2 plus gb memory

Robert Klemme wrote:
>> Hi
>>
>[quoted text clipped - 3 lines]
>> 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


--
Message posted via http://www.sqlmonster.com

[Back to original message]