This is the second of an article series on advanced Oracle explain plan techniques (read Part 1 here). In this article, we continue down the DBMS_XPLAN path and dig a little deeper into DBMS_XPLAN to show useful SQL tuning information. The above illustration shows the DBMS_XPLAN package and the three main functions I use to display useful […]
Read More
This is the first in an article series that will illustrate some advanced SQL explain plan techniques that were introduced with Oracle 10g. Oracle 10g was a big change for the Oracle optimizer, the code that tries to determine the best path to retrieve the requested data. Changes include how Oracle uses indexes and just a […]
Read More
There’s no doubt that the most important new feature that Microsoft added to SQL Server 2014 is the new In-Memory OLTP engine. The In-Memory OLTP engine enables you to move select tables and stored procedures into memory for high-performance, low-latency data access. With CPU processing speeds plateauing and memory capacities expanding, Microsoft turned to utilizing RAM […]
Read More
One recent enhancement is the ability to store SQL Server files on SMB File Shares. In this article, we will look at Windows Server 2012’s Windows PowerShell cmdlets and WMI objects to manage SMB File Servers and SMB File Shares. These new tools are aimed at both system administrator and developers, and can be accessed to: Use the […]
Read More
Scalability, flexibility and agility are the cornerstones of successful cloud deployments. Customers across the globe have relied on Oracle Database Real Application Clusters (RAC) for their database cloud systems. Oracle 12c comes with significant enhancements, including scalability and high availability with such features as Flex Clusters, Flex ASM, Application Continuity and Transaction Guard. We brought together […]
Read More
With every release of SQL Server, Microsoft brings unique ways to solve the business problem. SQL Server 2014 is one such release, in which various new features were introduced which makes it truly world class enterprise level RDBMS engine. In this article, we explore a feature introduced in SQL Server 2014 called Managed Lock Priority. If we look […]
Read More
Today’s hypervisors like Hyper-V and vSphere make it easy to virtualize servers like SQL Server. However, they can also make it easy to create poorly performing virtualized SQL server instances. In this article I’ll cover some of the biggest mistakes that you can make when virtualizing SQL Server. Some of the top mistakes to avoid […]
Read More
It wasn’t that long ago that many companies thought that you couldn’t virtualize SQL Server because it was too resource intensive. However, with the advances that both Microsoft and VMware have made to Hyper-V and vSphere respectively today’s virtualization platforms are more than capable of running almost every enterprise workload – including SQL Server. This […]
Read More
Provisioning a new server has become increasingly easy with virtualization. Provisioning data, however, can be more challenging, especially in Agile shops where the volume of environments required to support dev and testing can easily go beyond the abilities of your IT operations to keep up. Is there any way to make it easier? We brought […]
Read More
Be it SQL Server or the improved version of SQL Server on the cloud called as SQL Azure, when it comes to monitoring, there is nothing as powerful as DMVs (Dynamic Management Views). For a primer, Dynamic Management Views (DMVs) are a set of virtual views which expose the internal states of SQL Server deployment. […]
Read More
If you ever ask a SQL Server DBA about most frequently faced performance issue in SQL Server, they would most likely say blocking or high CPU. A smart DBA would first confirm that high CPU is caused by SQL Server by looking at performance monitor. Once it is confirmed who is consuming high amount of […]
Read More
The prior article discussed the Oracle library cache, the difference between a hard parse and a soft parse, and a bit on bind variable processing as well. To review, Oracle hard parsing reads in statistics, utilizes index information and creates an execution plan. Soft parsing already has the execution plan and doesn’t need to revisit the statisticsand […]
Read More