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

July 28, 2021

Business leaders are in the unique position of having immediate access to huge amounts of data in today's smartphone and laptop-dominated world. They are also under pressure to make data-driven decisions and mobile business intelligence can one of the most valuable decision making tools in their arsenal ...

July 27, 2021

Unlike some AI initiatives, AIOps doesn't always necessitate the use of a data scientist, so don't let hiring expenses put your AIOps initiatives on hold. It is always nice to have IT team members with AI skills, but this becomes less critical as more intelligent solutions come into prominence that offer AIOps features out of the box, a readily deployable option for IT ...

July 26, 2021

AIOps is rapidly becoming a de-facto option for enterprises' IT strategies, with nearly immeasurable benefits to be provided. However, AIOps is still a relatively new discipline and misconceptions surrounding the technology's capabilities and uses have caused bottlenecks and roadblocks in its widespread adoption. So, what should organizations expect from AIOps? How can organizations that want to digitally transform their IT pursue AIOps for maximum benefit? ...

July 22, 2021

In response to the global pandemic, companies have given their workforce the tools they need to work remote. And research shows it has increased their engagement and productivity. But these gains are on the brink of being wiped out. According to a new study from Citrix Systems, Inc., employees feel they've been given too many tools and not enough efficient ways to execute. And it's hindering their ability to get things done ...

July 21, 2021

The third installment of Aptum's four-part Cloud Impact Study, A Bright Forecast on Cloud, presents data showing the benefits organizations gain from cloud computing, as well as mistakes to avoid during migration. As organizations migrate workloads to different cloud platforms, they often run into unexpected challenges due to a lack of proactive planning. Here are a few key findings from Part 3 of the Cloud Impact Study ...

July 20, 2021

Currently, (and most likely well into the future) the overwhelming majority of organizations still need to monitor and maintain enterprise applications. Moreover, where these are complex systems developed, debugged and refined over years, often decades, around a business's core processes, there can also be very strong practical arguments for viewing them as classics. They can offer a valuable legacy, one best left where it is, doing what it does, how it always has done ...

July 19, 2021

Anti-patterns involve realizing a problem and implementing a non-optimal solution that is broadly embraced as the go-to method for solving that problem. This solution sounds good in theory, but for one reason or another it is not the best means of solving the problem. Anti-patterns are common across IT as well, especially around application monitoring and observability. One that is particularly prevalent is in response to the increasing complexity of cloud-native infrastructure and applications ...

July 15, 2021

The introduction of the latest technology — such as AI and machine learning — can be seen as a way for organizations to accelerate growth, increase efficiency, and improve customer service. However, the truth is that the technology alone will do little to deliver on these business outcomes. AI for IT operations (AIOps) is one area where the application of technology, if not matched with organizational maturity readiness, will fail to deliver all the promised benefits ...

July 14, 2021

SREs that fail to deliver customer value run the risk of being stuck in an operational toil rut. Conversely, businesses failing to recognize the bi-modal nature and importance of SRE activities run the risk of losing talented employees and their competitive edge ...

July 13, 2021

As part of digital transformation initiatives, IT teams are quickly adopting AIOps solutions to accommodate a new multifaceted infrastructure. However, there are still several roadblocks IT leaders must overcome when adopting AIOps — namely, understanding how to showcase ROI and changing their team's cultural mindset around adopting a new strategy ...