Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Mtools is a third party tool suite that contains very easy to use utilities for troubleshooting or just gathering general knowledge about your MongoDB instance. These tools can be crucial when performance tuning, running a health check or examining log files. You can...
Sometimes you may notice that everything in MongoDB is running fine, then you suddenly have performance issues that come up out of nowhere. There can be several reasons why this happens but I am going to cover a few of the common ones here. Long-running queries Index...
There are many reasons why your database queries can start to lag or experience throughput issues. In this article I will do troubleshooting on two common issues with slow queries and a way to fix each one. When doing any performance tuning on a database it's...
MongoDB ServerStatus is the main command used to produce a huge document containing important metrics and information about your database. When performing a health check, there are several important keys that you'll want to be aware of inside serverStatus. The output...
At XTIVIA, we have encountered the MySQL Error 1114, "table is full" on quite a few occasions. The description for the error is usually misleading as it implies that a table has reached or exceeded a maximum set limitation. Tables utilizing the InnoDB storage engine...
SQL Error 18456 is likely the most common error one will encounter using SQL Server. Error 18546 isn’t only commonplace, but also ambiguous. Generally, Error: 18456 is a result of a login failure. Follow the steps below to try and resolve the issue. Are you connecting...
Obtain the Oracle client binaries from Oracles site http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html Click on "Accept License Agreement" For 32 bit: Look for "Oracle Database Client (12.1.0.2.0) for...
I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
Replicating Indexed Views as tables, instead of replicating all base tables and then creating an indexed view against those base tables, allows for a smaller subset of data to be replicated over. If you replicate base tables and then create an indexed view,...
The Oracle ORA-01017: Invalid Username/Password; Logon Denied is an error that comes up pretty frequently it can be caused by several things, though most of the time it's simply just the wrong password being used. One thing that we should check if we're pretty sure we...