inTune • ISSUE 03 | AUGUST 2011
inTune • ISSUE 03 | AUGUST 2011
www.dbsophic.com
In this Issue
- New DBSophic Website and Product Names
- Vote for Your Favorite Qure Products (SQL Server Magazine Awards)
- Featured Article: Physical Join Operators in SQL Server - Merge Operators
- Tip: Comparing Database Workloads with Qure Profiler - Part II
- Events: SQL Server MVP Ami Levin to Speak at PASS Summit 2011
- News: Leading Automotive Company Accelerates Application Performance with DBSophic's Qure
New DBSophic Website and Product Names
We are pleased to announce that we recently re-launched our website. We hope you will find the many changes pleasing, useful and informative. The all-new screen tours of Qure Profiler and Qure Optimizer are especially recommended!
We also took this opportunity to update our product names: "Qure for SQL Server" is now known as Qure Optimizer, and "Qure Workload Profiler" is now simply Qure Profiler. Both are a part of the Qure workload management suite.
Please note that due to a website infrastructure change, current website users will have to register again upon their next product download. We apologize in advance for this one-time inconvenience and look forward to your comments and suggestions.
Vote for Your Favorite Qure Products (SQL Server Magazine Awards)
DBSophic is honored to have two nominations for the SQL Server Magazine's Community Choice Awards. Qure Optimizer is nominated for the "Best Database Monitoring & Performance Product" award (listed as "DBSophic Qure for SQL Server"). Qure Profiler is nominated under the "Best Free Tool" category (listed as "DBSophic Qure Workload Profiler"). We'd appreciate your votes for your favourite tools. Cast your vote now!
Featured Article: Physical Join Operators in SQL Server - Merge Operators
By SQL Server MVP Ami Levin
In Part I of this series on physical join operators we looked at Nested Loops. We now turn our attention to the Merge operator.
For this article series I am using an analogy of two sets of standard playing cards. One set with a blue back and another with a red back that need to be 'joined' together according to various join conditions. The two sets of cards simply represent the rows from the two joined tables, the red input and the blue input - "Now Neo - which input do you choose"?
Read more >>
Tip: Comparing Database Workloads with Qure Profiler - Part II
By SQL Server MVP Ami Levin
In Part I of this article, we discussed how Qure Profiler came to be, and how it can come to your aid whenever you need to compare two production database workloads. We elucidated the simplicity of the various filtering, grouping and sorting controls that allow you to create comparison views to suit your interests. We also defined the differences between controlled and uncontrolled workloads.
Controlled Workloads were the focus of Part I. Now it’s time to dive into the deep waters of Uncontrolled Workloads. Read more>>
Events: SQL Server MVP Ami Levin to Speak at PASS Summit 2011
PASS Summit 2011 is just around the corner and our CTO, SQL Server MVP Ami Levin, will be speaking on the subject of Physical Join Operators.
DBSophic will be exhibiting at PASS Summit again this year, so come visit us at booth 429 (across from Embarcadero).
News: Leading Automotive Company Accelerates Application Performance with DBSophic's Qure
DBSophic's workload tuning solution for SQL Server based applications is deployed at BMW.
Over the past few years, the SQL Server database platform has become increasingly mission-critical at BMW. The company's custom-built identity management system (IdAS) is just one of several key applications running on SQL Server. Serving over 200,000 IT users, the system manages accounts, roles and access rights across the organization.
Qure Optimizer was adopted as the BMW Group's tuning solution for SQL Server based applications. As part of the initial deployment, the solution was used to address performance issues on the important IdAS application. Read More>>