logo-black
  • Solutions
    • Database Professional Services
      • Microsoft SQL Server Services
    • Cloud Service and Solutions
      • Viscosity Edge Cloud
      • Hybrid Cloud
      • Public Cloud
    • Application Development
    • Managed Services
      • Engineered Systems
    • Oracle Technology Solutions
  • Resources
    • Case Studies
    • Data Sheets
    • Whitepapers
    • Publications
  • Events
  • Blogs
  • About
    • Clients
    • Partnerships
    • Contact
    • Careers
Contact Us

Access Your Data with Faster Response Times - Performance Tune Database and Applications

It’s a recurring problem for database and application systems. We’ll help you keep them running optimally through our systematic approach.  
Learn More Contact Us

All too often, the scenario goes something like this: a new system is implemented, performance is good, and then over time, it erodes to the point that it’s difficult for the business users to do their jobs. Other times, it may not even get that far, and a newly implemented or upgraded system simply isn’t capable of keeping up with the application’s demands. 
 
Viscosity excels at helping customers – from SMBs to large enterprises – address their organization’s specific needs and meet their service level objectives. We offer tailored solutions to optimize the performance of your database and applications through our tuning processes! 

customer stories-02
solutions-02

Viscosity North America Excels at Helping Customers from SMBS to Large Enterprises

down-arrow
Our Performance Tuning Process

We follow a systematic approach with our top-down analysis – where we look at a database or application and see how the application behaves with individual queries with an end-user experience or insight. It’s all about the response times observed from the latency of the network, bottlenecks from the storage, over-utilized CPU/memory, wait events in the database, and queries not responding in a timely manner. Here we break down a checklist of some basics we will review with you:

  • How does the query execute – what is the execution path to access the data?
  • Where did the query spend most of its time? 
  • Is the right index(es) being used to drive access to the data? 
  • Are there statistics being updated frequently?  At a minimum weekly and are they used efficiently? 
  • What is your data volume like?  Is there an opportunity for archiving or partitioning strategies in a data life-cycle management process? 

Our standard performance assessment can take anywhere from 1-to 2 weeks, depending on your unique needs, and we will come back with our findings and best practices to optimize your processes.

  •  
Infrastructure

A solid foundation is a layer on which everything rests, and it’s essential to ensure that it is set up correctly. The same is true for houses and is equally valid for your IT infrastructure. Historically, storage has been the bottleneck for the majority of performance issues. Even with modernized infrastructure (NVMe, SSDs, Flash), Customers still struggle with performance.

Whether you are working with legacy systems, commodity hardware, or in the Cloud, our consultants can help identify the current bottlenecks and ensure they will run optimally.

Data Layer

Customers often throw new hardware to solve the performance problem. While new hardware can often be orders of magnitude faster than an older system, it can often disguise problems versus fixing them; it is matter of time, the performance problem will re-surface. This is where our consultants excel, helping tune the databases and the SQL queries for optimal efficiency and ensuring that the hardware – be it new or existing – is effectively being used by the underlying database. We bring a deep understanding of the tuning process and can leverage the maximum possible value out of your new or existing resources. 

Where we shine as a company is we specialize in tuning at the data layer. Our data engineers work with our customers to help architect their data roadmap and identify areas for data enrichment while reducing data access time. 

Less can be more

There’s a tendency to throw “more” of something at a problem to try and solve it – more indexes, larger caches, even more operations. Frequently, that can be detrimental to a system that can run more effectively with a leaner configuration with less overhead and less contention for those extra resources. Viscosity consultants are skilled at identifying these opportunities to increase performance by reducing the overhead, resulting in a “leaner” and “meaner” system footprint.

Leverage existing tools

Often, performance opportunities exist simply by leveraging existing tools and features of the database that customers are unaware of or have not set up correctly. Viscosity can identify how to use these features to optimize the performance experience and get your systems back on track.

Be proactive and be prepared

More often than not, it’s best to detect a problem before it escalates and becomes a crisis that users notice. Viscosity can offer custom solutions to help with this or even serve as a managed services partner to keep an eye on your systems and ensure problems are detected before they become significant issues.

