Connecting to SQL Server Azure - latency, part 2

After setting the terminology, and after performing a simple test case on my local machine, this time I am going to test the latencies of SQL Azure.

I must say that I am as excited as the next guy about Azure, and cannot wait for the solution to become less primitive, so I can use it

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

 

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 […]