I've got an ill-behaved multi-threaded application that opens
several hundred database connections to an MSSQL2000 server, and
then issues queries to the point that the CPU is pegged at 100%
(and eventually port 1433 cracks....it looks similar to a
Denial-of-Service attack :-()

While I convince the application developers to do better
application-to-database thread management, is there any way I can
unilaterally limit the number of database connections that my
Server will allow from a given user or IP address?

thanks for your help!



MS Sql Server LazyDBA home page