howardroark 0 Newbie Poster

Hi,
I require your suggestions for the database server problem that I have. We have around 4000 thousand client programs spread across globe geographically, with one site having thousand clients. The clients report data directly to db server, not using http but using (tcp/ip connections). My question is whether MS sql server will be able to handle this load? at peak load, there will be connection losses (I guess!)? What factor I have to consider like Hardware?Network?Amount of data?or length(time/duration) of average connection to DB? Please help me with suggestions, or there is some solution to this issue?

Thanks in advance,
P

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.