The insights of an SQL geek: 05/2009

Sunday, May 10, 2009

EZManage SQL Pro - Recommended MS SQL Server Management Tool

EZManage SQL Pro is a powerful AGENTLESS centralized management tool for the optimal performance of Microsoft SQL Servers. Enterprise version for 1-500 servers
FutureIT’s EZManage SQL Pro offers one click management of multiple servers allowing SQL Server databases to run smoothly, efficiently and continuously. Be able to monitor the status of all your SQL servers and databases from one screen, restore to any point in time with no data loss and easily set up notifications. All this while using less disk space and with applications running faster. What could be better?

Central Management of Multiple SQL Servers

  • Monitor the status of all your SQL Servers and databases in one screen with drill- down capabilities
  • Configurable dashboard to view servers and databases
  • Display database locks and their cause (SQL statement)
  • Intervene and release locks
  • Monitor all server jobs in one screen and prioritize
  • Edit scheduled jobs from multiple servers
  • Quick launch of Microsoft remote desktop,
Windows Explorer or a command shell screen on a remote server
Assign multiple servers to groups for visual and logical order and administration

Backup & Restore
  • Backup speed up to 5 times faster than native SQL
  • Restores up to 8 times faster than native SQL
  • Backup encryption (up to 320 bit)
  • Ultra-high compression of backup files by up to 90%
  • Open compressed backups with standard tools
  • Fine tuning options to set optimum backup speed and compression
  • Restore to any point of time in a single click
  • Easy restore and duplication of databases to different servers
  • Sends backup files off-site by FTP, automatically
  • View backup history
  • Perform backups in parallel or sequentially
  • Backup files to TSM and Tape

Built-in Disaster Recovery

  • Restore databases between server on a schedule routine
  • View synchronization statistics
  • Setup full DRP solution in just a few minutes
  • Reduce company downtime to minimum
  • Monitoring and Alerting
  • Send notifications By SNMP, SMS or email
  • Define alert distribution lists
  • Define customs alerts that suite your company needs
  • Set your own notification suites and attach them to multiple databases and servers in a single click

Automatic Ongoing Optimization

  • Intelligent index defragmentation (based on the state of each index)
  • Shrinking of log files to specified size
  • Real optimization of DB statistics
  • All optimization jobs performed according to protocol and correct best practice sequence preventing errors like accidentally shrinking before backup

Multi Server Scripting

Run scripts on multiple DBs
  • Query multiple servers and databases simultaneously and view single results table
  • Export query results to Excel
  • Print a report of the results
  • Customize and execute scripts from our large script library
  • Ease of Use & Implementation

    • Ultra fast implementation based on pre-defined rules and wizards
    • Standard, hassle-free installation
    • Friendly and easy-to-use interface
    • Pure T-SQL communication to all managed servers
    • Agent-less architecture - no installation is needed on the target servers, improving security

    System Supported Platforms

    • 32-bit: Windows 2000, Windows XP, Windows Server 2000, Windows Server 2003, Windows Vista, Windows Server 2008
    • 64-bit: Windows 2003 (x64), Windows Server 2003, Windows XP, Windows Vista, Windows Server 2008
    • IA-64: Windows Server 2003, Windows Server 2008

    System Supported SQL Servers

    • SQL Server 2000 Standard Enterprise and MSDE Editions
    • SQL Server 2005 Standard Enterprise and Express* Editions
    • SQL Server 2008 Standard Enterprise and Express* Editions