Meet
Charles Kim
Oracle ACE Director
President, CEO Viscosity North America
Charles Kim
We Performance Tune the Entire Stack from the Application Layer to the Database Layer
Leave it to our experts to find a solution to help clear performance bottlenecks through our systematic approach!

Application Tuning

Application development is part of our core strengths. We can review most application code and make recommendations for tuning the client application stack.

We always approach tuning from an end-user response time angle. We want to make sure that the end-users are happy with the improved response times. 

We have tuned applications to cut down CPUs by up to half, creating huge cost-saving benefits!

We look at the application layer all the way down to the storage layers
icons blue-06
1
Application
2
OS
3
Network
4
Database
5
Storage

Database Tuning

  • We assess how the connectivity between the storage server and the database server is set up – where we often find other areas that we can tune. 
  • The storage layer is one of those other areas – it is the layer between the storage and server layer (typically the storage network nowadays), is where we look at the traffic between the Operating System of the server and the database itself.   
  • Databases often communicate with other databases through database links, ETL jobs, or PL/SQL jobs. We look at how databases communicate with other databases.  
  • We also help query tuning by leading it to pull data at the source intelligently. Sometimes the SQL code needs to be predicated to run on the remote database and filter the data before traversing through the network with enormous data sets. Our goal is to pinpoint the bottleneck to tune long-running queries. 
DATA AZUL-01
Viscosity North America
Our Work in Numbers
0
+
Cases

We have closed more than 150 cases in various fields: from healthcare to energy

0
Experts

Our team consists of 35 experts specializing in the performance tuning area

0
+
Books & Publications

Our experts have published 250+ pieces of paperwork about performance tuning

0
+
Years of Experience

We are passionate techies with over 25 years of extensive real-world experience

Why choose Viscosity for your
Performance Tuning Needs?

✔️ We wrote the books!

We’re always trying to do differentiators

Our CIO, Rich Niemiec (Oracle ACE Director), wrote one of the top-selling performance tuning books. We have an upcoming performance tuning book coming out by our Managing Principal Consultant, Gary  Gordhamer (Oracle ACE Pro), which specially targets Oracle Database 19c. 

Viscosity Publications
Oracle-Database-12c-Release-2-Niemiec
Viscosity has tuned applications to cut down CPUs by up to half, creating huge cost-saving benefits!

✔️ We lead OraPub Inc.

We acquired OraPub at the beginning of 2022 – the leading platform for teaching performance tuning techniques! We offer advanced consulting services especially for tuning complex systems. 

Join thousands of happy customers and end the frustration in tuning Oracle databases. Our services give you the training you need so your Oracle database runs faster and more efficiently. And, you get the credit!

Снимок экрана 2022-06-29 в 15.59.07
Go to OraPub Inc.

OraPub really helped me to advance in my career and life.  I remember when I was attending other training, I put in more effort but took away less without confidence. But, Craig's unique training style made me relax, learn more without worries, just concentrate, and ask any question. I really like Craig's energetic appearance, takeaways, time management, typing log, and post-training support.

Azhar Mahmood — Senior Database Specialist, Tabadul

✔️ We offer tailored solutions!

We offer tailored solutions from storage and data to optimize the performance of your database and applications.   

Explore Solutions

✔️ We offer Performace Tuning in both public & private cloud!

We offer performance tuning in both public (Oracle Cloud, Azure Cloud, and AWS) and private cloud. 

Learn More

✔️ Viscosity is a Microsoft Gold Partner!

We also have certified experts who can help tune databases on-premise and on Azure.

Read the Press Release
2-Jun-22-2022-03-57-17-17-PM
We make difference
The best solutions for developing your business
Empowering business transformation to move faster and scale effortlessly.
Talk to us about how we can work together.

logo fondo oscuro 2-01
 
Viscosity is a recognized niche Oracle and Microsoft consulting firm providing expertise in cloud, Oracle Exadata, Azure, RAC, Linux, and DBA consulting with near-zero downtime and near-zero risk.
Headquarters
3016 Communications Parkway, Suite 200
Plano TX 75093
Contacts
sales@viscosityna.com
Copyright 2022. All Rights Reserved by Viscosity North America.