Event link at our Meetup page.
- 5:30 pm Networking
- 6:30 pm Meeting
Completing a Performance Assessment and Creating a Monitoring Tool using SSMS, SSRS and just a hint of PowerShell
In this session you will learn how to perform a complete performance assessment on a SQL Server using SSMS and SSRS. We will complete this using a suite of over 140 SSRS reports that includes easy navigation to all report. We will also go over how to create an effective monitoring solution using SSRS, SSM and Powershell. This solution also includes reports that have charts that will make it easy to share with non-technical individuals if needed. Using these reports you will be able to easily identify performance bottlenecks, potential security issues as well as aspects of your server that may not be in line with best practices.
This includes the dashboard you see below as well as a suite of over 180 SSRS reports that can be opened in SSMS.
Below are the many of the reports that are included. We have found these extremely useful in helping us identify performance issues quickly!!!
Manager of Database Administrators, Stericycle
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: Microsoft Certified Trainer; MCTS: SQL Server 2008, Implementation and Maintenance; MCTS: SQL Server 2008, BI Development and Maintenance; MCSA: SQL Server 2008; MCSA: SQL Server 2016; MCSE: SQL Server 2016 – BI; MCDBA: SQL Server 2000; MCSD; MCSE: Data Management and Analytics.