JeromeB Posted September 24, 2012 Share Posted September 24, 2012 (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 September 24, 2012 by JeromeB Link to comment Share on other sites More sharing options...
dany Posted September 24, 2012 Share Posted September 24, 2012 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 Link to comment Share on other sites More sharing options...
hannes08 Posted September 24, 2012 Share Posted September 24, 2012 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] Link to comment Share on other sites More sharing options...
JeromeB Posted September 24, 2012 Author Share Posted September 24, 2012 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now