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.
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum telling them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for AlwaysOn...
There may be a time where you install security patch MS15-058, and it shows that it was successfully installed, but the version does not change in SQL. The patch actually failed to install. Follow these instructions get to MS15-058 installed successfully and have the...
Have you ever applied a patch to find that the server or service does not start after it was applied? There is nothing worse than working in a maintenance window trying to get services back up as quickly as possible when suddenly SQL will not start. Knowing that your...
This is a high-level description of the different High Availability Offerings in SQL Server 2016, meant to give a general idea of what is offered and the limitations for each offering. AlwaysOn High Availability Groups When most people use the terms AlwaysOn they are...
While there are many configuration options in SQL Server that can help tweak the performance when RAM or CPU is causing a slowdown, when the disk is the culprit, your options are much more limited. Assuming that best practices are followed in regards to file locations...
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...