Langkah untuk menjaga performa Database.

Masalah klasik yang sering dihadapi oleh sebuah aplikasi dengan skala enterprise adalah masalah performance dari aplikasi yang biasanya perlahan tetapi pasti semakin lama semakin lambat sehingga perlu tuning. Dilihat dari persentase pengaruhnya terhadap performace aplikasi dapat kita lihat seperti tampak pada tabel berikut ini: App Design DB Design SQL Hardware tuning Perf Monitoring workload changes 25%…


Visual Studio 2017 をリリース: 生産性、パフォーマンス、パートナー エコシステムの強化

本記事は、マイクロソフト本社の The Visual Studio Blog の記事を抄訳したものです。 【元記事】 Visual Studio 2017: Productivity, Performance, and Partners 2017/3/7   このたびマイクロソフトは、Visual Studio 2017 をリリースしました。こちらからダウンロードを開始 (英語) のうえ、この記事で今回提供される主要機能の情報をご確認ください。今回のリリースによる変更点の完全な一覧については、Visual Studio 2017 のリリース ノートをご覧ください。この記事では、以下の点についてご紹介します。 基本機能: 生産性とパフォーマンス 優れたモバイル アプリケーション開発エクスペリエンス クラウドでの開発 DevOps Visual Studio のエコシステム 基本機能: 生産性とパフォーマンス 起動時間とプロジェクト読み込み時間の短縮: 複数の基本機能を強化した結果、Visual Studio 2017 では起動時間が Visual Studio 2015 の 3 分の 1 に短縮されました。また、ソリューションの読み込み時間が 2 分の 1 から 4 分の…


BW Queries by factors faster using FEMS-pushdown

Complex SAP BW queries often contain FEMS-filters. These filters used to be applied on the SAP application server, which was not very efficient. A new SQL statement generator in SAP BW implements an optimized algorithm for FEMS processing. We have seen performance improvements up-to factor 100. The actual performance improvement varies heavily for different BW…


Some thoughts around Service Throttling on WCF Services

One of this we had to work on an issue around how to implement the Service Throttling Behaviour in a set of highly accessible WCF Services, basically we want that the maximum load on each service to be controlled. Of course, that we were aware that the effects of these settings are dependent on the transport (different…


Dynamics NAV Performance Tooling, Part 1

This is the first in the series of posts to help you monitor and understand your system’s performance indicators. There are several areas to look into when monitoring your system for performance: hardware, setup and configuration, database maintenance, indexing and queries, business logic. We will leave out the traditional topics of monitoring your hardware performance…

2

HDInsight HBase: 9 things you must do to get great HBase performance

Cross post from ADL blog This post is based on learnings from numerous  HDInsight HBase customer interactions. HBase is a fantastic high end NoSql BigData machine that gives you many options to get great performance, there are no shortage of levers that you can’t tweak to further optimize it. Below is the general list of impact-full considerations…


SET SHOWPLAN_TEXT

Esse é mais um artigo da série “Saga da otimização com comandos antigos” Parte 1: SET STATISTICS IO Parte 2: DBCC DROPCLEANBUFFERS Parte 3: DBCC SHOWCONTIG Parte 4: DBCC PAGE Parte 5: sp_spaceused Parte 6: DBCC IND Parte 7: DBCC INDEXDEFRAG Parte 8: DBCC DBREINDEX Parte 9: sp_detach_db No último artigo, falamos do impacto do…


sp_detach_db

Esse é mais um artigo da série “Saga da otimização com comandos antigos” Parte 1: SET STATISTICS IO Parte 2: DBCC DROPCLEANBUFFERS Parte 3: DBCC SHOWCONTIG Parte 4: DBCC PAGE Parte 5: sp_spaceused Parte 6: DBCC IND Parte 7: DBCC INDEXDEFRAG Parte 8: DBCC DBREINDEX No último artigo, comentei sobre as melhores práticas para escolha…


DBCC DBREINDEX

Esse é mais um artigo da série “Saga da otimização com comandos antigos” Parte 1: SET STATISTICS IO Parte 2: DBCC DROPCLEANBUFFERS Parte 3: DBCC SHOWCONTIG Parte 4: DBCC PAGE Parte 5: sp_spaceused Parte 6: DBCC IND Parte 7: DBCC INDEXDEFRAG No último artigo, comparamos o INDEX SCAN e HEAP SCAN e mostramos que o…