Tag: sql server
5.80K Views0 Comments0 Likes
This video is part of the Getting Started Series found on the SQL Sentry client software start page. These videos are intended to give you a basic understanding of some of the features of the product. This video will ...
38.89K Views0 Comments0 Likes
In this video, renowned query tuning expert and Microsoft Data Platform MVP Aaron Bertrand looks at the brand new release of SQL Sentry Plan Explorer, the industry's most popular free query tuning tool.
3.88K Views0 Comments0 Likes
The SQL Sentry BI Suite provides a performance monitoring solution for the entire Microsoft BI platform by combining SQL Sentry Event Manager, Performance Advisor for SQL Server and Performance Advisor for Analysis Services.
4.03K Views0 Comments0 Likes
In this session, Niko Neugebauer looks at the columnstore indexes and discusses how they've improved in SQL Server 2016. About the speaker: Niko Neugebauer works as a BI Consultant for OH22, which creates int...
4.10K Views0 Comments0 Likes
In this video, Scott Fallen, one of our Sales Engineers, looks at one of our newest features, custom conditions. He starts out by discussing how custom conditions work and how it’s different from anything available in other alerting systems. He also shows some example conditions, which are available in our starter custom condition package.
6.19K Views0 Comments0 Likes
In this video, SQL Server MVP Kevin Kline discusses how to go about troubleshooting and performance tuning your Microsoft SQL Server without any paid professional tools. He goes through his methodology for troubleshooting, which he has learned over the course of many years of trial and error.
2.20K Views0 Comments0 Likes
SQL Server’s plan cache is one of the largest regions of memory and is used to store SQL and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of code you write and the way you invoke that code can have an enormous impact on how the plan cache is maintained, tuned, and optimized.
8.81K Views0 Comments0 Likes
In this video, Scott Fallen shares tips on how to get started with execution plans. He discusses what an execution plan is and why they are important. He also walks through a couple of sample plans.
2.43K Views0 Comments0 Likes
SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s different cloud services and how they relate to traditional SQL Server services. Gavin then suggests how these cloud services can then be used with existing on-premises data platforms to create hybrid solutions – something that’s becoming popular with businesses of all sizes.
2.17K Views0 Comments0 Likes
SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s diffe...
12.29K Views0 Comments0 Likes
The SQL Sentry Power Suite provides a complete performance monitoring and optimization solution for Microsoft SQL Server by combining both Performance Advisor for SQL Server and Event Manager in the same console...
3.24K Views0 Comments0 Likes
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. You sta...