March 20, 2009 at 3:52 pm
when i check activity monitor of my server in which i have a sysadmin role i see an spid with my login for a database under RUNNABLE. when i kill that process from query window(i cant kill my own process from activity monitor directly) it switches back to another database and so on. everytime 24/7 isee my own process running under some database, it doesnt use much resources but its kind of frustrating to see my own process running though i dont have any process runnning.
Dont doubt that my process may be running under tempdb as i am running activity monitor its not every time i see a database other than tempdb.
March 22, 2009 at 4:41 pm
Activity Monitor is not lying ...
I find that I have queries running other databases because where I opened the query window. In the new SSMS it really hard to remember to check the db context because it in top-left hand corner. So sometimes I end up opening a window to run a quick statement against DMV/DMF or other statements that don't care about what database context I run them in. And then I start working on other tasks got more query tasks open ...
Another annoying part is once you have few queries open the tabs tend to disappear so they get hidden in that drop-down arrow to see all of them so it is easy to forget you have some extra connections open.
Each query tab in SSMS = new connection ...
Hope that helps a bit ...
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 22, 2009 at 6:22 pm
In addition to what Mohit has stated, each server you have open in Object Explorer will be a connection in Activity Monitor.
You also will get a connection if you have that server included as a registered server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply