• 17 Jan 2018

    Archive, Rapid Recovery Style

    First things first. What is data archiving? Simply put, it’s a process that takes data that’s no longer in use or has lost its relevance and moves it to lesser expensive storage such as magnetic tape or cheap disk storage. Archived data is usually in a compressed format and may also include deduplication. Archived data can then be accessed at a later date if needed but recovery times are typically quite lengthy...
    • 8 Nov 2017

    Customer Conversation: Backup Escalation in Litespeed for SQL Server

    A customer recently asked me to clarify the option "Enable Backup Escalation" in Litespeed for SQL Server. The customer has been using Litespeed for a while so I was a bit surprised the question was asked. When we spoke further, I learned they had built their own full and differential backup strategy rather than letting Litespeed handle it for them. Wait, you didn't know Litespeed can manage a full and differential...
    • 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...
    • 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...
    • 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...
    • 26 Jun 2017

    Backup to Azure with LiteSpeed

    In a previous blog, we learnt how to backup to Amazon S3 with LiteSpeed . Let's see now how to backup directly to Azure. Remember that LiteSpeed does not use any temporary local storage for backups at all ...the backups just go directly to the cloud! First that all let's start registering our account with LiteSpeed. Since in the previous blog we used the "Add Cloud Account" Wizard , let's use the...
    • 31 May 2017

    Quest Customer Story: Foglight Performance Investigator Use Cases shared from the trenches

    As a Sales Engineer for the Database Performance Monitoring team, one of the more rewarding aspects of my role is to learn about specific ways that our customers are leveraging Quest solutions. With that in mind, I am a firm believer that if something proves useful to one user or team, it's a good bet it'll be helpful to many other end-users as well. That, and my mom always reminded me to share. So, here we go...
    • 15 May 2017

    Overview of Foglight Management Server and Agent Manager upgrades

    How would you like to have a quick reference point for your Foglight Management Server (FMS) or Foglight Agent Manager (FglAm) upgrades? This article is designed to help you determine the best steps to take to upgrade your type of FMS and FglAm. Hyperlinks are included for specific topics which direct to the area of interest in the Upgrade Guide. FMS Types Standalone FMS - Typical installation FMS HA - High...
    • 8 Mar 2017

    Automate Active Directory Health Checks with the New Release of Active Administrator

    When Active Directory (AD) goes down or is unavailable for any stretch of time, consequences can be severe. AD issues can lead to end user frustration, loss of productivity, and significant burden on the IT and help desk staff while they attempt to identify and fix the issue. One would think since AD is such a business-critical system that there would be plenty of easy-to-use tools and methods available for keeping AD...
    • 1 Mar 2017

    Toad Turnpike: Tuning Database Object Access Patterns

    Robbing Peter to Pay Paul on the Database Performance Teeter-Totter: Part 2 of 2 In the previous post, Robbing Peter to Pay Paul , a DBA named "Alex" outlined what happened when he introduced a new index to speed up one user’s ...
    • 27 Feb 2017

    Use SharePlex to Replicate Oracle Data to Amazon RDS

    In a previous blog we introduced you to SharePlex 8.6.6, which is certified to replicate data to Amazon and Azure Cloud Databases . In this blog, we’ll show you how easy it is to set up replication from an Oracle database , either on-...
    • 14 Feb 2017

    Getting Organized Using Toad

    Toad has so many features and RDBMS' have so many objects it can sometimes be difficult to mesh them together to accomplish the tasks at hand. Wouldn't it be great if there were ways to have these organized in the way you need vs ...
    • 13 Feb 2017

    Bringing Order to Chaos

    I was working with a new customer and showing him some of the features of Foglight for Virtualization, Enterprise Edition . I was going through the Capacity Manager section and showing him how he can use it to help manage the growth of his virtualize...
    • 6 Feb 2017

    SharePlex Can Help You Move Your Databases To The Cloud

    Almost every business is at least considering moving some of their IT workload to “the cloud” for any number of reasons. Databases are often a major component of this workload. SharePlex 8.6.6, certified for Cloud ...
    • 6 Feb 2017

    SharePlex Tuning 101 - A Journey, Not A Destination

    In recent SharePlex blogs , my colleagues and I have discussed using the Analyze Config command to help gather information to tune SharePlex , and the importance of tuning the target database. In this blog, I’ll attempt to put it all togeth...
    • 1 Feb 2017

    The Art of Rapid Recovery: Microsoft Cloud

    It was said by Sun Tzu that “the greatest victory is that which requires no battle” Wise words that we can correlate to data loss and data outages. With the prevalence of ransom-ware and the potential for natural or unnatural disas...
    • 31 Jan 2017

    Toad Turnpike: Tuning Database Object Access Patterns

    Robbing Peter to Pay Paul on the Database Performance Teeter-Totter: Part 1 of 2 ... Within the previous month alone, I’ve had three different customers ask me the same identical question: “Does Quest have a solution that re...
    • 31 Jan 2017

    How to Resolve Backlogs in SharePlex Using Named Post Queues

    I’m sure we’ve all gone to an amusement park like Disneyland or Knots Berry Farm. We all love the thrill and excitement the rides give us. What we all hate though are the lines we have to wait in for each ride....
    • 30 Jan 2017

    Monitoring IT Operations in the Datacenter

    The question for those in data center operations management is not which tool but rather what combination of tools will provide the right metrics at the right time. Quest solutions are part of the larger IT ecosystem and thus our products tend to integrate well with other complimentary and even competitive solutions. Foglight is one such product. It is often times made the record of truth for enterprise performance monitoring...
    • 30 Jan 2017

    How Rapid Recovery is like Liam Neeson

    The other day I was watching the movie Taken, and as I was watching it I came to the part where Liam Neeson says his line, “If you are looking for ransom, I can tell you I don't have money. But what I do have are a very particular set of sk...
    • 29 Jan 2017

    Setting up Replication in Rapid Recovery

    One of the core tenants for a robust backup and recovery infrastructure is replication of data. If you have a major disaster, properly replicated backups will save the day and potentially your company. In this blog, I will detail how you set up repli...
    • 26 Jan 2017

    Spotlight on SQL Server for New or Non-DBAs

    If you're in charge of SQL Server, my experience as an SC tells me that there's about a 50% chance that SQL Server administration is only one of the roles you play in your organization. It seems that there is a bit of a shortage of DBAs in the market, and that many companies don't want to hire someone to wear solely the DBA hat anyway. I've seen Network Admins, Developers and others who, having been given...
    • 26 Jan 2017

    Space Manager w/LiveReorg is now 64 bit!

    Beginning with release 8.3, Space Manager is now available in a 64-bit version, as well as a 32-bit version. Using the 64-bit version of Space Manager takes advantage of performance benefits in a 64-bit environment. That means better memory management for one. Installation is simple, just select the 64-bit set up program (installer) from the download site and run it on your system. Make sure the bitness/architecture...
    • 26 Jan 2017

    Spotlighting the 3:00AM Call

    As a former database administrator , one of my biggest concerns was getting a call in the middle of the night. Sometimes the call would be a system alarm going off, but most of the time it was a member from an overseas we supported. There is nothing l...
    • 26 Jan 2017

    Automating Your Retention Policy with Rapid Recovery

    IT staffs are pinched for time. Many staffs in this day and age are expected to do more with less. For Quest one of the major tenets across all of our products is we want to save the IT staff time. Time is money and many organizations don’t hav...