22-25 April 2026
SQLBits 2015

The Developer Side of SQL Server Monitoring and Diagnostics

The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. Many DBAs have large collections of gathered spells with DMVs/DMFs and scripted Extended Events sessions. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#. Empower your daily tasks and in case of an emergency yourself and your colleagues with a perfect customized toolkit to visualize your workloads and find quickly the gremlins.

Speakers

Sascha Lorenz

Sascha Lorenz's previous sessions

First Dates: AI & DBAs. Any Chance to be a perfect match?
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
 
The Developer Side of SQL Server Monitoring and Diagnostics
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
 
The Developer Side of Master Data Services
The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. Take your MDS Project on a higher level.
 
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
 
The Developer Side of the Microsoft Business Intelligence stack
The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects. The session will explain the hidden power of using the Microsoft APIs to build BI middleware solutions for enterprise customers.