Performance
A good writer is supposed to draw you in with the title and bury the answer somewhere in the article. I suppose this makes me a bad writer – don’t think less of me, my whole feeling of self-worth comes from the opinions of internet strangers!
There are often questions surrounding the ideal Apache HTTPD Web Server configuration for HealthShare. The contents of this article will outline the initial recommended web server configuration for any HealthShare product.
As a starting point, Apache HTTPD version 2.4.x (64-bit) is recommended. Earlier versions such as 2.2.x are available, however version 2.2 is not recommended for performance and scalability of HealthShare.
There are three things most important to any SQL performance conversation: Indices, TuneTable, and Show Plan. The attached PDFs includes historical presentations on these topics that cover the basics of these 3 things in one place. Our documentation provides more detail on these and other SQL Performance topics in the links below. The eLearning options reinforces several of these topics. In addition, there are several Developer Community articles which touch on SQL performance, and those relevant links are also listed.
There is a fair amount of repetition in the information listed below. The most important aspects of SQL performance to consider are:
- The types of indices available
- Using one index type over another
- The information TuneTable gathers for a table and what it means to the Optimizer
- How to read a Show Plan to better understand if a query is good or bad
Hi Community!
New session recording from Global Summit 2018 is available on Developer Community YouTube Channel:
Hi Community!
Please welcome a new video on Developer Community YouTube Channel:
Alexa: Connect Me with the World of IoT
Not everyone knows that InterSystems Caché has a built-in tool for code profiling called Caché Monitor.
Continuing on with providing some examples of various storage technologies and their performance profiles, this time we looked at the growing trend of leveraging internal commodity-based server storage, specifically the new HPE Cloudline 3150 Gen10 AMD processor-based single socket servers with two 3.2TB Samsung PM1725a NVMe drives.
I have a ZEN page with nine tablepanes. Each tablepane queries a table in the same SQLServer db.
Hi Community!
We are pleased to invite you to the upcoming webinar "Taking Control of Your SQL Performance" on 12th of September at 11:00 a.m. EDT!
Hi,
Has anyone got any experience of using the Microsoft diskspd utility to test the storage infrastructure in Healthshare/Ensemble environment.
Hi,
I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)
Often InterSystems technology architect team is asked about recommended storage arrays or storage technologies. To provide this information to a wider audience as reference, a new series is started to provide some of the results we have encountered with various storage technologies. As a general recommendation, all-flash storage is highly recommended with all InterSystems products to provide the lowest latency and predictable IOPS capabilities.
The first in the series was the most recently tested Netapp AFF A300 storage array. This is middle-tier type storage array with several higher models above it. This specific A300 model is capable of supporting a minimal configuration of only a few drives to hundreds of drives per HA pair, and also capable of being clustered with multiple controller pairs for tens of PB's of disk capacity and hundreds of thousands of IOPS or higher.
Hi Everybody!
We are pleased to invite you to the upcoming webinar "Optimizing Application Performance" on 29th of May at 10:00 (Moscow time)!
A unique chance to talk about application performance.
Has anyone done any kind of integration with Dynatrace, which is a JVM transaction monitoring tool?
Currently, we are receiving an alert that states, "Write Daemon still on pass 31". It's been that way for a few hours.
In the last post we scheduled 24-hour collections of performance metrics using pButtons. In this post we are going to be looking at a few of the key metrics that are being collected and how they relate to the underlying system hardware. We will also start to explore the relationship between Caché (or any of the InterSystems Data Platforms) metrics and system metrics. And how you can use these metrics to understand the daily beat rate of your systems and diagnose performance problems.
Currently, we are running 2014.1 on two different servers (OpenVMS, RHEL). The plan is to transition from OpenVMS to RHEL, but our Write Daemon is in a Troubled state on both servers.
Hi, Community!
Check a new session recording from Global Summit 2017:
Pros and Cons of Virtual Environments
Hi Guys,
Can you please advise on the below queries.
Query 1:
Example 1:
S a="345",b="arun",c="kumar",d="hi",e="yello",f="orange"
Example 2:
No doubt bitmap indexing, if used with a suitable property, performs just impressive!
But there is a major limit: ID key has to be a positive integer.
Intersytems documentation says not to hold entire SDA as object in In-memory.
Hi, Community!
Please welcome a new session recording from Global Summit 2017:
Migrating Apps to the Cloud : The Basics
Here is a snippet that I learned yesterday
You can define an index on a collection property but when I tried to use it, I failed. I was using
As I was going though and trying to figure out why our CACHE.dat has increased in size over the past 18 days, I found that EnsLib_HL7.Message is still retaining messages dating back to 2014 even though we have our
APM normally focuses on the activity of the application but gathering information about system usage gives you important background information that helps understand and manage the performance of your application