Quest software extends BI capabilities

BANGALORE, INDIA: Quest Software, Inc. has announced two significant product releases in the SQL Server performance management space, at PASS Summit in Seattle.

Tips to audit SQL server databases

The newest release of Spotlight on SQL Server Enterprise, now featuring business intelligence (BI) monitoring, coupled with the debut of Foglight for SQL Server, enables database administrators (DBAs) to proactively detect, diagnose and resolve SQL Server performance issues.  

As organizations implement more of SQL Server’s BI capabilities, they are finding that their traditional monitoring techniques do not handle the underlying BI subsystems, such as SQL Server Analysis Services (SSAS) said the press release.

Using DDL triggers in SQL server

“With the enhancements Microsoft has made in the business intelligence space, SSAS is quickly becoming a compelling choice and critical part of the enterprise” said Ari Weil, product manager, SQL Server performance products, Quest Software.

“Spotlight has always been the DBA’s solution for an all-encompassing view of the database environment and the surrounding enterprise, so it made sense to fully integrate SSAS diagnostics into the same solution. The simplicity and intuitiveness of the data presentation help overcome the steep learning curve DBAs face with SSAS,” added Weil.

Offsite server backup for MS SQL Server

Spotlight on SQL Server Enterprise also offers automated CPU diagnosis, which affords users detailed visibility into CPU conditions from both SQL Server and Windows perspectives within a single location, empowering database and systems administrators to troubleshoot issues collaboratively.

The new version also integrates direct links to Quest’s SQLServerPedia portal from dashboard, giving users access to detailed information on SQL Server performance issues via expert blogs, wiki posts, video tutorials, and more.

Quest will also introduce Foglight for SQL Server, a web-based monitoring and diagnostic solution based on the Foglight framework. Foglight for SQL Server offers 100 percent remote monitoring with highly optimized collections, providing users with a complete, solution for monitoring their entire SQL Server infrastructure – all with fast, easy installation.

By leveraging the proven power of Spotlight on SQL Server’s data collection framework and metric presentation, Foglight for SQL Server includes built-in dashboards, workflows and alarms.