Data Platform Summit 2019 Announced
We are very glad to inform you that Data Platform Summit 2019 has been announced. The 3-Day Summit will be on August 22, 23 & 24 and the Pre-Cons on August …
Data Platform Summit 2019 Announced Read MoreVideos & Webinars
SQL Server Performance Tuning Master Class by Amit Bansal – March 12 & 13, 2019
Amit Bansal will be delivering his world renowned master class online on SQL Server Troubleshooting & Performance Tuning on March 12 & 13, 2019. All Developers & DBAs out there, do …
SQL Server Performance Tuning Master Class by Amit Bansal – March 12 & 13, 2019 Read MoreSQL Server Index Internals – Multiple Index Hints by SSMS
In this video, you will see that SQL Server can, sometimes, recommend more than one index hint for a given query, but it is not so evident. You can also visit …
SQL Server Index Internals – Multiple Index Hints by SSMS Read MoreTroubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type
In this video, you will understand how to use PAGEIOLATCH Wait Type metrics to detect/identify IO slowdown. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and to …
Troubleshooting SQL Server IO Performance/Bottleneck – Part 4 – PAGEIOLATCH Wait Type Read MoreTroubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries)
In this video, you will understand how to detect/identify most expensive IO queries/workloads. Or in other words, how to find out queries that are causing maximum IO in SQL Server (Top …
Troubleshooting SQL Server IO – Part 3 (Most Expensive IO Queries) Read MoreTroubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read)
In this video, you will understand how Avg. Disk sec/Read performance monitor counter can be used to identify/detect/compute read latency on slow IO. You can also visit DataPlatformGeeks (DPG) Video Library …
Troubleshooting SQL Server IO – Part 2 (Avg Disk Sec per Read) Read MoreTroubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats)
In this video, you will understand how sys.dm_io_virtual_file_stats can be used to identify/detect/compute read latency on slow IO. You can also visit DataPlatformGeeks (DPG) Video Library to watch more videos and …
Troubleshooting SQL Server IO – Part 1 (sys.dm_io_virtual_file_stats) Read MoreHow is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1
In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS …
How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 Read MoreSQL Server Missing Index Hints Missing
Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin. SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter Thanks for reading & watching. …
SQL Server Missing Index Hints Missing Read MoreSQL Server Statistics – Are My Stats Objects Being Used?
In this video, you will learn some quick techniques to identify which stats objects are being used by the SQL Optimizer. These techniques can help you in your query tuning endeavors. …
SQL Server Statistics – Are My Stats Objects Being Used? Read More