Connecting to SQL Server - latency, part 1

RIL_button( “http://sqlconcept.com/2012/12/18/connecting-to-sql-server-latency-part-1/”, “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]

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

December 18th, 2012 | Category: Benchmarking, CPU, Memory, SQL Latency Monitor | One comment - (Comments are closed)
Work on itWell, now...OKGoodGood job! (2 votes, average: 4.50 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Pushing the boundaries, going forward

RIL_button( “http://sqlconcept.com/2012/12/11/pushing-the-boundaries-going-forward/”, “Pushing the boundaries, going forward” );

Ever since I remember myself, when I was 3 or so, I remember having this big fat constantly hanging question “And what if I try this?“.

The question itself is simple, but it is so alluring that it is impossible to resist.

And it does not come cheap: I have

Continue reading [...] Pushing the boundaries, going forward [...]

December 11th, 2012 | Category: Baselining, Benchmarking, CPU, Disk System, IO, Memory, Performance audit, Pushing the limits, Query Optimizer, SQL Azure | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Query the cached plans: Implicit conversion

RIL_button( “http://sqlconcept.com/2011/07/12/query-the-cached-plans-implicit-conversion/”, “Query the cached plans: Implicit conversion” );

As I have written previously, the Implicit Conversions can be a performance problem and they can be easily avoided.

Also, as a next step on the road of cache analysis, here is a script which will show the Implicit Conversions in the “snapshot of your cached plans”.

July 12th, 2011 | Category: Baselining, Memory, Performance audit, SQL Server metadata, T-SQL | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »