Comments
Sort by recent activity
Sorry but we currently don't have a command-line alternative for adding servers/instances.
The quickest way to do this would be to create a comma separated list of the servers. Placing \* after each server would tell SQL Monitor to automatically add all instances on that server. For example
server1\*,server2\*,server3\*,server4\*,etc
This is still a fair bit of work admittedly. On my test rigs I used to export a list of machines from Active Directory Users and Computers to a text file, manipulate the list into the above format using notepad and then copy+paste into the Add Servers textbox.
Hope this helps
Chris / comments
Sorry but we currently don't have a command-line alternative for adding servers/instances.
The quickest way to do this would be to create a comma separated list of the servers. Placing \* after eac...
Hi Harold
We'll assess each of these and raise enhancement requests as required to be considered for a future release
Thanks
Chris / comments
Hi Harold
We'll assess each of these and raise enhancement requests as required to be considered for a future release
Thanks
Chris
Hi Johan
We're aware of customer issues with this alert and have seen a couple of forum posts prior to this that seem to describe a similar issue. http://www.red-gate.com/MessageBoard/vi ... hp?t=12244 http://www.red-gate.com/MessageBoard/vi ... hp?t=12152
We will be improving this alert for the next version of SQL Monitor. Hopefully it will be less confusing.
Thanks
Chris / comments
Hi Johan
We're aware of customer issues with this alert and have seen a couple of forum posts prior to this that seem to describe a similar issue.http://www.red-gate.com/MessageBoard/vi ... hp?t=12...
Just a quick update. The access violation error has been fixed for the next release. Hopefully this was the only issue.
Thanks
Chris / comments
Just a quick update. The access violation error has been fixed for the next release. Hopefully this was the only issue.
Thanks
Chris
If the monitoring stops again then that would be a good time to check that logs page.
I'm particularly interested in what the diagnostic page says because I had an issue today that sounds exactly like the problem you describe here. I was running some nasty SQL on a 2000 server and the monitoring was stopping until I retried the connection. The diagnostic page was showing an access violation error.
If the issue doesn't re-occur then the log files at “C:\ProgramData\Red Gate\Logs\SQL Monitor 2†could help us. As before could you zip them up and send to chris.spencer@red-gate.com
Many thanks
Chris / comments
If the monitoring stops again then that would be a good time to check that logs page.
I'm particularly interested in what the diagnostic page says because I had an issue today that sounds exactly l...
The logs could contain some useful information but first it would be interesting to know if you see any error message on the diagnostic page.
This can be viewed by clicking the Show Log link for the relevant machine or instance on the Monitored Servers page and it can be filtered to show only errors.
Thanks
Chris / comments
The logs could contain some useful information but first it would be interesting to know if you see any error message on the diagnostic page.
This can be viewed by clicking the Show Log link for th...
Hi Peter
I've raised an enhancement request (ref SRP-2714) to review the FAQ and make this more clear.
Thanks
Chris / comments
Hi Peter
I've raised an enhancement request (ref SRP-2714) to review the FAQ and make this more clear.
Thanks
Chris
Hi again
Actually I've found http://www.red-gate.com/products/SQL_Monitor/faq.htm
I presume this is the FAQ you mentioned?
Thanks
Chris / comments
Hi again
Actually I've found http://www.red-gate.com/products/SQL_Monitor/faq.htm
I presume this is the FAQ you mentioned?
Thanks
Chris
Hi Peter
SQL Monitor has "zero-impact" in that we don't install anything on monitored servers. Obviously we do cause some overhead as we're running queries against the servers. However, these queries avoid locking so shouldn't be causing any deadlocks.
Would you be able to post any information about the deadlocked queries? We can check these just to be sure that SQL Monitor isn't causing any issues.
Many Thanks
Chris / comments
Hi Peter
SQL Monitor has "zero-impact" in that we don't install anything on monitored servers. Obviously we do cause some overhead as we're running queries against the servers. However, these queri...
Hi Peter,
I've checked with the relevant developer and yes you're correct, we do enable Trace Flag 1204 in order to get information about deadlocks. We also have an alert that will inform users if we're unable to do this.
Apologies for the misinformation. I've had a quick look at our online help information and can't find an FAQ. Would you be able to point me in the direction of the page that states that we don't change anything on the servers? I think we need to re-word it.
Regards
Chris / comments
Hi Peter,
I've checked with the relevant developer and yes you're correct, we do enable Trace Flag 1204 in order to get information about deadlocks. We also have an alert that will inform users if ...