SQL Diagnostic Manager

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Products and Books » Third Party Products » Idera » SQL Diagnostic Manager

13 posts, Page 2 of 2

««1 2

SQL Diagnostic Manager

Rate Topic

Display Mode

Topic Options

Author

Message

Susan-322874

Posted Monday, May 02, 2011 2:34 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, June 25, 2012 2:31 PM
Points: 267, Visits: 72

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

rmanfrinato

Posted Monday, September 05, 2011 8:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 07, 2013 4:06 AM
Points: 119, 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

AKP

Posted Friday, October 12, 2012 2:28 PM

Valued Member

Group: General Forum Members
Last Login: Friday, December 28, 2012 1:37 PM
Points: 67, Visits: 347

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 »

13 posts, Page 2 of 2

««1 2

Permissions