Subscribe to our Newsletter!
If you like our blog posts make sure you subscribe to our newsletter . We will share all kinds of great stuff for FREE!Top Posts & Pages
Categories
Search Results for: Query Store
Query Store for Workload Replays
UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to … Continue reading
Posted in Performance Tuning, SQLServerPedia Syndication, syndication
Tagged Query Store, replay, tsql2day
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help you with your performance tuning process. Today, I am happy to share my first video going over these tools. Using … Continue reading
Posted in SQL Server, SQLServerPedia Syndication
Tagged 24HOP, free tools, performance tuning
How long will this sql server restore take?
Have you ever wanted to know how long its going to take to complete a restore once you issued the restore T-SQL command? The DMV’s can actually give you this information. My script to complete this task is included below.
Posted in Uncategorized
Workload Replay for Azure SQL Database and Amazon RDS
Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how to use the Data … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged aws, azure, Migration, performance tuning, replay
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run faster. Microsoft’s marketing team even jumped on to help coin the … Continue reading
SQL Saturday Chicago
Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends. My talk was on Automating the Pain Away with Query Store and … Continue reading
Posted in Performance Tuning, syndication
Tagged automatic tuning, chicago, SQL Saturday
Why is My SQL Server Execution Plan Changing and How do I fix It!
Have, you noticed an important query suddenly takes longer to run? Have you noticed the execution plan looks completely different than what you normally expect for your query? Today, I talked at the Performance Virtual Chapter going over how to … Continue reading
Posted in Performance Tuning
Calculating DTU in Azure SQL Database
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged Azure SQL Database, DTU, performance tuning, Query Store
My SQL Saturday Houston Story..
This past weekend I had the privilege of speaking at SQL Saturday Houston. I enjoyed catching up with some friends while I also took the time to make some new ones as well. The Talks This year I gave two different … Continue reading
Replication for Azure Databases – #TSQL2SDAY #77
If you’re not familiar, T-SQL Tuesday is a blogging party hosted by a different person each month. It’s a creation of Adam Machanic (b|l|t), and it’s been going on for a long time (77 months to be exact). The host … Continue reading