Category : Performance - SentryOne Team Blog

Category: Performance

SentryOne & Microsoft Achieve SQL Server Monitoring Performance Goals

SentryOne & Microsoft Achieve SQL Server Monitoring Performance Goals

The SentryOne monitoring solution has been reengineered with the latest features & technology available from Microsoft SQL Server to dramatically increase performance for the largest customers while reducing storage and compute needs.

Partner Spotlight: Sarpedon Quality Lab

Partner Spotlight: Sarpedon Quality Lab

The SentryOne Global Partner Network is pleased to highlight Sarpedon Quality Lab, our Partner Spotlight for this month. Sarpedon is a consulting and training partner of SentryOne. Sarpedon was established in 2009 by Andreas Wolter, MS MVP. The Frankfurt-based company focuses on high performing OLTP Systems and big Data Warehouse Architectures with an emphasis on

Analyzing VertiPaq Memory Usage in SSAS Tabular in BI Sentry

Analyzing VertiPaq Memory Usage in SSAS Tabular in BI Sentry

Steven Wright digs into some of the new enhancements in the BI Sentry dashboard, which focus on highlighting VertiPaq memory issues in Tabular mode.

Glenn Berry : SQL Server and the Spectre/Meltdown Vulnerabilities

Glenn Berry : SQL Server and the Spectre/Meltdown Vulnerabilities

Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected.

BI Sentry Adds Enhanced SSAS Tabular Support

BI Sentry Adds Enhanced SSAS Tabular Support

Steve Wright blogs about Enhanced Tabular support for SQL Server Analysis Services (SSAS) – a feature of the latest release of BI Sentry – offering BI professionals unparalleled insight into Multidimensional SSAS.

When Troubleshooting Performance Start with the Big Picture

When Troubleshooting Performance Start with the Big Picture

Allen White blogs about one of the great benefits of SQL Sentry: it presents you with an overall picture of the server's performance, allowing you to see what's going on as a whole, and then allowing you to drill into the areas that may be of concern.

Diagnose Performance Issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts

Diagnose Performance Issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts

Steven Wright explains how to diagnose performance issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts and lists some custom Advisory Conditions (AC) that many people find useful when monitoring these systems.

Webinar: Preventing SQL Server Performance Problems Before They Hit Production

Webinar: Preventing SQL Server Performance Problems Before They Hit Production

Kevin Kline describes a new Webinar featuring Sabin IO. If you're a DBA who must remedy poor performance on a SQL Server, or a Developer responsible for writing fast and dependable code, then you'll want to attend this session.

Glenn Berry : Hidden Improvements in SQL Server 2012 / 2014

Glenn Berry : Hidden Improvements in SQL Server 2012 / 2014

Glenn Berry explains several manageability and performance improvements relevant to those of you running SQL Server 2012 and SQL Server 2014.

Jonathan Kehayias : Impact of Fragmentation on Execution Plans

Jonathan Kehayias : Impact of Fragmentation on Execution Plans

Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.

Slides and Scripts: Architectural Choices That Impact Performance of Microsoft SQL Server

Want to download the slide deck and T-SQL scripts for the presentation "Architecture Choices that Impact Performance of Microsoft SQL Server?" Get them here!

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.

Adaptive Query Processing in SQL Server 2017

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really want to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the

Slides and Scripts: Baltimore SQL Server User Group

Slides and Scripts: Baltimore SQL Server User Group

Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.