What is Azure SQL? In the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite. Microsoft is grouping all the options for SQL running in the Azure platform into one portfolio.  A family of managed products, making it easier to see them and choose the best for your needs. … Read more

Case study #16 Here is another recent SQL Server performance tuning report. The stored procedure below was one of the most called on the client’s SQL Server. Improvements achieved CPU from 50 to 1 Reads from 2,496 to 8 Duration from 227 to 1 What changes made this query run faster? Dropped the IX_ClientID_OrderDate; Added … Read more

Real sample #15 Here is another recent SQL Server performance tuning report. Improvements achieved CPU from 125 to 18 Reads from 21,737  to 18,411 Duration from 180 to 1,271 Before vs After The green block below shows SQL performance numbers after we made some changes in the database to improve slow SQL calls. What changes … Read more

Today I am sharing another MS SQL Performance tuning report from recent tuning. Improvements after Red9 SQL Server tuning  After making a couple of small tweaks to the SQL Server stored procedure we were able to get few improvements Run time duration improved by: 636% CPU improved by: 377% Disk improved by: 312% Overall stored … Read more

FREE Scripts to Instantly
Improve SQL Server Performance

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.