My laptop is faster than SQL Azure, latency part 3

Some time back a former colleague of mine posted a blog about the poor performance of SQL Azure databases.

At the time the blog post created a big splash, and quite a few people were debating it and were unhappy about it.

The reality is that things have not changed much since then (the original blog post

Continue reading […] My laptop is faster than SQL Azure, latency part 3 […]

 

Connecting to SQL Server - latency, part 1

After clarifying the terminology in my previous post, it is time to perform some use cases.

In this use case I will take a simple query, like this one:

?Download download.txt1
2
3
4
5
6
7
8
9
10
11
12
13
14
use [AdventureWorks]
 
SELECT TOP 10 [SalesOrderID]
,[SalesOrderDetailID]
,[CarrierTrackingNumber]
,[OrderQty]

Continue reading […] Connecting to SQL Server – latency, part 1 […]

 

Connecting to SQL Server, latency and circles

Recently I wrote about the SQL Server workloads big picture, and now I would like to dig a bit more.

So, what really happens when an .NET application tries to carry out a workload on SQL Server and what consumes time during this process?

Let’s look at the following scenario: we have an application which connects to

Continue reading […] Connecting to SQL Server, latency and circles […]