Ohio North SQL Server User Group

Choose a meeting below to view its details

Meeting Archive




ONSSUG Meeting November 2017

  • In-Person @ 6161 Oaktree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:30 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

We will start with a video recording from last year's PASS Summit. This month we'll hear about Four Ways We Kill the SQL Server Plan Cache by Kevin Kline.

Afterwards, Luis will talk about how amazing PASS Summit was this year, which will be followed by our featured presentation, by... well, Luis.

Please RSVP as usual!




Featured Presentation:

System Dynamic Management Views and System Catalog Views: Is there a point to these?

Luis Gonzalez

System Catalog Views are all about the catalog METADATA in your database. Using basic T-SQL queries they let you look for objects in the database such as Tables, Stored Procedures, Functions, and more. System Dynamic Management Views let you monitor the health of your server instance and database, assist in performance tuning and diagnosing problems. Both can be core sources of information that let you do your job faster and better. Sure, on the surface they can seem rather mundane, but they can save your bacon when your database goes sidewise and you have no idea what’s going on. Join me as we begin our flight at 50,000 feet exploring many of the different types of views available and what they can provide you, then push the yoke forward and dive toward the ground to get a closer look at several in detail. But don’t worry, just as it looks like we’re going to crash and burn we’ll pull back on the yoke and slide in to a smooth landing.

About Luis:

Back to Top