SQL Elements Discover, track and manage your SQL Server environment effectively SQL Elements provides fundamental information on your SQL Servers to help you keep track of and manage your database environment without having to be an expert in SQL Server. It gives a broad enterprisewide view of all your SQL Servers through automated discovery as well as simple, actionable information about the state of the environment. View core information such as how many databases exist, whether they are being backed up, plus basic availability monitoring and notification so you can take action as needed.
SOLUTIONS FOR INVENTORY ADMINISTRATION
WHY SQL ELEMENTS? As an administrator of SQL Servers, you need a simple, efficient way to discover and explore your SQL Server environment holistically, not just deep dive visibility. Perhaps you have a proliferation of SQL Servers coming online that may have been added without your knowledge and have become difficult to track. Maybe you are the new administrator to your organization and just need a level set of your SQL Server inventory from which to start. Perhaps you have a general idea of how many SQL Servers are in your environment, but you are not sure which ones are the biggest, the busiest, which are backed up or how they are even being utilized. Another scenario might be that you have multiple IT-related responsibilities and have inherited SQL Servers to your charter so you are looking to know the basics in order to manage them effectively. For any of these scenarios, it’s important to not only have a way to inventory your environment, but to determine which SQL Servers need oversight and maintenance. SQL Elements offers a top level view with broad visibility to information about the entire inventory of SQL Servers across the environment.
PRODUCT HIGHLIGHTS • • • • •
Inventory View See quantity of SQL Servers and where they reside Continuous Discovery Regularly scan for newly added servers Availability Alerts Set alerts to monitor status of SQL Servers Health Checks Find and fix poor server configurations Action Items Use built-in tips to assist and expedite tasks
KEY BENEFITS Out-of-the-box Server Inventory Management SQL Elements provides instant and automatic discovery of all SQL Servers across the network. No need to develop any kind of script to determine what servers lurk throughout the environment and how they are being used. Take advantage of built-in default options to manage and maintain those SQL Servers immediately.
Increases SQL Server Availability SQL Elements continuously monitors the entire SQL Server environment and provides alerts when availability issues are discovered. Once notified, DBAs and other administrators can quickly understand why SQL Servers are not performing well and correct the problems before end users complain.
SYSTEM REQUIREMENTS Services
-- Windows XP SP2+, Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012 -- .Net 4.0+ and MDAC 2.8
Repository
-- SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014
Monitored SQL Servers
-- SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 -- All Editions Including Express
Browser Requirements -- Internet Explorer IE 9.x+, Chrome, Firefox
Improves Productivity of Administrators SQL Elements displays built-in tips which are context sensitive to assist in interpreting the information exposed. Plus, it provides actionable responses with recommendations removing the guesswork on what to do next speeding up server management tasks.
Download a FREE 14-Day Trial at www.idera.com
SQL Elements
TECHNICAL FEATURES
INVENTORY MANAGEMENT
AVAILABILITY ALERTING
Views and Topology: Automatically discover the inventory of SQL Servers across the environment. The Dashboard view provides high-level visibility of the inventory to better understand which servers are improperly managed and what actions might need to be taken. Filter down on individual servers to get insights on what these servers are being used for and what resources are being utilized. Some examples of information captured include:
Alert notifications are generated automatically in-product and can be sent via email covering a variety of server indicators as needed. Indicator notifications include:
• • • • •
Top databases by growth Databases with the most activity (transactions) Number of instances owned by a particular group or department Total number of databases by data size or log size Amount of space utilized by development vs. production
Tags and Annotation Once server inventory is discovered, create tags to organize SQL Servers by owner, location, function or other categories to suit different needs. A tag cloud displays within the Dashboard view that groups the created tags to quickly visualize the size of those server groups comparatively by either prominence or importance. Drill down to the Explorer view to see graphical views of the different server groups from the tags created. Compare, filter, and navigate across different server groups to better understand your whole environment. Slice and dice the filters to get a better sense of the inventory you have, who owns the servers, where they reside, etc. Continuous Server Discovery SQL Elements automatically performs daily scans across the network to find newly added servers and databases. Get complete visibility of the environment landscape, including those servers lurking that you may not have known existed. As soon as these servers are discovered, they are immediately captured to the Inventory View with default options so you can see what actions might be needed to bring them up to maintenance.
Availability • SQL Server instance down • SQL Server instance slow to respond • Database down Storage Capacity • Drive at risk of becoming full • Database at risk of becoming full
ARCHITECTURE Agent-less, Low Impact Design • Download, install and use in under 5 minutes • Discover servers automatically; no other modules, plug-ins or professional services needed to get going. • No need to install anything on monitored servers Lightweight Web Framework • Stand-alone web application; no need for IIS • Intuitive web-based UI; sign on and use remotely from anywhere Scalable • Designed to support entire environment. • Feel comfortable tracking Development, QA, Production, SQL Express, etc. Everything is discovered and managed as inventory. • Easy bundle packaging. No need to know exactly how many SQL Servers you have, simply buy by groups of servers and move up to the next band group as your environment grows.
HEALTH CHECKS & ACTION ITEMS Health Checks & Action Items View daily health checks of the server environment to gauge performance and adherence to best practices. If a SQL Server is operating with poor configuration practices, see a list of detailed results with actionable recommendations for improvement from SQL Server experts in easy to understand language. Some examples of misconfigurations and poor practices might include: • Databases not being backed up • Integrity checks not being run regularly • Database autoshrink enabled • Insecure xp_cmdshell functionality enabled If SQL Elements finds anything ill configured, actionable responses will be offered to remedy the problem areas. Help Tips Built-in tips are provided, which are context sensitive, to assist in interpreting the information exposed and remove any guesswork. Explanations provided are free of “jargon” so you don’t have to be an expert to interpret what to do next to speed up server management tasks.
US EMEA APAC MEXICO BRAZIL WEB TWITTER FACEBOOK LINKEDIN
+1 713 523 4433 877 GO IDERA (464 3372) +44 (0) 1753 218410 +61 1300 307 211 +52 (55) 8421 6770 +55 (11) 3230 7938 www.idera.com www.twitter.com/Idera_Software www.facebook.com/IderaSoftware http://www.linkedin.com/ company/idera-software