on 2010 Sep 21 7:02 PM
Alas, I didn't save the sa_conn_info() output, but I recently saw several consecutive connection numbers in 1000000xxx range on a 11.0.1 database, started five days earlier, with no activity since the period just after they were started. No identifying information at all. Probably not events or web services.
There are a bunch of things that can cause temporary connections to be created. The list is on dcx on the connection properties page - look for the 'Name' property.
If your server is idle, it is very likely the cleaner.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is actually 11.0.1 (sorry for misleading "12.0.1" in my question). There was nothing showing in the connection name column, were the names added in version 12?
User | Count |
---|---|
67 | |
11 | |
10 | |
10 | |
9 | |
8 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.