Organizations using SQL Server and other database technologies often take for granted that «it just works». Well, it does work when used correctly, more specifically, it does work as long as you use it correctly. However, casual DBAs, as well as inexperienced BI engineers or application developers can easily crash your production server with bad queries.
To get a better understanding of your SQL Server performance, discovering issues and addressing them, you need to establish a proven monitoring solution. And you don’t need anything overcomplicated at this step because all the metrics are already available. All you need to do is utilize business intelligence tools to visualize the SQL Server key performance metrics.
At the webinar, we will share this knowledge with you. Watch the webinar recording to learn how you can build an effective solution for the key performance metrics of your SQL Server database using common BI tools. This webinar session applies to all who use SQL Server and need to troubleshoot performance issues.
I started my database career in 1982 with the US Coast Guard by creating one of the first vessel tracking systems using the Pick operating system and later with dBASE II on CP/M.
In 1987, I landed at Ashton-Tate and eventually Borland as a developer working on the dBASE product line. At that time, I got my first exposure to the Microsoft, Ashton-Tate, Sybase SQL Server running on OS/2 where I wrote compatibility and performance test suites for the platform.
In 1995, I joined Microsoft as a program manager in Visual Studio working on database design tools for SQL Server and Oracle. I spent several years in Microsoft Office working integrating SharePoint and SQL Server with Access as part of the XP release. I then had the privilege of being a lead program manager for Excel, Access, and VBA for the Office 2003 release.
At the tail end of 2003, I had a chance to work with another great team in developing the manageability and performance troubleshooting tools for SQL Server Management Studio across the SQL Server 2005, 2008, and SQL Server 2008 R2 releases. I want to think I was part of the team that made SQL Server for the masses.
Now, as a Chief Technology Storyteller at DB Best, it’s my job to define the services that DB Best provides to its customers. More importantly, tell the customer success stories in blog posts, webinars, and training events to help people better understand the latest technologies and how they can move forward with their digital transformation efforts. I also work on customer projects as a solution architect.
How can you identify underutilized SQL Server instances? Which performance counters are immediately available out of the box? How can Power BI help visualize your data?
Even if you feel highly satisfied solving performance problems, there always is an alternative way of preventing issues.
Watch the video recording of the webinar below to discover this way.
Do you want to raise your skills with DB Best’s prolific cloud experts and technology evangelists?
Join our mailing list and stay tuned about the next webinars and events from DB Best.
Like what you see? DB Best has held quite a few interesting webinars on data management. Check out the links below.
The webinar highlights architecture solutions, latest technologies, and operational maturity.
Our celebrity speaker shared his overwhelming experience with different cloud platforms. Discover how the latest technology may help your customers improve their business. Learn the professional approach to the optimization of enterprise-grade applications.Подробнее
The webinar is all about using data the right way.
Our seasoned speaker shows what it takes to spot the right pieces of data, extract them gently, and make use of them. For that measure, Ilya breaks down this process and showcases the best data collection and visualization techniques you will find on the market. Learn how to make data work for you and your product.Подробнее