We have 250+ servers and 300+ instances that we would like to monitor. is there a way to add these systems in bulk instead of manually through the gui?
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.
ok, i will give the comma-delimited approach a try. I am concerned though with the number of servers/instances that a single SQL MOnitor environment can effectively monitor. Is there any guidance for this?
Right now I have 55 servers/instances monitored (this is the number in Global Overview) and the system is running at close to 100% cpu at all times. We installed all SQL Monitor components on a single host though for this test, so maybe we need to break things up a bit.
As a rule of thumb I wouldn't suggest attempting to monitor more than 50 servers with a single service but obviously this does depend on how powerful the host machine is.
Breaking the system up would definitely help. The base monitor service will be very busy and needs a dedicated machine. The web server and SQL Server repository would ideally be on separate machines.
Comments
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
Test Engineer
Red Gate
Right now I have 55 servers/instances monitored (this is the number in Global Overview) and the system is running at close to 100% cpu at all times. We installed all SQL Monitor components on a single host though for this test, so maybe we need to break things up a bit.
-js
http://www.red-gate.com/supportcenter/C ... 126997.htm
As a rule of thumb I wouldn't suggest attempting to monitor more than 50 servers with a single service but obviously this does depend on how powerful the host machine is.
Breaking the system up would definitely help. The base monitor service will be very busy and needs a dedicated machine. The web server and SQL Server repository would ideally be on separate machines.
Regards
Chris
Test Engineer
Red Gate