But, let’s take a minute and think about this a bit closer. Should we? Should we dump everyone out of the database? Are you sure?
- Well, it’s dev and we’ve talked to the development team. No one is doing anything right now.
- It’s prod so we’ve been extra careful. We arranged an outage with the business and confirmed that now is a good time.
Well, in theory, we’ve been told no one is using the database. However, that’s theory, this is reality, and in fact, someone is in the database. But what are they doing? Is it just a leftover connection? Someone left a query window open and forgot about it? The application creates a connection and holds on to it 24×7 even if it’s not doing anything?
Click through for more thoughts on the topic.