Home » Performance Tuning
Power BI Performance Tuning: Data Model
There are many opportunities for performance tuning in Power BI. The main areas are the data model, visualization pane and the service. Power BI always starts with data. Once the data is modeled, the visualizations can be created….
Read More »Query Store follow up – PASS Performance Marathon
Here are some answers to questions from PASS Performance Marathon presentation on Query Store: An Introduction 1. To turn on/off Query Store, will it impact DB availability? (meaning DB does not need to be offline) No, turning off…
Read More »Query Data Store–SQL Server 2016
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to do performance tuning on T-SQL queries. This new feature of SQL Server 2016 is contained within a database…
Read More »SQL Server 2016–Live Query Statistics
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while the query runs. Never saw that coming. And even a bonus, you can use SQL Server 2016 Management…
Read More »Live! 360–Speaking at SQL Server Live Orlando 2016
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The…
Read More »Cost Threshold and Max Degree of Parallelism
SQL Server has many options for configuring a database system. Most do not become apparent until some part of the system does not function “properly”. Parallelism is one of these settings. You will see Waits for Parallelism and…
Read More »