Does the prospect of spending hours engaged in small talk with colleagues make you shudder? Do you suffer PTSD from the last time you tossed back a few drinks with the boss? Then we have the cure: Project Inspire. Whether you’re a social butterfly or a bit of a curmudgeon, it’s the perfect holiday party.… Read More

The post The Dirty Jobs That Make Project Inspire Silicon Valley’s Best Holiday Party appeared first on The Official NVIDIA Blog.

Paris, December 07 2015

DALIBO is proud to present the third release of PoWA, the PostgreSQL Workload Analyzer.

Realtime traffic analysis and dynamic graphs

PoWA is a workload analyzer that gives a clear view of the activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time-consuming queries over the specified time period.

If you zoom anywhere in one of the graphs, the chart will adjust and show you which queries were running at that time. If you click on a specific query, you will get additional graphs such as read/write time, number of rows affected, local and shared hit, etc.

Better predicate analyzer

The pg_qualstats extension stores new counters. It's now possible to know the most executed predicates in relation to all the related queries. It also tracks non-normalized queries so that it’s possible to execute an EXPLAIN of any query tracked by pg_stat_statements.

Database global optimization

PoWA is now able to use statistics about every predicate used by any query executed on a database to suggest the smallest index set that optimizes every one of those predicates.

In particular, the heuristics place heavy emphasis in consolidating many indexes into one by giving preference to definitions spanning multiple columns. This can provide new information about the actual load and correlation between predicates that are traditionally hard to discover for the DBA.

Index suggestion check

Thanks to the HypoPG extension, the benefits of the suggested index creations can automatically be checked by running the queries against hypothetical indexes. You can see instantly if the suggested index is relevant and how much it'll improve the query.

Credits

DALIBO would like to thank the users and developers who contributed to this release.

PoWA is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, patches or features requests using the GitHub tools or to powa-users@googlegroups.com

Links

For PoWA 3.0.0:

• Download: dalibo.github.io/powa
• Demo: demo-powa.dalibo.com (login/pass = powa/demo)
• Doc: powa.readthedocs.org
• Mailing list: https://groups.google.com/forum/?hl=fr#!forum/powa-users
• Issues: github.com/dalibo/powa/issues

For the stats extensions:

• pg_qualstats: github.com/dalibo/pg_qualstats
• pg_stat_kcache: github.com/dalibo/pg_stat_kcache
• HypoPG: github.com/dalibo/hypopg

About PoWA

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers.

Code & Demo at dalibo.github.io/powa

About DALIBO

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops.

Check out DALIBO's open source projects at dalibo.github.io

VMware NSX network virtualization and vRealize Automation deliver a feature rich, dynamic integration that provides the capability to deploy applications along with network and security services at provisioning time while maintaining compliance with the required security and connectivity policies. This native integration highlights the value of NSX when combined with automation and self-service and shows […]

The post VMware NSX and vRealize Automation Overview – Part 1 appeared first on The Network Virtualization Blog.

By: Eero Teerikorpi, Sr. Director, Strategic Alliance, VMware Modern enterprises depend on an extensive fabric of databases and applications that have been built up over long periods of time. Relational databases based on Oracle are particularly a particular vital part of this infrastructure.It is critically important for businesses to enable such databases are protected against […]

The post Announcing New Oracle Replication with VMware Continuent 5.0 appeared first on VMware vCloud Blog.

