by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #10: Storage For the final post in the top 10 items that influence the performance...
by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 9 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #9: Automatically Shrinking Your Database This is a topic that has been written...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
by XTIVIA | Jan 7, 2016 | Blog, Databases
DB2’s Self-Tuning Memory Manager (STMM) was introduced in DB2 9.1. The default for new, single-partition databases was ON from the beginning. What is STMM? DB2’s Self-Tuning Memory Manager can allocate and change the size of specific memory areas including...
by XTIVIA | Jan 6, 2016 | Blog, Data Management, Databases
Ran into an issue today while installing a multi-user EBS Suite install using the latest startCD50. Thought I would share this to help some others if they run into the same problem. The error: Applying one-off patches Using...
by XTIVIA | Jan 5, 2016 | Blog, Data Management, Databases
Tip # 8 – Default TempDB Settings Top 10 Tips for SQL Server Performance and Resiliency This article is part 8 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common...
by XTIVIA | Dec 17, 2015 | Blog, Databases
Memory usage can be an issue for DB2 whether a server has 2 GB or 2 TB of memory. There can be issues with making DB2 use all of the memory, and there can be issues with DB2 causing paging or even kernel panics. Because of this, it is important to understand how much...
by XTIVIA | Dec 10, 2015 | Blog, Databases
Statistics are the most basic element of DB2 performance. One of the first questions any consultant or support person will (should!) ask you when you come to them with a query performance problem is when the last runstats was run for the tables involved. What are...
by XTIVIA | Dec 9, 2015 | Blog, Data Management, Databases
Symptom: Very recently, using SqlDeveloper 4 Data Modeler I tried to pull and import schema object data (i.e tables) to create an Entity Relationship Diagram ERD from an Oracle database. After carefully going through the required steps, I kicked off the import...
by XTIVIA | Oct 28, 2015 | Blog, Data Management, Databases
To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is...
