Tag: sql server
3.48K 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.
11.78K 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...
15.48K Views2 Comments0 Likes
SQL Server MVP Kevin Kline discusses the top 10 administrative mistakes that DBAs make on Microsoft SQL Server. He discusses how most of the mistakes are due to process and business issues instead of issues with technology.
5.64K 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.
7.79K 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.
3.79K Views2 Comments0 Likes
In Part 1 of the DBA Mistakes series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. They discuss disk subsystems and why it’s important to think about not only the amount of disk space but also the IO throughput. They also discuss the importance of testing and benchmarking for your disks.
2.81K Views0 Comments0 Likes
In Part 2 of the series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. They transition from discussing disk subsystems to discussing the issues with accepting SQL Server’s installation defaults. They begin by explaining why you need to set the size of a database when you build it and the issues with not managing virtual log files (VLFs) correctly. They also explain why you should not stick with the default power plan.
2.55K Views0 Comments0 Likes
In Part 3 of the series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. In this video, Kevin, Aaron and Argenis discuss another common DBA Mistake, inadequate preventative maintenance.
3.54K 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.
3.83K Views3 Comments0 Likes
In the Top 10 DBA Mistakes: Horror Stories - Panel Discussion, SQL Server MVPs and SQL Cruise Technical Leads, Kevin Kline, Jes Borland, David Klee, Grant Fritchey, Tim Ford and Aaron Bertrand discuss how they learned the most from their experience as DBAs when things went horribly wrong and why it is extremely important to always be knowledgeable about your systems.
2.65K Views2 Comments0 Likes
In Part 2 of the panel session on DBA Horror Stories, Kevin, Jes, David, Grant, Aaron and Tim talk about how the development of technology doesn’t get rid of the DBA, but forces a shift in jobs for the DBA.
2.22K Views0 Comments0 Likes
In Part 3 of Top 10 DBA Mistakes: Horror Stories! - Panel Discussion, the panel talks about how human error is something that is inevitable and tell more horror stories from their own experiences. They stress how it is always important to prepare for these types of mistakes so you can recover faster when they occur.