??????????!VMware???????????Satoko??? ??????????????CPU????????????????????????????????????????????????????????????????????????CPU???????????????????????????????????????????? CPU?????????????????????????????????????????????????????????????????????????????????????????????????????? vSphere ??????????????????????????????? ????????????????????????????????????????????????????????????????????????????????? ???????????????????????? ????= ESXi ???????????????????????? ??????????????????????????? ????1:???????? ????2:???????????????? ????3:?????????????????? ????1:???????? ?????????????????????????????? ESXi ????????????????????????????????????????????ESXi?????????????????? ????????????????? ESXi ???????????????????????????????????????????????????????????????????????????????ESXi ??????????????????!???????????? ????????????????????ESXi(???????)???????????????????? ??????????????????????????????!?????????????????? ????????????????????????????????vSphere HA ( ??HA )????HA ????????????????????????????????????????25%?CPU???????????????????????????????????????????????????????????????? ????2:????????????????? HA????????????????ESXi?????????….????????????????????????????????????????????????????????????????????????????????? ??????????????????????????????? ESXi ??????????? ??????????????????????????? ????????????????????????????????? ESXi ????????????? ??????????????????????????????????????????????????????? HA????….??????ESXi??????????????? ????????????????????????????????? ??????????????????????????????????????????????????? ???????????CPU???????????????????????????????????????????????(DRS:vSphere Distributed Resource Scheduler) ????=????????????????????????????????CPU/??????????????DRS?????????????????????????????CPU???????????????????????????????????????????? DRS????????ESXi ?1??????????????????????????????????????? ???????????????????DRS??????????????????????????2???????????????????????????????????????????DRS??????????????? ????3 :?????????????????? ?????????????????????????????????????….???????????????????…????????????????????????????????????????? ??????????????????????????????????????? […]

The post VMware?????????????????????????????????? appeared first on Japan Cloud Infrastructure Blog.

by Priti Mishra Performance studies have previously shown that there is no doubt virtualized servers can run a variety of applications near, or in some cases even above, that of software running natively (on bare metal). In a new white paper, we raise the bar higher and test “monster” vSphere virtual machines loaded with CPU […]

The post Virtualizing Performance-Critical Database Applications in VMware vSphere 6.0 appeared first on VMware VROOM! Blog.

The new VMware Partner Professional Services Program (PPSP) recognizes and rewards partners who sell and deliver their own consulting services engagements, with an emphasis on moving customers to the Software-Defined Enterprise. Through services-focused training, access to VMware IP materials plus sales and delivery support, the PPSP Program will help you create a highly profitable services […]

The post New Partner Professional Services Program Launched appeared first on Partner News.

VMware Virtual SAN (VSAN) is radically simple, hyper-converged storage for virtualized environments. Hyper-converged Infrastructure (HCI) leverages the hypervisor to deliver compute, networking and shared storage from a single x86 platform. In addition to being incredibly simple to deploy and provision, Virtual SAN allows you to scale storage and compute resources, eliminating costly forklift upgrades. Every

The post Top 4 Benefits of VMware Virtual SAN (As Told By Customers) appeared first on Virtual Blocks.

At VMware, we believe that each of our people has what it takes to make change happen. Through the VMware Foundation, VMware employees are empowered to give back to the causes closest to their hearts through Service Learning. Connect with VMware CTO Ambassador and Business Solutions Strategist, Ed Hoppitt and hear how he is taking […]

The post Making Change Happen: How a Passion for Robots Sparks the Next Generation of STEM Innovators appeared first on VMware Careers Blog.

This article takes eightcommon misperceptions about virtualizing Hadoop and explains why they are errors in people’s understanding. The short explanations given should serve to clear up the understanding about these important topics. Myth #1: Virtualization may add significant performance overhead to a Hadoop cluster. This is a common question from users who are in the […]

The post Eight Myths about Virtualizing Hadoop Dispelled appeared first on VMware vSphere Blog.

Life just got easier if your company is one of the 300,000 relying on Esri solutions to visually understand and analyze location data. That’s because the Esri ArcGIS Desktop Virtualization Appliance with NVIDIA GRID graphics virtualization technology is here. Now, geographic information systems (GIS) applications, like Esri ArcGIS Pro, can be delivered to users in… Read More

The post How NVIDIA GRID Is Bringing GIS to Any Device, Anywhere appeared first on The Official NVIDIA Blog.

Hey everyone! I know, it’s been a while since I blogged. It’s been an insanely busy time here at VMware, especially for vSphere security. VMworld US and Europe vSphere security sessions were very popular! And since then, I’ve been traveling a whole bunch, meeting customers and talking about security operations. A recurring ask has been […]

The post SDDC Security Operations class from VMware Education appeared first on VMware vSphere Blog.