• 22 Nov 2017

    Checking When DBCC CheckDB Last Checked Your DB

    I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases. This is a great use case for User-Defined Collections! As a refresher, my colleague Trent Mera wrote a great blog on this topic called User-Defined Collections (UDC). I did a post on creating a rule on the result of a user-defined collection. The difficult part is typically researching...
    • 21 Nov 2017

    SQL Server Performance Investigator – Let Me Put This Into Context!

    If you are a developer or DBA using stored procedures in SQL Server one task you might experience is trying to work out how changes to stored procedures have impacted performance. Or you might have been tasked with improving a procedure and need to know if your efforts have been successful. So in Foglight Performance Investigator you have a feature that allows you to compare one or more stored procedure’s performance...
    • 14 Nov 2017

    What are the security risks involved when uploading data to the Spotlight Cloud?

    In the Information Technology world, we often ask ourselves, "What are the security risks involved uploading data to the Cloud?" With the Spotlight Cloud services, you can now monitor all your SQL Server Connections on your mobile device or from a browser at https://www.spotlightessentials.com . Monitoring features include a Heatmap, an Alarms List, Alarm Details and the ability to Snooze, or Acknowledge alarms...
    • 7 Nov 2017

    The Juggling Act of Modern DBAs

    Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers. Didn’t sign up to be a clown? Hey, I know. I didn’t, either. But, listen, sometimes we’ve gotta adapt to the new roles in which we find ourselves as database administrators. It’s been a progression. Many of us who’ve been around...
    • 31 Oct 2017

    Be Doubly Selective with Two Foglight Report Parameterized Inputs: SQL Server Instance and Databases

    Foglight reports can be extremely useful in broadening the reach of whatever monitoring you’ve got set up. Reports can be the mechanism for delivering PDF or Excel summaries of important information on the health and capacity of your databases, etc., throughout your organization. Many of these reports might be run manually, while others are set up to run on recurring schedules. However you choose to use reports...
    • 31 Oct 2017

    Monitor Postgres Post-Haste with Foglight

    First, a brief introduction…. Formally named PostgreSQL (and pronounced /ˈpoʊstɡrɛs ˌkjuː ˈɛl/ ), it is an object-relational database management system with roots from the Ingres project at the University of California, Berkeley. PostgreSQL is open source, meaning its original source code is made available and may be modified and/or redistributed. The PostgreSQL database is growing in popularity and adoption...
    • 30 Oct 2017

    Reconsidering the idea of monitoring pre-production database instances

    It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itself is reaching critical phases of testing and quality assurance prior to roll-out. I often ask my clients how they are currently monitoring their pre-production environment and in many cases it is considered a nice-to-have instead...
    • 18 Oct 2017

    Customer Question: Setting Up ASM Monitoring with Foglight for Oracle

    Recently, I spoke with a customer who's using Foglight for Oracle to monitor their RAC instance. They were able to successfully monitor the instance, but then asked "Why don't I see any data in the ASM tab?". I think this is a great question and I thought it might be helpful to quickly talk about ASM monitoring with Foglight for Oracle. When the Oracle cartridge is enabled, you see tabs that allow...
    • 18 Oct 2017

    Quick Tip - Investigating the Past with SQL Performance Investigator

    This is something I always cover in "tips and tricks" sessions with my customers. It's an easily overlooked "extra click" that can lead to a bit of frustration, but I'm here to let you in on it. Within the Foglight UI, you can select your time range with the pulldown (1). You can either pick a pre-defined sliding timeline, or use a calendar with from/to date and times. Don't worry about...
    • 11 Oct 2017

    A General Guide to a Foglight for SQL Server Upgrade

    Understand that this is a general, high-level guide outlining the steps you should expect to take during a Foglight for SQL Server upgrade. Since environments and upgrade circumstances are often different, it is important to review and familiarize yourself with the Foglight Upgrade Guide. -> https://support.quest.com/technical-documents/foglight/5.7.5/upgrade-guide/ ** Note: If there are other cartridges installed...
    • 9 Oct 2017

    Customer Story: Using Foglight SQL PI to Detect Unauthorized User Activity

    Let me be very clear when I say that I do not advertise Foglight for Databases as a security auditing or intrusion detection solution. What is interesting to me is a scenario described by a customer working with Foglight to monitor his SQL Server databases. In a similar vein to my friend David Orlandi's post about user-level investigations using Foglight, this customer told me how he used Foglight to find that a user...
    • 9 Oct 2017

    Documenting your SQL Server inventory with Foglight

    As a DBA, you are responsible for many things, not to mention the ever changing landscape that is your database environment. Documenting the server inventory is essential as it will come in good use when it comes to planning for a migration/upgrade, preparing for newly developed code to be tested or simply just familiarizing yourself to a particular SQL Server instance. Documenting inventory also assists in helping a...
    • 6 Oct 2017

    Filter Database Visibility Using Foglight User Level Access

    Organizations are as varied as the people working within them. Some organizations have groups that are focused on specific applications. Some organizations have people responsible for specific database platforms supporting the business. How ever the organization chooses to, well, organize itself, may not be your concern. The reality, for you, may be that there are specific people who need to see a subset of the databases...
    • 2 Oct 2017

    Register Now. Free 4 Day Foglight Dev Camp 2017

    Come join Microsoft, Anvil.Works and Quest to learn how to maximize your Foglight platform during the Foglight Dev Camp 2017. Register Now !! What you will learn October 16 Virtualization and Cloud Technology Trend Hyper-V & Azure Monitoring and Migration - Co-presented with Microsoft Best practice for virtual environment monitoring, optimization, capacity planning and protection Microsoft Presents...
    • 2 Oct 2017

    Quest Customer Story: Sticking With What Works

    In an earlier blog, I wrote about a company’s success with Quest’s flagship SQL Server monitoring and diagnostics solution – Spotlight Enterprise. The blog detailed a customer success story and revealed detailed use cases explaining how this application delivery company realized value from the solution. Recently, the Director of Database Services accepted employment at a different company in a similar...
    • 2 Oct 2017

    How to configure Foglight Agent Manager to run as a daemon on a Unix Machine?

    In my last blog I explained the steps which needs to be done to get the Foglight Management Server running as a daemon on Unix machines. The same can be done for the Foglight Agent Manager too and it is much easier than for the Foglight Server. The needed scripts are located in your Agent Manager installation directory: "$FGLAM_HOME/state/default". Here you will find the scripts "fglam-init-script-installer...
    • 21 Sep 2017

    Be Ready for Tomorrow. Quest VROOM 1.2 launches and we're bringing Hybrid Cloud management to Microsoft Ignite

    What's great about being a product manager? To me, the list is long, however, today it's the release of Quest VROOM 1.2 and Foglight for Virtualization 8.7, and it's not for the normal reasons. Sure, I'm excited about a new release, i always am, they take an unbelievable amount of hard work, that aside, this release is special. The RnD team I work with has done a brilliant job; they not only met the...
    • 19 Sep 2017

    How to configure Foglight to run as a daemon on a Unix Machine?

    Once you installed Foglight on a Unix machine, you might want the Foglight processes to start/stop automatically when you reboot the machine. This is not difficult to do and the Foglight installation includes already init.d-styled scripts which can be used. As Unix machines are often customized, the scripts are model scripts and provide the basic required functionality. You might need to customize the scripts further...
    • 1 Sep 2017

    Creating your own cartridge

    To create your own cartridge, you need to install the Cartridge Builder. If you haven’t done yet, go the blog “ Installing the Cartridge Builder tool ”. If you have done it already, you can start to create your own cartridge to export custom dashboards, rules, report, … from your test server to apply it on your production server. The example below shows how to export specific rules. So first...
    • 1 Sep 2017

    Installing the Cartridge Builder tool

    Do you wonder how the Quest technical stuff creates cartridge files to hand over customized dashboard, reports or agents to you? Well, everyone can do that, this is no rocket science. And best is, you have all what you need available in your Foglight installation already. No need to download additional files! The needed tool is the Cartridge Builder (previously known as FglIDE) which is designed to extract custom dashboards...
    • 28 Aug 2017

    Spotlight Enterprise Migration

    System administrators find themselves frequently applying required updates to their server hardware, operating system, security packages, or disaster recovery processes in order to maintain system and data integrity. Such enterprise modifications occasionally require updates to the server applications within the system. Consequently, administrators have to address the migration of these tools as well. The good news...
    • 17 Aug 2017

    Combat GDPR with Quest's Microsoft Platform Management Tools

    As we become ever more reliant on technology we are seeing more and more threats to our data. These threats are not only coming from the “bad guys” out there knows as hackers like Hank . They can also come from malicious employee who feel hard done by and want to get their own back. The negligent new IT admin making changes to their Active Directory without thinking of the repercussions to the business, followed...
    • 8 Aug 2017

    Monitoring Workload – Heads or Tails, it's two sides of the same coin

    I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you looking to understand the root cause of compute resource consumption such as CPU, I/O, memory and timing? Or are you looking to get to the bottom of a specific set of wait events that have been present...
    • 1 Aug 2017

    "Foglight Skills 101” Webcast Series

    We recently started this webcast series directed specifically at existing Foglight administrators and users within your organization. We call the series, “Foglight Skills 101.” We present topics that have a broad interest among administrators and users – people who use Foglight often, but who might need some help getting up to speed with an important feature/function of Foglight. This series takes...
    • 1 Aug 2017

    Using tokens for Foglight dashboard access

    Some users only require simple access to Foglight dashboards, ideally being able to skip the logon step. In Foglight Server version 5.7.5.7, the user security option of an auth token was introduced. My colleague @Beam.Liu wrote an excellent blog on the subject . Start by going to dashboard that you wish to share via URL. From the right hand drawer select Properties->Link to this Page. From the dialog note the...