BTSAdmin Console and Database Connections
Posted by biztodo on September 28, 2007
If you begin your work by opening btsmmc.msc after checking your emails everyday ; you need to look more closely at the database connections.
Open the BizTalk admin console and query analyzer to the database where the BizTalk is configured. Verify the number of connections currently used.
Click on the “Applications” node in the BizTalk console and hit Refresh.
Now rerun the query and you will see atleast 15 more new connections. Everytime you refresh that many new connections pop up. The query you use can be as simple as running “sp_who”.
In the Development enviroment its allright. When it gets to the test or user acceptance enviroment ; its probably not such a good idea to have many developers connect to console and hitting refresh.
These connections do not die until the BizTalk admin is actually closed.
BAM is the best alternative. HAT is also the easiest way to go about. HAT opens only 1 or 2 connections.
Keys : btsmmc.msc; btshatapp.exe
