advertisement

Database Performance Analyzer: What Are You Waiting For?

50 %
50 %
advertisement
Information about Database Performance Analyzer: What Are You Waiting For?
Technology

Published on March 11, 2014

Author: SolarWinds

Source: slideshare.net

Description

For most folks a database server is little more than a black box: queries go in, data comes out. But when the data comes out too slowly it falls upon you to take the lid off and make sense of what you find inside. In this presentation Thomas LaRock from SolarWinds will show you how the new SolarWinds Database Performance Analyzer (formerly Confio Ignite) uses response time analysis in the overall performance tuning process to help you understand what happens inside that black box.

Learn More and Connect with SolarWinds Federal:

Federal website: http://www.solarwinds.com/federal

thwack Federal and Government group: http://thwack.solarwinds.com/groups/federal-and-government

Twitter: http://twitter.com/SolarWinds_Gov
advertisement

Database Performance Analyzer: What Are You Waiting For? Thomas LaRock Technical Evangelist SolarWinds® © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Who Am I? @SQLRockstar http://thomaslarock.com © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 2

I was once just like you… © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 3

I was once just like you… © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 4

Typical Day For Your DBA © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 5

What Are You Most Measured By? 6 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

What Are You Most Measured By? 7 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

You…Must…Focus… 8 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Performance Tuning Is HARD! © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 9

Performance Tuning Is HARD! QUERY © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 10

Performance Tuning Is HARD! QUERY DATA © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 11

What’s Inside The Box? 12 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

13© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

What’s Inside The Box? 14 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Perfmon? What Metrics Do You Have Currently? 15 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Perfmon? » SQL Trace? What Metrics Do You Have Currently? 16 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Perfmon? » SQL Trace? » xEvents? What Metrics Do You Have Currently? 17 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Perfmon? » SQL Trace? » xEvents? » OEM? What Metrics Do You Have Currently? 18 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Perfmon? » SQL Trace? » xEvents? » OEM? Tracing versus Polling: Which is better? What Metrics Do You Have Currently? 19 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Tracing: Great for when you know what to look for in advance » Polling: Great for when you don’t know what to look for in advance Tracing v Polling 20 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Blamestorming © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 21

 SQL processing includes hundreds of steps  Identify Wait Time at every step  Rank bottlenecks by impact on end user Focus on End User Response Time End User Response Time © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. 22

» Using Response Time Ensures you Work on the Correct Problem Why Response Time Rocks 23 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Using Response Time Ensures you Work on the Correct Problem » Shows Exactly Why Performance is Suffering Why Response Time Rocks 24 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Using Response Time Ensures you Work on the Correct Problem » Shows Exactly Why Performance is Suffering » Helps Prioritize Problems Why Response Time Rocks 25 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Using Response Time Ensures you Work on the Correct Problem » Shows Exactly Why Performance is Suffering » Helps Prioritize Problems » Do Not Rely Exclusively on Health Stats (CPU Utilization, Disk IO, Cache Hit Ratio) Why Response Time Rocks 26 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» WRITELOG  Waiting for a log flush to complete » LCK_M_S, LCK_M_U, LCK_M_X…  Waiting to acquire locks » NETWORKIO, ASYNC_NETWORK_IO  Waiting on the network » PAGEIOLATCH_SH, PAGEIOLATCH_EX…  Physical disk reads Sample Wait Types 27 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

» Inefficient Queries  Poor Indexing or Lack Thereof *  Poor Database Design *  Inaccurate Optimizer Statistics * » Blocking / Locking * » Excessive Fragmentation * » Execution Plans (nonreusable, compilations) » Improper Log Configuration * » Connection Pooling Problems * - directly solvable using response time methods Performance Issues and Causes 28 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

1. SQL View: All statistics and information at SQL statement level Key Principles of DPA 29 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

1. SQL View: All statistics and information at SQL statement level 2. Time View: Measure Time, not number of times something occurred Key Principles of DPA 30 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

1. SQL View: All statistics and information at SQL statement level 2. Time View: Measure Time, not number of times something occurred 3. Wait State View: Measure every wait individually to isolate source of problems Key Principles of DPA 31 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

1. SQL View: All statistics and information at SQL statement level 2. Time View: Measure Time, not number of times something occurred 3. Wait State View: Measure every wait individually to isolate source of problems 4. Historical View: Store data long term to spot trends, anomalies, relationships and provide easier analytics Key Principles of DPA 32 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Use Case 33 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

DOWNLOAD A FREE TRIAL AT: http://www.confio.com/freetrial Free Trial 34 © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. Stay Connected & Learn More » Stay Connected:  Join the Federal and Government Group on thwack®  Twitter®: @SolarWinds_Gov  Call: 877-946-3751  Email: federalsales@solarwinds.com  Email our Government Reseller DLT®: solarwinds@dlt.com » Learn More:  Visit our Federal website: http://www.solarwinds.com/federal  Watch a short demo video: http://www.solarwinds.com/sedemo  Download a free trial: http://www.solarwinds.com/downloads/

© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED. Thank You! The SOLARWINDS and SOLARWINDS & Design marks are the exclusive property of SolarWinds Worldwide, LLC, are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other SolarWinds trademarks, service marks, and logos may be common law marks, registered or pending registration in the United States or in other countries. All other trademarks mentioned herein are used for identification purposes only and may be or are trademarks or registered trademarks of their respective companies.

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

SQL Server Performance Tuning & Monitoring | SolarWinds

Database Performance Analyzer for SQL Server The fastest way to identify and resolve SQL Server ® performance problems
Read more

SQL Performance Analyzer & Real-Time SQL Monitoring

SQL Performance Analyzer & Real-Time SQL Monitoring. ... This is exactly what you were waiting ... that horrid query that wreaks havoc in your database ...
Read more

Oracle Performance Tuning & Monitoring Software

Database Performance Analyzer for Oracle ... See the impact database performance has on specific ... How would you describe SolarWinds DPA to a ...
Read more

How to analyse SQL Server performance - rusanu.com

Author: Remus Rusanu Subject:SQL Server Blog ... So you have this SQL Server database that your application uses and it somehow seems to be slow.
Read more

Performance data for Log Threads Waiting counter

The Microsoft® Exchange Server Analyzer Tool ... Threads Waiting performance counter of the Database ... you install Exchange Server ...
Read more

Performance Analyzer for Microsoft Dynamics 1.20 ...

Performance Analyzer for Microsoft Dynamics ... Dynamics Application database. 4. Ensure you ... performance data manually instead of waiting ...
Read more

Why is Database Performance Analyzer a Smart Investment ...

Why is Database Performance Analyzer a Smart Investment for Your Team? Faster applications ... or waiting for CPU so you don’t have to guess.
Read more

Tuning .NET Applications in Visual Studio with SQL Tuning ...

It also shows how you can use Oracle Performance Analyzer to ... waiting for performance ... Analyzer results are stored in the database as ...
Read more