Sign in to follow this  
Followers 0
JeromeB

SQL monitor

4 posts in this topic

#1 ·  Posted (edited)

Hello,

I was wondering if anyone could help me with that.

I'd like to read the activity monitor of our SQL server (remotly).

Does anyone know a way to do that ?

I'd like to get back all the monitor activity into an array.

Or does the activity monitor view is a result of an SQL query ?

thx for your help.

Edited by JeromeB

Share this post


Link to post
Share on other sites



Or does the activity monitor view is a result of an SQL query ?

Yes, afaik all Monitored Activity is stored in a system table.

SELECT * FROM sysprocesses

You'll have to look at your SQL tables to get the exact table name, I'm not sure this is the correct name.

I don't know exactly how to connect to a remote SQL server in AutoIt, never done it before. But from what I understand this should be able to do the trick.


[center]Spiderskank Spiderskank[/center]GetOpt Parse command line options UDF | AU3Text Program internationalization UDF | Identicon visual hash UDF

Share this post


Link to post
Share on other sites

JeromeB,

I've used the a few times in the past. You can use it to connect to your SQL server.

I haven't tried to connect to an Activity Monitor so far as from the local machine. Do you have a solution to connect to it from your local PC e.g. over the MS SQL Studio?


Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]

Share this post


Link to post
Share on other sites

i will take a loot to the master database.

I use SQL mangement studio to connect to my server and check process.

I will check this out, other proposition are welcome ;)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0