How to take the advantage of a high end box with 4 cpus running win2k3 server with C# programming

[Mark]

Hi,
I'm programming an application with .net C#. The application will talk to
SQL Server on same box. The box has 4 P4 CPUs running Win2k3 server. I have
a question here, what kind of technique I should use to take the most
advantage of the box besides multi-threading?

Thanks in advance!
Mark

[Ravichandran J.V.]

I presume it must be a windows application and not an ASP.Net app.

with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What the application does ?

Multi thread is good for lenghtly processing, especially when you have more
than one processor, if the application is a web app for example you don't
have to spawn new threads as multiples request should execute concurrently
on different processors.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Mark" <mx*@rogers.com> wrote in message
news:pf********************@rogers.com...

Hi,
I'm programming an application with .net C#. The application will talk to
SQL Server on same box. The box has 4 P4 CPUs running Win2k3 server. I
have
a question here, what kind of technique I should use to take the most
advantage of the box besides multi-threading?

Thanks in advance!
Mark

[Mark]

Hi,
It's a windows application and will query data multiple times from SQL
Server, does some calculation and update the table with the results.
I did some test for that with threading. I initialed 30 threads and started
them. Only some were executed and others looked like never started. What did
it happen? I missed something?

Thanks,
Mark
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:eU**************@TK2MSFTNGP09.phx.gbl...

Hi,

What the application does ?

Multi thread is good for lenghtly processing, especially when you have more than one processor, if the application is a web app for example you don't
have to spawn new threads as multiples request should execute concurrently
on different processors.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Mark" <mx*@rogers.com> wrote in message
news:pf********************@rogers.com...

Hi,
I'm programming an application with .net C#. The application will talk to SQL Server on same box. The box has 4 P4 CPUs running Win2k3 server. I
have
a question here, what kind of technique I should use to take the most
advantage of the box besides multi-threading?

Thanks in advance!
Mark

[Mark]

Yes, it's a windows app.

"Ravichandran J.V." <jv************@yahoo.com> wrote in message
news:#J**************@TK2MSFTNGP14.phx.gbl...

I presume it must be a windows application and not an ASP.Net app.

with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jon Skeet [C# MVP]]

Mark <mx*@rogers.com> wrote:

It's a windows application and will query data multiple times from SQL
Server, does some calculation and update the table with the results.
I did some test for that with threading. I initialed 30 threads and started
them. Only some were executed and others looked like never started. What did
it happen? I missed something?

Without seeing your code, it's impossible to tell. The connection pool
may be throttling the number of concurrent connections to your server
though. Also if you're updating your UI from the worker threads, that
would cause problems.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Mark]

Jon,
Probably too many classes and lines to post them. But you reminded me.
Originally my single thread program use one sql connect pool with default
its properties which has 100 connections inside. All jobs done by one
object, the object at least talks to SQL Server 5 times. Then I changed the
program by manually start 30 worker threads and each thread runs with one
object (each object has different target to avoid dead lock issue). Then the
worst case, some threads cannot get the sql connection. The UI is only
updated by main thread.

I will increase the connection number in the sql connection pool and try
again.

Thanks,
Mark
"Jon Skeet [C# MVP]" <sk***@pobox.com> wrote in message
news:MP************************@msnews.microsoft.c om...

Mark <mx*@rogers.com> wrote:

It's a windows application and will query data multiple times from SQL
Server, does some calculation and update the table with the results.
I did some test for that with threading. I initialed 30 threads and started them. Only some were executed and others looked like never started. What did it happen? I missed something?

Without seeing your code, it's impossible to tell. The connection pool
may be throttling the number of concurrent connections to your server
though. Also if you're updating your UI from the worker threads, that
would cause problems.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too