'Sql text' diaporamas de présentation

Tim Quinlan TLQ Consulting Inc.

Guaranteeing High Performing SQL through Plan Stability and Management. Tim Quinlan TLQ Consulting Inc. Plan Stability. Part 1: Taking advantage of Plan Stability. What is Plan Stability and why do we need it? Getting started, turning it on and capturing outlines.

1.16k views • 96 slides

637 views • 50 slides

Chapter 22

Chapter 22. Database Troubleshooting. Introduction to Database Troubleshooting. DBAs need to be experts at database troubleshooting. There are a wide variety of topics covered in this chapter: Assessing database availability issues quickly.

468 views • 35 slides

Oracle Database 18c New Features Hariprasath Rajaram

Oracle Database 18c New Features Hariprasath Rajaram. Training Objective. Oracle Cloud Free Account 18c Database Creation 18c Dataguard MEMOPTIMIZE_POOL_SIZE in SGA Cancel SQL Instead of Killing Session Pre-Upgrade Utility (Doc ID 884522.1 ) SQLPLUS New Options

362 views • 31 slides

Building a Performance Monitoring System using XEvents and DMVs

544 views • 28 slides

Life Without Tools: Monitoring Database Activity With The Power Of SQL

Life Without Tools: Monitoring Database Activity With The Power Of SQL. Malesh Gummula Independent Consultant. Quick Overview of Typical Monitoring Views. Who Is Logged On?. The V$SESSION view contains information on all active sessions:.

294 views • 27 slides

SQL Server 2012 Extended Events

SQL Server 2012 Extended Events. Agenda. SQL Server 2012 Extended Events About me New & improved Extended Events Event Tracing for Windows XEvents basics & concepts DEMO XEvents Tools. Gareth Swanepoel From South Africa originally Been in IT for 22+ years

620 views • 18 slides

Spatial Data Types And Indexing SQL Server 2008

Spatial Data Types And Indexing SQL Server 2008. Bob King. Data Types. geometry Planar data geography Geodetic data (projection of the curve of the Earth) Represents points, polygons, regions, etc. in the same data type. Common Methods. Contains Distance Equals Intersects

178 views • 6 slides