slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Database Management Martin Rapetti Business Development Manager PowerPoint Presentation
Download Presentation
Database Management Martin Rapetti Business Development Manager

Loading in 2 Seconds...

play fullscreen
1 / 28

Database Management Martin Rapetti Business Development Manager - PowerPoint PPT Presentation


  • 158 Views
  • Uploaded on

Database Management Martin Rapetti Business Development Manager. Quest Software. Solution Focus Database Design & Development BI – Query & Reporting Database Management Performance Monitoring & Diagnostics Backup & Recovery Our Approach

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Management Martin Rapetti Business Development Manager' - darrin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Database Management

Martin Rapetti

Business Development Manager

quest software
Quest Software
  • Solution Focus
    • Database Design & Development
    • BI – Query & Reporting
    • Database Management
    • Performance Monitoring & Diagnostics
    • Backup & Recovery
  • Our Approach
    • Solutions need to be quick to install & simple to use
    • Intuitive & Informative
    • Contextual around a particular problem
data data everywhere
Data Data everywhere
  • 2,500 exabytes of new information in 2012 with Internet as primary driver
  • Digital universe grew by 62% last year to 800K petabytes and will grow to 1.2 zettabytes this year
  • By 2012 most workloads on X86 will be virtualized and by 2016 80% of workloads on X86 will be virtualized.
  • Youtubeusers upload 35 hours of video every minute
  • Netflix traffic represents 20% of US peak time downstream traffic
  • BI works for smaller datasets but cannot be applied across huge datasets
  • Opportunities that need to be addressed
    • Business Intelligence
    • Search / ediscovery
    • Data Integration / Cleansing
    • Storage
    • Security
slide7

The Evolution of Quest Software’s Toad®

History in Building Tools Personalized for the Individual End User

our solutions help you
Our Solutions help you
  • Understand your data structures
  • Build better & more optimized code
  • Review your data cross platform
  • Visualize your database performance

issues

  • Implement new technological ideas

whilst broadening your own expertise.

data interpretation and implication
Data Interpretation and Implication
  • Simpson's Paradox
    • a common but misleading statistical phenomenon rooted in the differing sizes of subgroups. Put simply, Simpson's Paradox reveals that aggregated data can appear to reverse important trends in the numbers being combined.
  • Example
    • Which airline would you travel on?
    • 4 airports, 2 airlines with delays
  • For each airport individually, airline 1 has the most relative delays
  • Overall however, airline 2 has more relative delay

Airline 1

Airline 2

business data challenges
Business Data Challenges
  • Revenue depends on applications
  • Productivity of employees depends on applications
  • End users expectations of technology continue to rise
  • Cost cutting can put business service performance at risk

A one second delay in response time of web applications can impact customer satisfaction by up to 16%.

28% of users will not return to a website if it’s not performing well.

Issues with application performance are impacting overall corporate revenue up to 9%

technical data challenges
Technical Data Challenges
  • Most problems are still discovered by end users
  • Problem resolution takes too many people too long
  • Multiple tools give different answers
  • Problem reproduction in QA delays resolution
  • Too many end users to predict behavior with the app
  • Rate of application change overloads traditional support

Through 2012, 80% of application performance and availability problems will be blamed on the network, but the network will only represent 20% of the root cause.

case study aligning business to it
Case Study – Aligning Business to IT
  • Where in your IT landscape are performance problems?

Am I meeting my negotiated SLAs?

case study aligning business to it1
Case Study – Aligning Business to IT

Are my key business applications meeting SLAs?

What is the location of end users or data centers being impacted?

Which team should investigate this problem further?

How many users are affected by current problems?

slide16

Case Study– Aligning Business to IT

Can you pinpoint where transaction slow downs are occurring?

slide17

Case StudyUK Financial Institution – Aligning Business to IT

Can SQL Server address enough memory and are the caches healthy?

Are SQL Server services experiencing issues?

Are the database files or I/O devices nearing capacity?

project lucy
Project LUCY

Analyzing your application performance data

https://www.projectlucy.com/

database management with quest software
Database Management with Quest Software
  • Solve BIG problems for IT with products that are SIMPLE to try, buy, and use.