Pepperdata Introduces Query Spotlight
January 28, 2020
Share this

Pepperdata announced the availability of Query Spotlight, a new product in their big data analytics performance suite.

Query Spotlight makes it easy for operators and developers to understand the detailed performance characteristics of their query workloads together with infrastructure-wide issues that impact these workloads. With this new functionality, query workloads can be tuned, debugged and optimized for better performance and reduced costs, both in the cloud and on premises.

Query Spotlight simultaneously provides detailed information on query resource utilization, along with detailed database views. Query Spotlight details execution plan skew, poorly optimized queries and historical runtime variance so operations teams can remediate issues as they arise. Query Spotlight also highlights hot partitions, outdated table statistics, and other system and storage issues.

Enterprise customers report that queries are a significant portion of their analytics workloads, and the performance of these workloads is critical. Query Spotlight lets IT and applications teams easily identify the most expensive queries and quickly optimize their performance.

Query Spotlight provides a 360-degree view, enabling visibility between executing queries and the database tables they access.

Benefits include:

- Detailed visibility into query workloads, including delayed and most expensive queries as well as wasted CPU and memory queries, enabling root cause analysis

- A single dashboard for a time-correlated view of your query, database and infrastructure metrics to better understand and manage utilization and performance, including query run summaries, tables accessed and query plans mapped to execution stages

- Faster problem resolution through improved visibility and immediate feedback through real-time metrics

- On premises and cloud resource monitoring, with detailed query cost information

- Support for Hive, IBM BigSQL, Redshift and Snowflake

"Queries represent more than 50% of the analytics workloads in today's big data environments. Working closely with our customers we have identified key issues they face with queries in their deployments. We are confident that Query Spotlight solves these pain points. Query Spotlight provides targeted insight into query execution, giving customers the answers they need to dramatically increase performance and rapidly decrease costs," said Ash Munshi, CEO, Pepperdata.

Share this

The Latest

March 27, 2023

To achieve maximum availability, IT leaders must employ domain-agnostic solutions that identify and escalate issues across all telemetry points. These technologies, which we refer to as Artificial Intelligence for IT Operations, create convergence — in other words, they provide IT and DevOps teams with the full picture of event management and downtime ...

March 23, 2023

APMdigest and leading IT research firm Enterprise Management Associates (EMA) are partnering to bring you the EMA-APMdigest Podcast, a new podcast focused on the latest technologies impacting IT Operations. In Episode 2 - Part 1 Pete Goldin, Editor and Publisher of APMdigest, discusses Network Observability with Shamus McGillicuddy, Vice President of Research, Network Infrastructure and Operations, at EMA ...

March 22, 2023

CIOs have stepped into the role of digital leader and strategic advisor, according to the 2023 Global CIO Survey from Logicalis ...

March 21, 2023

Synthetic monitoring is crucial to deploy code with confidence as catching bugs with E2E tests on staging is becoming increasingly difficult. It isn't trivial to provide realistic staging systems, especially because today's apps are intertwined with many third-party APIs ...

March 20, 2023

Recent EMA field research found that ServiceOps is either an active effort or a formal initiative in 78% of the organizations represented by a global panel of 400+ IT leaders. It is relatively early but gaining momentum across industries and organizations of all sizes globally ...

March 16, 2023

Managing availability and performance within SAP environments has long been a challenge for IT teams. But as IT environments grow more complex and dynamic, and the speed of innovation in almost every industry continues to accelerate, this situation is becoming a whole lot worse ...

March 15, 2023

Harnessing the power of network-derived intelligence and insights is critical in detecting today's increasingly sophisticated security threats across hybrid and multi-cloud infrastructure, according to a new research study from IDC ...

March 14, 2023

Recent research suggests that many organizations are paying for more software than they need. If organizations are looking to reduce IT spend, leaders should take a closer look at the tools being offered to employees, as not all software is essential ...

March 13, 2023

Organizations are challenged by tool sprawl and data source overload, according to the Grafana Labs Observability Survey 2023, with 52% of respondents reporting that their companies use 6 or more observability tools, including 11% that use 16 or more.

March 09, 2023

An array of tools purport to maintain availability — the trick is sorting through the noise to find the right one. Let us discuss why availability is so important and then unpack the ROI of deploying Artificial Intelligence for IT Operations (AIOps) during an economic downturn ...