Pooling:more than one connection to a database

  • I have a doubt that whether Pooling actually works.

    I used below query to check the connection to the database from different pc.

    SELECT hostname,p.status,[program_name],loginame,name

    FROM Master..sysprocesses as p join master.dbo.sysdatabases as d on p.dbID = d.dbID

    WHERE p.ecid=0 and p.hostname<>''

    order by name

    In the output i saw more than one connection from a pc to the same database.

    So i got doubt about this.In my vb.net application i open connection only once.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply