Installing Spotlight on SQL Server
If you’d like to take Spotlight on SQL Server for a spin, this post will tell you what you’ll need to do it in terms of hardware, permissions and settings.
First, you’re going to need the installer, which you can get from Spotlight on SQL Server Enterprise. Download the .exe file, along with the docs available. The trial software is the full Spotlight product with an embedded 30-day trial key. If you decide to proceed with a purchase, you can simply overwrite the trial key with a permanent one – no reinstall is necessary. During the evaluation period, we encourage you to monitor as many systems as you’d like and to distribute the Spotlight client to as many users as would like to try it out.
To give you a picture of what we’re putting together here’s, well, a picture:
This is the Spotlight on SQL Server architecture in a nutshell. Item 1 is Spotlight’s middleware, which collects and processes performance data. It should be installed on a tools server or some other non-production (physical or virtual) machine. 2 shows the SQL Server and Windows systems we’ll be monitoring – don’t worry – our data collections are agentless, so nothing gets installed here. 3 shows a SQL Server database that Spotlight will use to store historical information – you’ll need to direct us to a (non-production) instance where we can create this. It doesn’t need to be a dedicated SQL instance for us – but SQL Express won’t cut it unless you’re only monitoring a couple of systems. 4 represents Spotlight user interface clients – those go out onto each of your users’ workstations.
Above is a picture of the ports that the client uses to connect to Diagnostic Server, and those that the Diagnostic Server uses to reach out to the machines we’ll be monitoring. Most environments aren’t locked down enough for this to be a concern.
The two diagrams above are simply to illustrate that if you have a firewall between your user workstations and the machines we’ll be monitoring, the Diagnostic Server can live on either side of it, provided the necessary ports are open.
Okay so on to the requirements
Here’s what you’ll need for the various components mentioned above:
This post was written for Spotlight 11.7, so please check the Specification tab at Spotlight on SQL Server Enterprise or Release Notes for the requirements of subsequent versions.
Want to give the install a shot?
Once you have those requirements in place, an expert from Quest will be happy to step you through the installation, but if you’d like to give it a go yourself (it’s really not so bad), here’s a walk-through:
With the Spotlight installer .exe file located on either your workstation or the machine you’d like to host the Diagnostic Server on, go ahead and give it a double-click to bring up the installation wizard:
On this first screen, just choose Typical.
Spotlight will ask if you would like to install both the Diagnostic Server and the user interface client. Feel free to install the client in as many places as you want – we don’t charge per seat. When using this installer for client-only installs, be sure to un-check the Diagnostic Server once you already have one so you don’t create unnecessary duplicates. We do offer a client-only .msi installer on the download page to help with this.
Aaaahhhh Legalease. Someone put their kid through college crafting this wondrous novel (and you gotta love those ALL CAPS), so read it, love it, and recommend it to your friends.
The above is self-explanatory, anonymous and totally optional, so I’ll leave it to you.
If you’re running the installer on the machine that will be hosting Spotlight’s Diagnostic Server, choose the first option above. If not, choose the second option and tell us where to put the Diagnostic Server.
And this is, of course, where on your hard drive we’ll be putting the Diagnostic Server files.
The Diagnostic Server will run as a Windows Service under whatever account you give us here. Notice that you could just use the Local System Account, but you might want to consider the top option. If you give us a domain user account that has the necessary permissions on the systems that we will be monitoring, we can simply use this account going forward to connect to those systems, saving you from having to retype the login and password each time you add a system for us to monitor. Most users give us a service account with SQL and Windows Administrative-level permissions, but lesser permissions can be used, and are discussed in the Deployment Guide that is available to download along with the Spotlight evaluation installer.
The Spotlight installation creates three Windows User Groups (you can always find them in Windows Computer Management, and they all start with the word Spotlight). Which group a Spotlight user is in determines what they can do with Spotlight. Diagnostic Administrators can configure Spotlight and take a handful of actions on SQL Server through it (such as killing a SQL Server session). Diagnostics Users can configure Spotlight but not take SQL Server actions through it, and Read-Only Users can look but neither configure nor do SQL Server actions through their Spotlight client.
If you’d like us to automatically install patches and minor releases, let us know here.
Spotlight needs a database (called SpotlightPlaybackDatabase by default) to store historical data, so choose a non-production SQL instance where we can create this. We don’t need a dedicated SQL instance. Once you’ve chosen where to locate the playback database and the authentication that Spotlight can use to read and write to it, choose Create.
Now we’re at a screen where you’ll need to provide an account that has permission to create a database. Your account (which you’re likely running the installer with) will probably have these permissions, so after reviewing the file locations we’re using via the “Configure…” link, you can usually just hit Create.
If all is well, you should see this, and you can click OK. What else are you gonna do?!
And now you should be able to use Next to proceed.
So we’ve finished choosing the options for the installation of the Diagnostic Server, and we’re getting the Spotlight user interface client set up. Drive path is all we’ll need here.
Then we get a little review screen to make sure that we don’t need to back up and change anything, and a Start button to set it in motion…
And that’s it! Just hit Finish to get the Spotlight client up and running. Next you’ll need to connect Spotlight to the systems you would like to monitor.
Now go enjoy Spotlight on SQL Server, and please don’t hesitate to contact us here at Quest to get answers to your questions.
All of my Quest Database Performance blog posts can be found here.