by Matt Wolinski | Feb 25, 2015 | Blog, Databases, Enterprise Infrastructure
I was recently working on a client’s site and ran into the following warning: WARNING: You are running on a NUMA machine. We suggest launching mongod like this to avoid performance problems: numactl –interleave=all mongod [other options] This warning shows...
by XTIVIA | Nov 25, 2014 | Blog, Data Management, Databases
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL...
by XTIVIA | Aug 21, 2014 | Blog, Data Management, Databases
Are you testing your database backups, If so how? Sure there are a couple options that you can use to help validate backups but does this mean you are 100% sure, without a doubt, that it can be restored? Have you ever seen a backup file not restore? Recently I was...
by Barrie Shaw | Apr 17, 2013 | Blog, Databases
One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol. They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the...
by XTIVIA | Sep 21, 2011 | Blog, Databases
Assuming you don’t know anything literally about the Oracle Real Application Clusters (RAC) environment, You should start with: 1. Database version, O/S version, how many nodes, tns names, listener information? 2. Database Size, Storage architecture, raid/ASM...