Feature Request - Grouping of servers, Recommendations SQL

• 

  jerryhung wrote:

  Feature requests
  
  1. Add a group to the list of SQL Servers
  so I can classify DEV, UAT, Staging, etc... servers
  and perhaps allow Group action such as Set X interval for polling this group, refresh this group, etc..

  
  We didn't add explicit grouping like that - which was a big discussion.. however you can set up and save "Filters" which are a grouping of servers and alert types/levels to display. And for configuration you can create new templates and assign servers to those so they can share common configurations.
  

  jerryhung wrote:

  2. Recommendations will include actual fixes if possible?
  e.g. for Recommendation "page verify is turned off"
  you could show the actual SQL script to do it
  ALTER DATABASE DATABASE_NAME SET PAGE_VERIFY CHECKSUM
  GO
  
  I can see them handy for
  index fragmentation (showcontig/rebuild/reorganize)
  backup (so a backup SQL script)
  integrity (DBCC CHECKDB script)
  excessive space (DBCC SHRINKFILE?)

  
  This again is something that has been discussed and it will certainly be revisited for the next major release - but no promises I'm afraid.

  Nigel Morse September 12, 2008 05:31

  - 0 +
• 

  jerryhung wrote:

  Feature requests
  
  1. Add a group to the list of SQL Servers
  so I can classify DEV, UAT, Staging, etc... servers
  and perhaps allow Group action such as Set X interval for polling this group, refresh this group, etc..
  

  
  Hi Jerry,
  
  Just to let you know that groups are now supported in SQL Monitor 2.0.
  
  Regards,
  Priya

  priyasinha November 15, 2010 10:46

  - 0 +

Add comment

Please sign in to leave a comment.