Most Popular Databases

Using Oracle 12c Exalogic Elastic Cloud

You can monitor various aspects of Exalogic Elastic Cloud from OEM Cloud Control 12c. Note that the Exalogic Elastic Cloud is considered a system target, not a group target. Following are the different types of Exalogic Elastic cloud targets you can manage from OEM Cloud Control 12c.   Application deployments WebLogic domains IB switch Coherence […]

Read More

Oracle EM Cloud Control 12c and Change Management

Change management is an important part of lifecycle management. In previous releases of OEM Grid Control this capability was part of the Change Management Pack. This is now part of the Lifecycle Management Pack. Change management allows you to track and report changes that have been made to targets under management of Cloud Control. This […]

Read More

Overview of Oracle VM

In recent years, virtualization has changed the way we look at computing. Instead of using many different computer systems for different tasks, with virtualization, we can use a single system to host many applications. Not only has virtualization increased in popularity, but it has also sparked new hardware CPU innovation, including Intel VT-x and AMD-V […]

Read More

Oracle EM Cloud Control 12c and Compliance Management

Oracle Enterprise Manager Cloud Control Compliance Management has two separate pieces: monitoring of compliance to business best practices and monitoring of real-time configuration changes. Monitoring of compliance to business best practices is a process where the system is regularly analyzed and deviations from compliance to business best practices are reported. This allows for decisions to […]

Read More

Middleware Diagnostics with Oracle 12c Cloud Control

Although there’s no “one size fits all” diagnostic method for all your performance issues, following is the general tuning approach recommended by Oracle to tackle complex middleware application performance problems. 5 Steps recommended by Oracle: 1.   First, rule out all non-middleware infrastructure issues causing the performance problem. 2.   Narrow down the scope of the problem by ascertaining […]

Read More

Oracle EM Cloud Control 12c and Configuration Management

Oracle Enterprise Manager Cloud Control is constantly taking inventory of the configuration of the targets that it is monitoring. This information is saved and available for instant access and comparison. Information is collected on database configuration, host configuration, middleware, storage, and so on. Cloud Control can then be used to search for specific configuration information, […]

Read More

Backups just got better with SQL Server 2016

Every release of SQL Server brings many new capabilities–and opportunities for something new to learn. SQL Server 2016 is nothing new in this regards. Along with many other new features in SQL Server 2016, Microsoft has invested enhancements to backup. After exploring these enhancements further, I believe these features are very much of a cloud […]

Read More

3 SQL Server Trace Flags to Know Before Troubleshooting

In SQL Server, there are various options available to override the default behavior of the product, including use of trace flags. Trace flags almost every DBA is likely to have used include 1204 or 1222. These are used for printing deadlock graphs in ERRORLOG file for troubleshooting. While these don’t have anything to do with troubleshooting performance, they are a good […]

Read More

2 Pitfalls to Avoid with VARCHAR Datatypes in SQL Server

I am blessed to have traveled quite a bit. I make it a point to keep traveling with family at least two ro three times in a year. The best way to learn new cultures, befriend new people and explore new places can happen only when we move out of our comfort zone. I personally felt my daughter […]

Read More

3 Things You Might Not Know About SQL Server TempDB and Performance

SQL Server has four system databases by default and one of them is called TempDB. TempDB is used for many operations, such as user-created temporary objects, internal temporary objects and version stores and certain features like online re-indexing, multiple active record sets (MARS) and others. Since TempDB is shared across all databases and all connections in SQL […]

Read More

What You Should Know About SQL Server 2016 ColumnStore Indexes

One of the exciting features for data warehouse queries in SQL Server 2012 was the columnstore index. These are designed to provide good performance on analytical queries without the need to explicitly specify indexes. There were, however, many restrictions for their use, including: Columnstore indexes had fewer supported datatypes. Columnstore indexes were Non-updatable–once created, the table would become read-only. […]

Read More