Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Diagnostic Manager Expand / Collapse
Author
Message
Posted Monday, May 2, 2011 2:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 19, 2016 3:21 PM
Points: 272, Visits: 101
We are using the Idera SQL Diagnostic tool for various things.
One of them is to put the servers in 'Maintenance mode' prior to going into our maintenance window.
We have a total of 57 servers licensed and right now I'm setting each one individually in 'Maintenance mode'. Has any one figured out a way to do all servers at once?

Thanks
Post #1101934
Posted Monday, September 5, 2011 8:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 7, 2013 4:06 AM
Points: 125, Visits: 43
I am having a particular situation with the Diagnostic Manager.
I have a scheduled Rebuild Job on my server, and it runs sucessfully, but with no results. Only if I do the Rebuild from the interface the % of fragmentation change.
Why is that?

I have also a T-Sql Rebuild Job, but also seems not work.

Any Ideas?

Post #1169973
Posted Friday, October 12, 2012 2:28 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 67, Visits: 384
You can do this way:
This is one time effort and prepare the script for all servers in same way.

update MonitoredSQLServers set MaintenanceModeEnabled = 1 where InstanceName = 'ServerName'

Thanks,
Ashok
Post #1372358
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse