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…
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…
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…
Spotlight notifies DBAs of performance issues via triggered alarm messages. More importantly, specific actions can be taken based on these alarms, by configuring the Alarm Actions feature of Spotlight. Read our blog about Alarm Actions configuration …
Throughout my career I have conversed with many IT leaders that have adopted the practice of measuring the performance of their technology assets by monitoring key performance indicators (or KPIs). Most of them will tell you that there needs to be some…
First and foremost, we always recommend testing our products in a lab environment. Test in production at your own risk. We understand you want to get real data and it makes sense but testing in production comes with risks. Am I saying you should never…
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 together. This…
One of the lesser known features of Foglight the ability to monitor log files. One of our customers has a process that collects and prints documentation required for truck movement. Before a truck can leave the loading dock, the dispatcher requests a…
Sometimes authorizing a product can be confusing with the terms that are used.
As with many Quest products, there is a two-step authorization process.
A license key or Authorization key will need to be inputted; along with its Site Message string.
These…
When monitoring databases for performance, we certainly want to understand things like CPU spikes, memory pressure, I/O latency, and the like. If we see this type of performance, the next step is to take a closer look and attempt to find out what's causing…
As we continue our navigation of Spotlight on SQL Server Enterprise and we can diagnose an alarm that triggers. Let us see what setting caused an alarm to trigger. The fact is when you start monitoring an Instance it is assigned the preset “Factory Settings…
I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data…
Just the facts! Part 2
Acknowledging Alarms in Spotlight on SQL Server Enterprise
Now that we have establish a view of the facts let’s see what we can do with them. Some on these alarms are set by default to be acknowledged before they will clear for…
When a large customer appreciation company needed to categorize their Oracle auditing data by region, SharePlex came to their rescue. They were already using SharePlex’s Change History feature to track the userid’s, timestamp, before and after data values…
A large educational Institution recently approached us with a problem. Their Student Information and Financial databases were in Oracle, and a data warehouse containing extracts from both of these used for decision making, including opening more sections…
We all tend to spend most of our time on the “turnpike” of a product’s feature set: you know, the “power” set of its features that get us to many of our endpoint destinations within the product as productively as…
It doesn’t matter what type of organization you are; small, big, public or private – everyone has a database of some description. Databases come in many forms from Microsoft Exchange, Oracle, SQL to a litany of lesser known databases. The database, for…
The Database Administration Manager communicated his need to efficiently gather and report upon growth data in the QA and Production environments. The project at hand was to build an accurate growth model for 6, 12, and 24 month time windows. He explained…
A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their…
In part one of monitoring Raspberry Pi with Foglight, I showed that the Infrastructure agent worked pretty much as expected when collecting from the Raspbian OS.
I was curious though if it exposed any metrics via snmp.
The first step was to check if snmpd…
I once attended an excellent training on giving effective software demonstrations, and the main point was simple: Don’t make your audience wait - show them the good stuff FIRST!
So here it is, in just three steps in Spotlight on SQL Server Enterprise…
I had the pleasure of presenting, along with my colleague Anat Dror, on the SQL Server 2016 Query Store at the PASS Summit last week, and the interest level was phenomenal. It's clear that this is a feature that DBA's are really eager about giving a spin…
Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.
Sometimes it…
SharePlex peer-to-peer setup
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…
I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'
I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
