SQL Server 2000 and 2005 threads

J

jp2msft

I'm interested to learn just how many threads (separate calls to the Server)
SQL Server 2000 (which we have now) can handle and how many more SQL Server
2005 can handle.

What happens if the Server's thread limit is reached? Would my C#
application throw some form of SqlException?
 
I

Ignacio Machin ( .NET/ C# MVP )

I'm interested to learn just how many threads (separate calls to the Server)
SQL Server 2000 (which we have now) can handle and how many more SQL Server
2005 can handle.

What happens if the Server's thread limit is reached? Would my C#
application throw some form of SqlException?
Click to expand...

and how is that related to C#?

you should post it in a SQL group
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sql server deadlock retry 6
C# 2005 and SQL 2000 2
Inexplicable slowdowns 7
SQL Server 2005 "Connect to Server" Dialog 1
easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function 2
about understanding Threads 7
SQL Server 2005 instance 1
Fix of problem connecting VS2005 to remote Sql 2000 server 9

Top