mgt2426bu alliant credit union cashes in on true database ... · dive deep into our sql server data...

Raymond Pe, Ron Kozakowski, Alliant Credit UnionGregory Hohertz, Blue Medora

MGT2426BU

#MGT2426BU #vmworld

Alliant Credit Union Cashes in on True Database Visibility in vRealize Operations

VMworld 2017 Content: Not fo

r publication or distri

bution

#MGT2426BU #vmworld

Ron Kozakowski

Manager, Data Services

Alliant Credit Union

Gregory Hohertz

Principal Solution Architect

Blue Medora

Raymond Pe

Sr Database Administrator

Alliant Credit Union

Meet your speakersTRUE DATABASE VISIBILITY



bution

#MGT2426BU #vmworld

Deploy an intelligent operations

platform with a single view of the

entire stack.

Performance Tuning

From Microsoft SQL Server

2005 to 2008 to 2012, we’re

always on the move.

Migration Planning

Many tools and many silos. No

single view of the entire stack

slowed root-cause analysis.

Visibility

Challenge 2 Challenge 3Challenge 1

Cashing in on True Database VisibilityAGENDA



bution

#MGT2426BU #vmworld

1935 2002 2016

Move from a single-sponsor

credit union to a Select

Employment Group

A NEW CHARTER

• “Best Checking Accounts”

and “Best Savings

Accounts” (NerdWallet)

• “Best No-Strings Checking”

(Kiplinger)

• “Best Banks of 2016”

(Money Magazine)

Award-Winning

United Airlines Employee

Credit Union in Chicago.

Founded

Members

146

About UsALLIANT CREDIT UNION

Assets

$5088

Members

300,000

Assets

$9.5B

Largest in the US

7th



bution

#MGT2426BU #vmworld

Regulation – CFPB, Dodd Frank, 10B, PCI

Pricing transparency

Digital shift in financial services

Industry

Trends

Nimble and flexible database architecture

Accurate and trusted information

Relevant and insightful

Success

Target

Defining and creating a single source of

reporting truth

Customer Relationship Management

Strategy

Digital shift in marketing, member apps

Information security – DB performance

and security monitoring

Business

Needs

Our project driversAlliant Credit Union



bution

#MGT2426BU #vmworld

No currencyexchange

The challenge

3+Tools monitoring

our DBs,

infrastructure and

VMs

0

#1: Visibility

Complete views of

entire

environment



bution

#MGT2426BU #vmworld

Full-stack visibility

Engineering and data services team

both looking at the same detail on the

health of our SQL Server environment

and the virtual infrastructure that

supports it.

SQL-specific dashboardsDive deep into our SQL Server data with

dashboards that show us exactly which

VM and datastore are serving the SQL

Server Instance and databases.

Root-cause analysisWe use vROps as the single

consolidated console for aggregated

alerting and root cause analysis.

7

Use vROps as a common languageOUR SOLUTION



bution

#MGT2426BU #vmworld

The need for speed

The challenge

#2: Performance

Tuning



bution

#MGT2426BU #vmworld

Identify slow queries

Know if the query is running slow or if the

infrastructure is causing a performance

problem

Use vROps for performance tuningOUR SOLUTION



bution

#MGT2426BU #vmworld

Get clear insight into

performance

11 monitoring dashboards, 12 high-level

views, 7 corresponding reports give insights

on performance, identify emerging

bottlenecks.

Use vROps for performance tuningOUR SOLUTION



bution

#MGT2426BU #vmworld

Change: the only constant

The challenge

3SQL server

migrations in 5

years

0Visibility into

historical demand

for planning

#3: Migration Planning



bution

#MGT2426BU #vmworld

Use vROps analytics, capacity planning

Usage trends help us right size

database VMs

Multiple symptoms show actual

use

Recommend allocations to

engineering based on actual

resources the SQL Server is

utilizing

OUR SOLUTION



bution

#MGT2426BU #vmworld

• New extended query analysis

• Adds 160+ metrics, including: disk usage, disk capacity, query execution time, CPU usage, cluster state.

• New MS SQL Server Low Page Life Expectancy Alert

• 200+ metrics for Azure compute and SQL resources, including: DTU consumption, CPU Usage, In-memory OLTP storage, concurrent workers, concurrent sessions, read/write operations

• Key dashboards:Azure overview, Azure SQL database analysis, Azure SQL query analysis, Azure VM analysis

• Amazon Aurora DB

• Amazon DynamoDB

• Amazon RDS

• Apache Hadoop

• IBM DB2

• MongoDB

• MySQL

• Oracle DB

• PostgreSQL

• SAP HANA

Azure SQL Other DBs in vROpsMS SQL

What’s new: Databases in vROpsBLUE MEDORA



bution

#MGT2426BU #vmworld

Recommended sessionsBLUE MEDORA

Mission Critical SQL Server: Windows, Linux, and

VMware—Oh My! [VIRT2049BU]

Wednesday, Aug 30, 8:30 a.m. - 9:30 a.m. |

Mandalay Bay Ballroom I, Level 2

Snapshots and SQL Server- Technical Deep Dive

& Detailed Lab Findings [PBO3350BUS]


Islander B, Lower Level

Achieve Troubleshooting Mastery

with vRealize Suite (or intelligent operations)

[MGT2508BUR]


Mandalay Bay Ballroom I, Level 2

Watching the Clouds: Challenges with Monitoring

Hybrid Cloud Environments [MMC2256BU]


Mandalay Bay Ballroom L, Level 2



bution

#MGT2426BU #vmworld

CALMING THE STORM: HOW TO MINIMIZE IT ALERTSGreg Hohertz

Principal Solution Architect

Q&A

Gregory Hohertz

Principal Solution Architect, Blue Medora



bution

#MMC2256BU #vmworld

Superchargeyour platformSign up for a free trial in booth 106.

You could win a Super Scout 73.

The Blue Medora

True Visibility Suite will



bution



bution

mgt2426bu alliant credit union cashes in on true database ... · dive deep into our sql server data...

Documents