Which database is connected to the bedroom connection in SQL Server 2008?
I am developing a web application on .NET Framework 3.5. The database server is SQL Server 2008. In the connectionStrings of the web.config file, the database name is set to "mydatabase". The mini-pool size is 50. When I use sp_who to test database connections, I find that for most dormant connections, the dbname is master, not "mydatabase". My question is the database master for all sleeping connections, or are there some errors in my configuration?
Can anyone help me with this?
for most dormant connections, dbname is master, not "mydatabase".
In SQL Server, user sessions (spid or session_id) start at 51, and any sessions up to 50 are system background processes. The main database contains key information for most of these background processes, and what you see is nothing to worry about.
a source to share