Back to Top

Spotlight on SQL Server Enterprise - license + 1 Year Maintenance - 1 monit

Mfg. Part: SEC-SPO-PB | CDW Part: 3212416 | UNSPSC: 43232804
$1,495.00SAVE $109.01
$1,385.99Advertised Price
Lease Option ($40.89 /month) Lease Availability

Have leasing questions? Let us know how can we help.

Note: Leasing is available to businesses only. Leasing is not available to individuals.
Mon-Fri 7am-7:30pm CT
Availability:In Stock
Ships today if ordered within 6 hrs 14 mins
  • License + 1 Year Maintenance
  • 1 monitored instance
  • Win
View More
Product Overview
Main Features
  • License + 1 Year Maintenance
  • 1 monitored instance
  • Win
Organizations depend on business intelligence systems and processes to provide decision-makers with the information they need to make smart choices. DBAs are tasked with ensuring that SQL Server Analysis Services (SSAS) is ready to deliver that information quickly and efficiently. Having an operational performance view of your SQL Server is critical to ensuring that your multidimensional structures, reports and data mining processes are ready and capable of handling the demanding needs of your business. But how do you monitor and optimize SSAS performance to get the best business intelligence?

Spotlight on SQL Server Enterprise gives you the insight you need by providing a single, intuitive interface that shows SSAS performance and processing at a glance. The solution instantly alerts you to performance bottlenecks detected at the server level, and it provides metric-sensitive alarms to point you to the root causes of issues. For example, Spotlight on SQL Server Enterprise identifies bottlenecks related to memory and storage systems, aggregation usage and processing tasks competing for the same resources.

Plus, in addition to support for SSAS, the solution also provides monitoring, alerting, automation and reporting for Windows and SQL Server's Relational Engine - all in one product. This means you have a single installation process, a unified infrastructure, and cohesive workflows between the various components of your SQL Server environment. As a result, your organization benefits from a lower total cost of ownership and a higher return on your investment.

Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: Windows

Bundled Support: 1 Year Maintenance
License Category: License
License Qty: 1 monitored instance
License Type: License
License Validation Period: 1 year

Support Details Full Contract Period: 1 year

Brand: Quest
Compatibility: PC
Manufacturer: Quest Software
Model: on SQL Server Enterprise
Packaged Quantity: 1
Product Line: Spotlight

Service & Support
Type: New releases update

Service & Support Details
Service Type: New releases update

Service Type: Web support

Service Availability (Days a Week): Monday-Sunday
Service Availability (Hours a Day): 24 hours a day
Service Type: Web knowledge base access

Service Availability (Days a Week): Monday-Friday
Service Availability (Hours a Day): 12 hours a day
Service Type: Phone consulting

Service Type: E-mail consulting

Category: Networking applications
Installation Type: Locally installed
Subcategory: Network - monitoring & performance management

Product Reviews
Spotlight on SQL Server Enterprise - license is rated 4.0 out of 5 by 1.
Rated 4 out of 5 by from The ability to fine-tune different alert levels, and to have it page the appropriate group for critical issues makes this product a vital part of our support structure. Valuable Features:The alerting process, ease of setup and configuration are certainly valuable to us, as they keep us informed of the environment when things are running well – but the real strength of SpotLight w/PA is the ability to go back in time to find exactly what was causing an issue (or the pre-emptively highlight anomalies that may become issues in the future). The ability to fine-tune different alert levels, and to have it page the appropriate group for critical issues makes this product a vital part of our support structure.Improvements to My Organization:The IT and Engineer divisions rely upon the product to analyze existing issues, and QA code changes. This application suite provides us with three different focus points: Customer Support uses it to maintain awareness of current systems-state. Information Technology uses it to understand and track system-level issues, as well as capacity planning, growth forecasting, and 24 hour text alerts of Critical issues. The Engineering team uses it to review impacts of code-changes, and for performance-tuning. Spotlight is the Jenkon single-point monitoring tool.Room for Improvement:Jenkon is a Microsoft Partner, and we use Hyper-V as our virtualization base. This version of Spotlight provides additional information about “Virtualization Overhead”, but only for VMware (not Hyper-V).Also, a wonderful “extra” of the Spotlight environment, was the ability to monitor, troubleshoot, and receive alarms directly to our mobile devices – via the Mobile Spotlight App. Unfortunately, the App broke when we upgraded from version 9 to version 10.We have just participated in the live demonstration/training of the newest version of Spotlight (version 11.5). The good news is that both of these enhancements have been addressed in the latest version.Use of Solution:We started using the Spotlight/PA tools in August of 2013. The original version that we installed was 9.5.0.Deployment Issues:The initial installation on our diagnostics server was very straightforward. Basic configuration was very simple, and even the more complex settings that can be set – were described in detail in the documentation.Stability Issues:The application was extremely stable and we had experienced no issues whatsoever, until we had to upgrade from version 9 to support Server 2012-R2. This issue was related to SQL 2008-R2, which required the urgent rebooting of the instance (Which was not a good thing to do with Production servers). We lost visibility of these servers from the new version of Spotlight until the reboot was performedScalability Issues:We had no issues scaling it for our needs.Technical Support:The issue listed above has been the only time we’ve needed to have support help. They were unaware of the SQL 2008-R2 issue, and have verified that a similar issue does not exist in the new version. They have offered to be “on the line” when we perform this latest upgrade – to ensure our comfort level.Previous Solutions:Previously, we were using Confio Ignite to monitor our systems. This product was very reliable, but considerably more complex to setup and configure. Alerting functions were limited, and there was no mobile app available.Initial Setup:The initial setup was straightforward, as this is a clientless install. The application is installed on a Diagnostics Server, with a SQL server back-end. We even use the same server to monitor multiple domains (untrusted). SQL DBAs can also configure specific monitoring/analytics that are more tailored to the details that they need.Implementation Team:The installation was performed by the IT department, and was simple. However, we recommend that a vendor team be involved with any upgrades to ensure compatibilities and assist with any unknown issues that arise.ROI:The Return on Investment for Spotlight is against soft-costs, generally speaking. It has drastically cut down on issue response-time, resolution-time, and development costs (in terms of shorter development/QA times). Work with your vendor to discuss your long-term goals for this product, and set up a test/demo environment first to see the value-add for your environment.Other Advice:The new version has all of the enhancements that we were hoping for. We highly recommend this to any company that relies upon their SQL DB environments for critical data, and cannot afford downtime (or wish to mitigate issues, and shorten resolution times).Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2016-04-11
  • y_2018, m_1, d_11, h_9
  • bvseo_bulk, prod_bvrr, vn_bulk_2.0.3
  • cp_1, bvpage1
  • co_hasreviews, tv_0, tr_1
  • loc_en_US, sid_3212416, prod, sort_[SortEntry(order=SUBMISSION_TIME, direction=DESCENDING), SortEntry(order=FEATURED, direction=DESCENDING)]
  • clientName_cdw
Adding to Cart...
1/17/2018 9:46:59 AM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.


Something went wrong.

Please try again later.