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 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.
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 – 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.
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.