June 11, 2014: Knowing Wait States can Improve Performance

Download Wait Stats material here.
Download Timezone Offset material here.

Trent Mera
Knowing Wait States can Improve Performance
Trent will discuss wait state analytics and how to find which statements hitting your SQL Server will give you the most benefit when tuned. Methods to find bottlenecks at both the server resource and individual statement level will be discussed. Native utilities for accomplishing this will be covered first, and then we will take a look at two Dell Software Tools that use these approaches: Spotlight on SQL Server and Performance Analysis for SQL Server.

    Trent Mera
    Trent has been a Systems Consultant with Quest and Dell Software for 8 years, helping customer to understand, evaluate and use administrative and performance management tools for SQL Server. Prior to Quest/Dell, Trent worked as a development and administrative DBA in the Real Estate, Finance and Defense industries for 7 years.

Paul Turley
Basics: Reporting with Spatial Data
Use SQL Server Spatial objects and SSRS to build a map report solution. Paul will demonstrate the steps to obtain, store and prepare map shapes and mapping data for reporting in actual projects. Data is presented using SQL Server Reporting Services to build a map report with geographic polygons and aggregate data points.

    Paul Turley
    Paul Turley – a Microsoft SQL Server MVP – consults, writes, speaks, teaches, and blogs about business intelligence and reporting solutions. A Mentor with SolidQ, he works with companies around the world to visualize and deliver critical information for informed business decisions. He is the lead author of “Professional SQL Server 2012 Reporting Services” and 11 other titles from Wrox and Microsoft Press.

Register NowDon’t miss this meeting!

Refreshments graciously provided by Quest.

    Featured Sponsor: Quest
    Visit our website for more details.

We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.

This entry was posted in Announcements. Bookmark the permalink.