Active Monitor?

Question

Post reply

Active Monitor?

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

anthismanos SSC Eights! Points: 839 More actions · Answer 1

I do not know how to do that, sorry. Please explain.

Thank you.

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

Open a new query editor window. (CTRL + N)

Type this:

EXEC sp_WhoIsActive

Hit F5

-- Gianluca Sartori

anthismanos SSC Eights! Points: 839 More actions · Answer 3

Good morning everyone. I managed to run the procedure, my problem now is that i get a total different output from the procedure than that of activity monitor. I mean that in activity monitor i get a large amount of processes running instead of the whoisactive from which i get 2 or 3. Is that normal? Please advice. Thank you.

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

The ones returned by sp_WhoIsActive are the ones that are actually running or holding open transactions.

Activity monitor shows all sessions.

-- Gianluca Sartori

cunningham SSCarpal Tunnel Points: 4595 More actions · Answer 5

I find activity monitor to be a good overview of what's going on my system. I use whoisactive after that to view the transactions that have been running for a long time, and exactly how long they have been running.

You can filter out sessions that arent active in activity monitor by clicking the drop down arrow at the top of the task state column and selecting 'non blanks'. this will filter out idle sessions.

anthismanos SSC Eights! Points: 839 More actions · Answer 6

Hello, I am very happy cause i made it and now i know where and how to look for bad queries!

Thank you all for your precious time and answers of course.

One last question.

How can i have a column with the ip of the workstation that has opened the process? Can this be done?

Thank you.

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 7

EXEC sp_who2 will give you the HostName where the query is running from. Then you can open a CMD prompt and issue a Ping HostName to get the IP address.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

Going back to the OP for a moment, everyone connecting with the sa user is a problem. This means that they can do literally anything on the SQL Server with pesky stuff like permissions getting in their way. I know it'll be a pain to get under control, but I think that it's a worthwhile undertaking.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

denis.bonifazi 28693 SSC Enthusiast Points: 106 More actions · Answer 9

anthismanos (12/12/2014)
It has to do that im completely noob.
Done that, it was so simple, but in
the output window it says : stub version, to be replaced.
Thank you people, you're great.

Guys i receive the same output from WhoIsActive.. "stub version, to be replaced"

What should i do?

spaghettidba SSC Guru Points: 105732 More actions · Answer 10

It looks like the stored procedure was not created correctly.

Do not attempt to run the .sql file directly from Adam's .zip archive: extract it to a temp folder and open the file, then execute it. I know that it sounds illogical, but it's worth trying. Another option is copying all the text from the open .sql file from the archive and paste it to a new query editor window for running.

Try this and let us know if it worked.

-- Gianluca Sartori

denis.bonifazi 28693 SSC Enthusiast Points: 106 More actions · Answer 11

Thanks for your answer , i copied it into a folder on Desktop of the server which is running SQL server, and i run it in my SSMS. i ran as it comes from the Adam's zip file,

without touching anything...

the stored procedure appeard under Programmability/Stored Procedures,

when i launch it , it give the following output:

"stub version, to be replaced"

i very need it to troubleshoot SUSPENDED queries on this server 🙁 🙁

EDIT: i found the problem.. i created it in another DB and not in master DB.. thanks to Gianluca! very available and kind person!