Comments for cbailiss

Comment on GA Performance in New Azure SQL Database Performance Tiers by Elliot Keller

Elliot Keller — Tue, 01 Apr 2025 21:30:02 +0000

Thanks great blog posst

Comment on Windows Phone 8: LongListSelector Memory Leak by Bobby

Bobby — Fri, 04 Oct 2024 11:08:31 +0000

Hi grreat reading your post

Comment on GA Performance in New Azure SQL Database Performance Tiers by Dramatic decrease in SQL Azure performance after scaling to new edition

Dramatic decrease in SQL Azure performance after scaling to new edition — Sun, 09 Jul 2023 16:52:32 +0000

[…] A helpful benchmark of Azure SQL Database. […]

Comment on Power BI Nullable Column Merge Join Problems by Power BI: Merge Joins and Nullable Columns – Curated SQL

Power BI: Merge Joins and Nullable Columns – Curated SQL — Tue, 06 Sep 2022 12:05:18 +0000

[…] Chris Bailiss dives into some join problems in Power BI against Snowflake and SQL Server: […]

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by SQL Server Performance Benchmarking with Patterns – Paul Brewer

SQL Server Performance Benchmarking with Patterns – Paul Brewer — Mon, 02 Oct 2017 19:43:15 +0000

[…] SQL Azure Performance – https://cbailiss.wordpress.com/2015/01/31/azure-sql-database-v12-ga-performance-inc-cpu-benchmaring/ […]

Comment on Microsoft Azure SQL Database Performance Tests: Summary by Azure SQL – Transaction rate per hour Explained | Blake's Application Development Blog

Tue, 30 May 2017 20:31:28 +0000

[…] https://cbailiss.wordpress.com/2014/07/06/microsoft-azure-sql-database-performance-tests-summary/ […]

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by Marek Jablonski

Marek Jablonski — Sat, 11 Mar 2017 09:06:07 +0000

Hi 🙂

A very good and thorough article. I have conducted similar observations in December 2016 and there is still much that can be improved in SQL Azure before one can call it a mature stable platform.
Feel free to look at the article I’ve written.

Click to access Azure%20%20performance%20report%201-2017-EN1.pdf

Regards
Marek

Comment on Azure SQL Database: V12 Preview Performance Tests – Significant Performance Increase by nestiranude

nestiranude — Sun, 26 Feb 2017 20:05:42 +0000

Great blog, Just wanted to comment that i can not connect to the rss stream, you might want install the right wordpress plugin for that to workthat.

Comment on GA Performance in New Azure SQL Database Performance Tiers by cbailiss

cbailiss — Wed, 26 Oct 2016 07:04:33 +0000

In reply to Steve Collins.

No, normal disk based tables.

Comment on GA Performance in New Azure SQL Database Performance Tiers by Steve Collins

Steve Collins — Tue, 25 Oct 2016 21:30:46 +0000

Question: are you using memory optimized tables in the premium service tiers?

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by Comparing Cloud providers for new product development | 神刀安全网

Comparing Cloud providers for new product development | 神刀安全网 — Wed, 18 May 2016 19:11:58 +0000

[…] (1x B, 1x S2) it is very difficult to convert DTU to server. So, I just guess it from this review […]

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by Insert data in SQL Server at high speed (Part 1) – MenzoS Data Blog

Insert data in SQL Server at high speed (Part 1) – MenzoS Data Blog — Thu, 12 May 2016 13:42:22 +0000

[…] Taken from: https://cbailiss.wordpress.com/2015/01/31/azure-sql-database-v12-ga-performance-inc-cpu-benchmaring/ […]

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by Azure SQL Database Pricing – Curated SQL

Azure SQL Database Pricing – Curated SQL — Mon, 25 Apr 2016 12:35:51 +0000

[…] For further information, check out this interesting article from a few months ago on V12 performance by Chris Bailiss. […]

Comment on Microsoft Azure SQL Database Performance Tests: Summary by Josh Mouch

Josh Mouch — Thu, 14 Jan 2016 17:57:12 +0000

You mention that the new tiers have an initial “burst” where they’re fast, but then slow down significantly. From what I’ve read, the tiers limit the number of transactions you can have before you are throttled. The B1 is like 5 per second. Is this the cause of the huge performance difference?

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by paulbrewer

paulbrewer — Thu, 17 Dec 2015 11:26:55 +0000

In reply to Gaz.

Hi Gaz,
Thanks for the prompt, I didn’t realise we could scale our MSDN SQL Azure settings and try the other Performance Levels. The differences at the higher levels (S2 & S3) is really significant, as you suggested it would be.
Best wishes
Paul

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by SQL Azure Performance Benchmarking | PaulBrewer@Yahoo.co.uk

SQL Azure Performance Benchmarking | PaulBrewer@Yahoo.co.uk — Thu, 17 Dec 2015 11:17:58 +0000

[…] SQL Azure Benchmarking – https://cbailiss.wordpress.com/2015/01/31/azure-sql-database-v12-ga-performance-inc-cpu-benchmaring/ […]

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by Gaz

Gaz — Tue, 15 Dec 2015 10:52:23 +0000

Hi Paul,

One of the flaws (in my view) of Azure’s model is that the databases are throttled to allow Microsoft to apply a tiered pricing plan. The default database is an S0, which is so heavily throttled in so many ways that it’s near useless. I find that an S2 is the minimum requirement for a database which gets hit regularly.

You do see significant changes as you move up the Azure pricing models.

It might be worth you running your tests on an S2 or S3 and see how that affects your results.

Comment on Azure SQL Database: v12 GA Performance inc. CPU Benchmaring by paulbrewer

paulbrewer — Sun, 13 Dec 2015 16:23:35 +0000

Hi Chris,
This is a really good and interesting article, thanks, it includes a lot of useful information explained clearly. I benchmark tested a SQL Azure database recently and found performance slow and erratic in comparison with on premise virtual and physical SQL instances.

https://paulbrewer.wordpress.com/2015/12/03/sql_heartbeat-technical-summary/

Best wishes
Paul

Comment on Microsoft Azure SQL Database Performance Tests: Sequential Selects by sql azure vs azure VM with SQLServer Express – segmentfault

sql azure vs azure VM with SQLServer Express – segmentfault — Mon, 02 Nov 2015 01:18:45 +0000

[…] in this post: https://cbailiss.wordpress.com/2014/07/06/microsoft-azure-sql-database-performance-tests-sequential-s… The start of this test (a sequential read from disk) does show a small increase / higher burst rate […]

Comment on Microsoft Azure SQL Database Performance Tests: Database Import, Copy and Restore – Write Rates by Alexandr Marchenko

Alexandr Marchenko — Thu, 08 Oct 2015 12:30:43 +0000

I’m currently trying to import 11 GB bacpac and in my case I do have something around 5 GB/hr in P1 tier, so it seems that P6 will be event cheaper