troubleshooting sql server com extended events [ex] · 4 considerações extended events introduced...

Troubleshooting SQL Server com Extended Events [EX]

Upload: tranthien

Post on 04-Jul-2018

248 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

TRANSCRIPT

Troubleshooting SQL Server

com Extended Events [EX]

Sr. Database Consultant at Pythian

CEO & Founder of One Way Solution

Sr.Nimbus Consultant

Resulta.DO Consultant

MCT | MCSE Data Platform & BI

Microsoft MVP - SQL Server – 2013 | 2014

In-Memory & Security Specialist

… @luansql

luanmorenodba.wordpress.com

Agenda

Considerações

Key Points

Architecture

Troubleshooting

Considerações

Extended Events Introduced in SQL Server 2008

Improved in SQL Server 2012

SQL Trace Deprecated in SQL Server 2012

SQL Profiler Deprecated in SQL Server 2012

Page 5: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Key Points

What ?

Why ?

How ?

Page 6: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

What ?

Key Points

Page 7: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Light Weight Monitoring & Scalable System

Advanced Event Collection

Perform Performance Troubleshooting

What ?

Page 8: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Why ?

Key Points

Page 9: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Replace SQL Trace

FasterSQL 2014 – 872

Why ?

Page 10: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

How ?

Key Points

Page 11: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

SQL 2008 | 2012 | 2014

Graphical UI – New Session Or New Session

Wizard

Templates

T-SQL

How ?

Page 12: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Extended Event Architecture

Module

Package

Event

Keyword

Binary Files

Modules

Activity

WHO ?

Type Data

Captured

Channel Action Predicate

Filter

Target

WHERE ?

Event

Session

Create/

Start

Page 13: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

DEMO I - Extended

Events Architecture

Overview

Page 14: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Troubleshooting [Extended Events]

Deadlock Problem

Lock & Block

Long Running Queries

Page Split

Wait Stats

Lock Escalation

TempDB Latch

Contention

Deprecated Features

DEMO II –

Troubleshooting

Extended Events

Questions ?

Page 17: Troubleshooting SQL Server com Extended Events [EX] · 4 Considerações Extended Events Introduced in SQL Server 2008 Improved in SQL Server 2012 SQL Trace Deprecated in SQL Server

Thank You for Attending

[email protected]

Software CatalogSQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 ... Visual Basic Visual C++ Visual

sql server dba training | sql server dba training online | sql server dba course

Advanced SQL Server Troubleshooting SQL Server 2008... · Bring your SQL Server Bring your SQL Server installations to installations to a new level of excellence! Advanced SQL Server

Using extended events for troubleshooting sql server

SQL-Server 2012 Always On. SQL Server “SQL-Server 2012” Highlights High Availability SQL Server AlwaysOn Security & Manageability User-Defined Server

SQL Server 2012 Extended Events - sqlbits.comsqlbits.com/Downloads/366/Extended Events - Beauchemin.pdf · SQL Server 2012 Additional Events All Trace Events – Parity with Profiler

SQL Server Heterogêneo: SQL Server + BigData

Best Practices for Deploying Microsoft SQL Server on AWS · Mainstream and extended support for SQL Server 2000 and 2005 has been discontinued by Microsoft1. Any database running

SQL Server 2014 and the Data Platform - EOS Solutions · SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 XML KPIs Management Studio Mirroring Compression

SQL Server Benchmarking The Powershell speedometer Server Benchmarking.pdf · SQL SERVER BENCHMARKING THE POWERSHELL SPEEDOMETER. ... Gather and parse SQL Server information ... SQL

SQL Server DB (dbreport) Report : SQL Server Objects Reportsqlserverbook.sourceforge.net/samples/docbook-full-report.pdf · SQL Server DB (dbreport) Report : SQL Server Objects Report

Chapter 4 SQL. SQL server Microsoft SQL Server is a client/server database management system. Microsoft SQL Server is a client/server database management

SQL Server Data Mining for SQL Server Professionals

TIME FOR A CHANGE: ACCELERATING DATA, ACCELERATING BUSINESS, WITH SQL SERVER … · 2019-10-29 · SQL Server. SQL Server. SQL Server. SQL Server. Electrically isolate workloads for

Extended Security Updates for SQL Server and Windows ...€¦ · If a SQL Server 2008/R2 customer with Software Assurance purchased a number of cores for their on-premises environment,

The challenges, opportunities, and advantages ... - abast.es · [email protected] SQL Migrate from SQL Server & Windows Server 2008 to Microsoft Azure for extended support at no

We Practice What We Teach. Public Web Site Outages Web Servers SQL Server SQL Server SQL Server SQL Server SQL Server SQL Server SQL Server SQL Server

Microsoft Database security and compliance capabilities ...SQL Server 2008 and SQL Server 2008 R2 SQL Server 2008 and 2008 R2 are in extended support which includes security updates,

Informix Guide to SQL: Syntax - RAMMcontent.ramm.com/.../1171591767_Informix_SQL_Syntax.pdf · Informix Guide to SQL Syntax Informix Extended Parallel Server, Version 8.3 Informix

Extended Security Updates for SQL Server and …...What editions of SQL Server and Windows Server 2008/2008 R2 are eligible for Extended Security 11. Do SQL Server or Windows Server

SQL Server Extended Events What, Why, How, Who?. Stuart Moore Started with SQL Server 7 in 1998, 15 years later still working with it, but newer versions

How to Connect to CDL SQL Server Database via Internet · 5. Using SQL Server and SQL Server Linked Server Connect to CDL SQL Server using SQL server Management studio is very easy

Backup service help - SERVER4YOU · Microsoft SQL Server 2014 Microsoft SQL Server 2012 Microsoft SQL Server 2008 R2 Microsoft SQL Server 2008 Microsoft SQL Server 2005 2.4 Supported

Microsoft SQL Server - SQL Server Migrations Presentation

Extended Security Updates for SQL Server and Windows ...download.microsoft.com/download/C/8/5/C851D4E2-ED1F-4F56-AEC0-1561... · For Windows Server 2008 and 2008 R2: Extended Security

SQL Server 2012 Extended Events - Microsoft · Events in SQL Server 2012 SQL Server 2012 adds events for All trace events (that were not in 2008) Including user-configurable events

Microsoft SQL Server 2005. Versioni di Microsoft SQL Server 2005 SQL Server EXPRESS Edition SQL Server MOBILE Edition SQL Server WORGROUP Edition SQL

Modern Storage Strategies for SQL Server - ActualTech Media€¦ · SQL Server I/O Performance 19 SQL Server Workload Patterns 20 Architecting the SQL Server I/O Stack 22 SQL Server

SQL Server and SQL

Table of Contents - Navicat · SQL Server Table Storage 160 SQL Server Views 160 SQL Server Functions/Procedures 161 SQL Server Indexes 163 SQL Server Synonyms 168 SQL Server Triggers

SQL Server Extended Events presentation from SQL Midlands User Group 14th March 2013

[MS-SSSO]: SQL Server System Overview...SQL Server 2008, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2012, and Microsoft SQL Server 2014. The specific release is indicated when

SQL Server Setup - using SQL Server authentication

SQL Server 2012 Extended Events - SQLBits Events - Beauchemin.pdf · SQL Server 2012 Additional Events All Trace Events – Parity with Profiler Extended Events User Interface in

Installin SQL Server 2014 CTP2 without error - WordPress.com · Upgrade Advisor analyzes any SQL Server 2012, SQL Server 2008 RI, SQL Server 2008 or SQL Server 2005 components that