ApexSQL March 2018 newsletter II - Spotlight on monitoring: 2 new releases, 2 new videos and 50% off all monitoring tools Click here to view this newsletter in your browser ApexSQL March 2018 newsletter II ApexSQL monitoring solutions are the focus of this newsletter. In the past 2 weeks, we’ve released 2018 R2 versions of ApexSQL Monitor and ApexSQL BI Monitor, posted short video introductions to ApexSQL BI Monitor and ApexSQL VM Monitor, and prepared 50% discount for all monitoring tools. ApexSQL Monitor 2018 R2 The new release of ApexSQL Monitor brings many important improvements, such as Scheduled reports and Redesigned report viewer with interactive UI. The full list of new features includes: 16 new predefined reports: Top 10 queries with the highest wait time in SQL Server Alerts status Top 10 queries with the highest wait time in the database Average Alert resolution time Top 10 queries with the highest wait time for a specific wait type in SQL Server Top 10 metrics with the highest number of alerts Top 10 queries with the highest wait time for a specific wait type in the database Top 10 SQL Server metrics with the highest number of alerts Top 10 databases with the highest wait time Alert severity statistics Top 10 apps with the highest wait time in SQL Server Indexes with high fragmentation above xx% in SQL Server Top 10 apps with the highest wait time in the database Indexes with high fragmentation above xx% in database Top 10 wait types of total wait time in SQL Server [%] Top 10 databases with the largest log growth [MB] The interactive, integrated report viewer The custom report now allows: Template report creation Combining predefined reports into a single report Combining of report templates into a single report Report scheduler enables running predefined and custom reports on a schedule Send reports to email Include/exclude wait types from monitoring ApexSQL BI Monitor 2018 R2 We’ve released a new version of ApexSQL BI Monitor as well, with several new features and 42 bugs and known issues fixed: Monitor the most important SQL Server Analysis Service Multidimensional databases performance metrics in multiple SQL Server instances Monitor the most important SQL Server Analysis Service cube and object performance metrics in multiple SQL Server instances Monitor the ratio between two predefined metrics To get started with ApexSQL BI Monitor, check out our new video on how to add a service for monitoring, how to create customer metrics, how to handle alerts and create reports, etc. ApexSQL VM Monitor - new video In January this year we released our new monitoring tool - ApexSQL VM Monitor, and we now prepared an introductory video for all of those who are firm believers that a picture is worth a thousands words. The video shows how to start using ApexSQL VM Monitor. It shows important high-level features and usage of essential parts of ApexSQL VM Monitor like Alerts, Reports and Configuration. Specifically, configuration of metrics, settings for historical data, how to include/exclude hardware devices, how to see list of hosted virtual machines. Want to get more out of ApexSQL VM Monitor? Help us put more into it. We’re actively working on translating your feature suggestions and feedback into product enhancements. If you want to contribute, email bugs, suggestions, feature requests, etc. to support@apexsql.com Discounts To stay on the topic of monitoring, we prepared 50% discount for all our monitoring solutions: ApexSQL Monitor: $499 $249 ApexSQL BI Monitor: $499 $249 ApexSQL VM Monitor: $999 $499 As usually, the offer is valid until the next newsletter. If you’re interested, contact us at sales@apexsql.com to claim your discount or use MONITOR2018 promo code for online purchases. Brian Lockwood Founder and CEO @FightingCEO What's new Here are our most recent releases ApexSQL Monitor This release of ApexSQL Monitor 2018 R2 now supports scheduled reports for running predefined and custom reports, wait types monitoring customization, 16 new predefined reports, redesigned report viewer with interactive UI. Redesigned custom report feature allows more flexibility and granularity in customization. Usability and quality are improved with 20 bugs and known issues fixed ApexSQL BI Monitor The latest release of ApexSQL BI Monitor 2018 R2 offers monitoring for cube and object performance metrics, SSAS objects performance metrics, with option to combine and customize predefined metrics. Standard quality and usability improvements are also part of this release, adressing the 42 known bugs which are fixed See What's new for descriptions of all of our recent releases Videos Take a look at our most recent videos An introduction to ApexSQL BI Monitor An introduction to ApexSQL VM Monitor An introduction to ApexSQL Enforce Advanced auditing techniques - using the Watches feature Automatically creating SQL Server CRUD procedures Blog Here are our most recent blog posts ApexSQL Audit 2018 R2 – Product update alert Reverse engineering tour – Visualizing databases with data model diagrams ApexSQL Monitor 2018 R2 – Product update alert What’s next in ApexSQL SQL Developer: ApexSQL CI/CD toolkit Web dashboard ApexSQL Source Control 2018 R3 – Product update alert ApexSQL BI Monitor 2018 R2 – Product update alert Solution center Our Solution center is a content site with in-depth articles focusing on tough nuts that DBAs and developers are challenged with Here are our most recent articles How to create and optimize SQL Server indexes for better performance Visual tools for monitoring SQL Server query performance How to optimize SQL Server query performance – Statistics, Joins and Index Tuning How to optimize SQL Server query performance Documenting individual build changes (vs an entire database) in a SQL Server continuous integration pipeline Knowledgebase Take a look at some tricks and how-to articles for ApexSQL tools at our knowledgebase blog Auditing SQL Server databases – initial configuration ApexSQL BI Monitor - Permissions and requirements ApexSQL VM Monitor - Permissions and requirements Searching data in grids Managing rows in grids SQL Shack Here is a list of all SQL Shack articles published since our last newsletter Cardinality Estimation Place in the Optimization Process Migrating an Oracle Database to SQL Server with Microsoft Data Migration Assistant – Installation Process and Short Overview Cardinality Estimation Role SQL Server Reporting Service: how to handle common end-user requirements with Report Builder How to migrate SQL Server 2017 Master Data Services Models into another server Sequence Objects in SQL Server Understanding the Data Management Life Cycle Time Intelligence in Analysis Services (SSAS) Tabular Models SQL Server Index Structure and Concepts An overview of SQL Server database migration tools provided by Microsoft Introduction to data science, data understanding and preparation Recently added keys We keep increasing the value of our bundles with new releases and pre-releases. Recently added keys include Feb 14, 2018 ApexSQL Model Pre-release ApexSQL Developer Jan 31, 2018 ApexSQL Job Pre-release ApexSQL DBA Jan 24, 2018 ApexSQL Pump Pre-release ApexSQL Developer Dec 07, 2017 ApexSQL Analyze Available ApexSQL Developer Nov 22, 2017 ApexSQL BI Monitor Available ApexSQL DBA Nov 16, 2017 ApexSQL VM Monitor Available ApexSQL DBA Sep 29, 2017 ApexSQL Enforce Available ApexSQL Developer All pre-releases can be pre-ordered with a 50% discount using the code PREORDER2018 What's next We've got a full development pipeline. Here is what will be coming out soon ApexSQL Diff 2018 - The initial release of ApexSQL Diff will include mapping tables and columns, export dependencies, actions, warnings and executions results into different output types. It will include 3 new CLI switches, GUI themes, high DPI and 4K resolution support and Visual Language Dictionary for Visual Studio for iconography and other imagery concepts applied. Usability and quality will be improved. Read more ApexSQL Job 2018 - The initial release of ApexSQL Job will include detailed SQL Server job management, job history overview, job schedule management and overview, job alerts management, creating multiple step jobs, SQL Server agent service control, support for multiple script types and Export job history to CSV or XML ApexSQL Model 2018 - The initial release of ApexSQL Model, a new database modeling tool will include database model diagrams, model diagrams customization, forward and reverse engineering, model history navigation, grouping, diagram layout and edge routing options, object appearance customization, and autosave option. This tool will be able to print model diagrams and export them into BMP, JPEG and PNG formats. Also, ApexSQL Model will offer support for Azure SQL Database, Amazon RDS for SQL Server and GUI themes. Read more ApexSQL Refactor 2018 - In this release GUI themes are introduced along with high DPI and 4K resolution support for improved quality and usability. Visual Language Dictionary for Visual Studio for iconography and other imagery concepts is also applied. Stay tuned for more releases and new products on our What's next page Events Here are some upcoming events we are sponsoring HRSSUG Virginia Beach, VA - April 18 SQL Malibu UG Los Angeles, CA - April 18 ApexSQL LLC | 11312 US 15-501 N, suite 107-212 | Chapel Hill, NC, 27517 | USA Phone: +1 (866) 665-5500 Email: sales@apexsql.com To unsubscribe from further mailings, please click here
from Gmail
via IFTTT
هیچ نظری موجود نیست:
ارسال یک نظر