December 29, 2008 at 12:11 pm
Can the Activity Monitor under the Management folder show incorrect information? In the Activity Monitor under the Management folder, sometimes a process that lists my database name in the Database column will list a different database when I show process details. I have tried doing a Refresh, but the mismatch in database names is still there.
December 29, 2008 at 12:32 pm
I can't say that I've seen that. Any time I thought it was wrong, upon further investigation, I found that it was correct. For example, maybe your default connection database is different than you think and when you make a connection it's going to one database and doesn't switch until you do something in the other database (although that usually involves a USE statement in TSQL or clicking on stuff in the GUI).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 30, 2008 at 3:20 pm
December 31, 2008 at 5:49 am
That procedure might be querying across the databases. It's also possible their login is going to your database by default.
I'm sure it's possible for it to report incorrect connections, but I've never seen it or heard of it.
I did a quick search on google and I don't see anything out there. I also checked Microsoft Connect (best place to look for known bugs). The closest thing I could find to your issue has to do with a bug in the early, pre-release, versions of 2008 (https://connect.microsoft.com/Connect/feedback/ViewFeedback.aspx?FeedbackID=371709).
I really think it's probably accurately reporting the connection status for the session.
Try querying the dmv sys.dm_exec_requests. This will show you the actual session information for outstanding queries as they're coming through the system. It includes the database id. If it's showing up as being your database, then it is and you just need to understand why.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply