Multiple/Duplicate SQL Server Worker Processes

I don't even know where to begin looking... I have a page that loads multiple web user controls...
I know I use one connection object class that is used in all my objects when executing the query (calling Stored Procedures).
The problem is when the first page is rendered and each user control queries the database (SQL Server),
it eventually slows down. In my controls, I use a lot of repeaters and internal queries per each repeater item.
So I know it hits the database quite often.
Problem is when I look in SQL Server Enterprise Manager Process Info, I have multiple worker processes sleeping.
My first thought is ASP.net is creating a new session connection (process) to the SQL Server? Why? How?
What do I do to check either my code is creating the connection object properly. Thanks!
Larry
I have discovered, when I created my connection object for ExecuteNonQuery(), I forgot to Close() the connection.
Since I didn't close the connection object when I was finished... anda few new instances of the connection object was created, it created anew connection object.
In other functions, I was using the DataAdapter which opened and closedthe connection for you, so I took that feature for granted andcompletely forgot to close the connection object when doing aExecuteNonQuery().
I get a doht for the day...
Thanks for taking your time in reading...

Multiple sqlservr.exe processes load

Just installed SBS 2003, and I notice that there are 3
separate processes 'sqlservr.exe' loaded. Is this
normal? In addition to using SQL Server, I'm using Backup
Exec, which uses the same instance of SQL Server 2000.
Reason I ask this is that I'm having trouble making
Enterprise manager connections from workstations, so I'm
looking for cause of problems.It sounds like you have multiple instances of SQL Server running. Open
Control Panel -Administrative Tools - Services and see how many services
you have running that start with MSSQL. This will tell you how many
instances of SQL Server are running.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Multiple sqlservr.exe processes load

Just installed SBS 2003, and I notice that there are 3
separate processes 'sqlservr.exe' loaded. Is this
normal? In addition to using SQL Server, I'm using Backup
Exec, which uses the same instance of SQL Server 2000.
Reason I ask this is that I'm having trouble making
Enterprise manager connections from workstations, so I'm
looking for cause of problems.It sounds like you have multiple instances of SQL Server running. Open
Control Panel -Administrative Tools - Services and see how many services
you have running that start with MSSQL. This will tell you how many
instances of SQL Server are running.
Rand
This posting is provided "as is" with no warranties and confers no rights.