Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Wednesday, June 4, 2014 4:11 PM
Points: 271, Visits: 84
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: 121, 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: Friday, August 29, 2014 12:04 PM
Points: 67, Visits: 351
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