HEELLP

I have a sql server that serving about 200 client. We also have application that running under windows 2000 server connecting to SQL server.

At the begining transaction the server still working well. But after half of an hour the connection in the server size up, i use server performance monitoring to check SQL server connection. Last time i saw it was 780.000 connection. What happen with the server? please help. I am really in deep trouble.




NB:
My SQL SERVER has SP3 running with 4 Gig RDRAM.