• 24 Jul 2017

    Logging in Litespeed

    Although we don't like to think about our backups and restores going wrong, there are times when things just sometimes don't work as planned, and if it's not something that is easy to troubleshoot, you may find yourself raising a support case to help fix the issue. One of the things that is most helpful to assist with troubleshooting, is an ' Advanced Engine Log '. This is a verbose log file, which...
    • 24 Jul 2017

    “Pimp Your Ride” with Foglight Custom Dashboards

    Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was a television serie...
    • 21 Jul 2017

    SharePlex and Jim Clark, the best of the best!

    For those of you who don’t know me. I love racing. I love Formula 1 racing and even more so I love the “Golden Age” of Formula 1 racing before all the electronics and ground effects. Back when it was driver against driver and you had to know how to drift through a turn at full throttle. Jim Clark was one of those drivers. He was born with the natural ability to control a race car through any type of...
    • 14 Jul 2017

    Meet Our Experts! The Voices behind @QuestExperts on Twitter: Aaron Mares

    We are lucky enough to work with a number of extremely talented and passionate people. Some of our coworkers have been here for a number of years and have some great stories to tell. We wanted to use this interview as an introduction to one such individual – Aaron Mares. Tell us a little about yourself: I currently support Spotlight as an Enterprise Tech Support Advisor. I am a firm believer that hard work...
    • 11 Jul 2017

    How DevOps can benefit from Continuous Monitoring of Application Databases

    Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance slowdowns or outages. Being proactive and resolving issues quickly in production requires the collaboration of the operations, DBA and development teams. The Emergence of DevOps Over the years a lot has changed when it...
    • 3 Jul 2017

    The Fourth V

    The key characteristics of Big Data are commonly known as “the 3 V’s”: Volume , Velocity , and Variety . Volume for the amount of data stored to process; Velocity for the tremendous pace required to generate, store and analyze data; and Variety for the many sources of data generated as well as the disparity of formats. There are “2 V’s” that have become incorporated into the literature...
    • 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...
    • 23 Jun 2017

    SharePlex Optimistic Commit Explained

    So the other day, as I was using a taxi to get to the airport for a flight. I was watching all the traffic on the freeway and it got me thinking about SharePlex’s optimistic commit feature and a taxi are similar. How can SharePlex and a taxi have anything in common you ask? Well they are both responsible for moving something from one point to another with as little latency or delay as possible. Optimistic commit...
    • 12 Jun 2017

    New Chapter: SharePlex 9.0 SQL Server Capture

    Having worked with SharePlex for the last seventeen years, it is exciting to see SharePlex capture can now replicate data from non-Oracle database SQL Server for the first time. It is very easy to set up and looks and feels just like SharePlex for Oracle. The current 9.0 release supports SQL Server 2012, SQL Server 2014 and SQL Server 2016 on both source and target running on windows 2012. You can replicate from on...
    • 6 Jun 2017

    Let's test SQL Server Optimal Backup Settings with LiteSpeed!

    Let’s compare these two different conversations. Conversation 1: Conversation 2: Does this situation ring you a bell? Do not worry! Backup Analyser is here to help you even though nobody answers your questions .With just a few clicks you can have a nice graph and an Excel file with that information! Let’s start! First open Backup Analyser.You can open it from the Database menu or selecting a database...
    • 30 May 2017

    Join the open-source movement with Toad Edge Preview Release

    MySQL is great. The cost benefits? Also great. What’s not so great? Struggling to learn a new database platform. Oh, yeah. We hear your collective groan. You’re already juggling a million more responsibilities than you had when you started out, and now you’ve got to figure out yet another new technology? There’s got to be a better way. Maybe you’re already muddling through MySQL on...
    • 22 May 2017

    Restore from Amazon S3 with LiteSpeed

    Today I am going to talk about …hold on… where is my database? WHERE IS MY DATABASE? It was there 5 minutes ago!! Where did it go? I spent a lot of time setting up the database for this blog. Ok! Do not panic! Do I have a backup? Oh yes! I just run a backup to Amazon S3 in my previous blog so ...relax...and let’s restore it. First let’s open the Restore Wizard: Then select the type...
    • 17 May 2017

    Backup to Amazon S3 with LiteSpeed

    Do you know that LiteSpeed supports backup and restore directly to and from Microsoft Azure Blob Storage and the Amazon S3 (Simple Storage Service)? And with directly I mean exactly this: LiteSpeed does not use any temporary local storage for backups at all ...the backups just go directly to the cloud! In this blog we are going to focus on Amazon S3. Once you have your Amazon S3 account, all you need to do is to...
    • 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...
    • 9 May 2017

    Agile Development: Setting up Team Coding with VCS integration

    Are you using a version control system (VCS) and want to know how to access it from Toad to simplify check-out/check-in? This video shows how to install and configure Team Coding to work with a VCS provider as well as how to define and manage your pr...
    • 4 May 2017

    Toad Allows You to Do More and Not Just Try

    Yoda’s Jedi IT cousin Toada agrees “Do or do not, there is no try!”. It today’s climate of downsizing, staff reductions and the explosion of data sources and data volumes you must be able to do and do more and just trying without the right tools will lead to failure. “Seek help, you must! With less do more. Yes, hmmm” says Toada Automate, Optimize, Document and Diagnose. “Problems...
    • 1 May 2017

    Benchmark Factory – Performance Testing is Critical !!

    One time when I was a little boy, I was driving with my dad and we went over a bridge and there was a sign that read “Weight Limit 10 Tons”. I asked my dad how they figure out how much load the bridge can handle. My dad, being a dad, answered, “Well they build the bridge and then keep driving bigger and bigger trucks over it until it collapses. They then weigh the truck and rebuild the bridge and...
    • 1 May 2017

    Use Compare and Repair to Keep SharePlex Replication From the Dark Side

    "There has been great disturbance in the Force". In the SharePlex galaxy, we call that "out of sync". In a recent blog, SharePlex Jedi Mark Kurtz introduced us to the SharePlex Compare and Repair commands . Here are some additional best practices that that you can use to help bring balance back to the Force in your galaxy. Make Frequent Use of Compare While Post does a great job of detecting...
    • 1 May 2017

    Considerations when projecting database growth using Foglight

    Every now and then I run into a conversation with my clients around planning capacity for anticipated database growth. Although there are straight forward methods for calculating data/log file and object growth rates from catalogued views in the database which lead to linear predictions, there are several considerations that must be taken to make this exercise more appropriate in the real-world. Figure 1 – Instance...
    • 19 Apr 2017

    Oracle Yacht Fund Capsizing Your IT Budget?

    We’re throwing you a lifesaver – catch onto the more affordable OEM alternative. Help! I can’t afford Diagnostics and Tuning packs for performance monitoring with Oracle® Enterprise Manager. Really? You mean you’re not c...
    • 18 Apr 2017

    It only takes a minute to vote!! - DBTA Readers' Choice Awards - Vote for your favorite Quest Products!

    Hello all Information Management product users! Voting is now open for the 2017 DBTA Readers' Choice Awards. The DBTA Readers' Choice Awards Winners will be showcased in a special section on the DBTA website and in the August 2017 edition of Database Trends and Applications magazine. A number of Information Management solutions are contenders in a variety of categories. Unlike other awards programs that...
    • 17 Apr 2017

    Monitoring AWS EC2 Windows Instance with Foglight InfraStructure Cartridge (Host Monitoring)

    The other day I was speaking to a customer about their growth strategy and planning on database management and infrastructure. One of the topic that I really liked is how companies get very creative and innovative. One of the strong drive for them is to adopt the latest technologies, and to transition with minimal disruption internally. They were planning to move some or all of their infrastructure into Amazon’s...
    • 6 Apr 2017

    Exception handling by SharePlex when dealing with out of sync?

    The conventional methodology followed by SharePlex and most other replication solutions is to ignore out of sync DML within a transaction while applying rest of the successful DML to the target database. A transaction may span one or more objects, each having one or more rows, or DML. When posting that transaction, if any row runs into out of sync conditions, the default behavior is to simply discard that row, record...
    • 6 Apr 2017

    Finding your Heavy-Hitting SQL Statements with Foglight for Databases

    A Brief Walk-Through of SQL Performance Investigator In a previous Foglight for Databases / SQL Server blog post, I provided a guide for navigating your database servers’ performance metrics in real-time . That post showed you how to identify your SQL Servers’ current problem areas and then quickly understand the related statements, effected objects and/or root causes. This post will focus on the part...
    • 31 Mar 2017

    Log Shipping in Litespeed v8.5

    Log shipping is a critical feature for disaster recovery. It allows you to automate the backing up of a database (the publisher) and restoring its transaction logs on one or more standby databases (the subscribers). The process runs automatically throughout the day at the interval you specify, which creates synchronized databases. LiteSpeed for SQL Server provides flexible backup options for log shipping and allows...