SQL Server 2014’s new In-Memory OLTP feature can potentially revolutionize your OLTP workloads by providing big performance increases with little or no changes to your servers or application code. Microsoft’s In-Memory OLTP delivers performance improvements of 2x to 30x depending on the application. As a brief reminder, SQL server 2014’s In-Memory OLTP works by memory-optimizing […]
Read More
When it comes to building software, our end users are the key to what we build. Most developers and project managers will focus on the use cases are for their software. So whatever is done, it is seen from the eye of the user. Likewise, when a database professional gets deployed into a customer location, they may hear comments from […]
Read More
A recent Information Week’s 2014 State of Enterprise Storage Survey indicates that 40% of respondents were using SSDs in disk arrays and about 39% deployed SSDs in servers, which is about 8-10 points up from the previous year. These figures clearly highlight that SSD adoption is increasing. We brought together a group of expert DBAs, geeks […]
Read More
With every release of SQL Server, the Microsoft product team introduces new features that can improve the performance of the applications using SQL Server as the backend. The buffer pool extension is one such feature introduced in SQL Server 2014. It can help DBAs to increase the size of SQL Server memory area (a.k.a. buffer pool) and extend […]
Read More
This is the fourth of an article series on advanced Oracle explain plan techniques (read Part 3 here). In this article, we will finish the exploration of DBMS_XPLAN format options with a focus on the ‘ALLSTATS LAST’ formatting option. In the example above, notice that the SQL text has a hint: /+* GATHER_PLAN_STATISTICS */ . I have shown this in […]
Read More
This is the third of an article series on advanced Oracle explain plan techniques (read Part 2 here), continuing where we left off: a discussion of the Oracle DBMS_XPLAN format options. This article will illustrate the ‘ALL STATS LAST’ as well as the ‘ADVANCED’ formatting options. Notice above that the SQL text has a hint: /+* GATHER_PLAN_STATISTICS */ . I […]
Read More
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