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

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 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

if anyone knows this problem please help
your help would be appreciated.

Thanks


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200510/1

• Next in forum: Re: too many connections
• Prev in forum: Re: User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
• Thread view: too many connections

[Reply to this message]