Storage

Benchmarking best practices

Posted on

Along with having the right tools, you also need to know what you are hoping to achieve. The makeup of your workload is critical:# IO/sec% read vs % writeavg read sizeavg write size% random vs sequential% cache hit many of these numbers can be identified from a live environment using tools such as perfmon or […]

Storage

Benchmarking storage performance

Posted on

One common question is, is the storage performing properly? One way to tell is to benchmark it. Benchmarking tools:there are lots of tools to run benchmarks, but you want a tool that will allow you to simulate you production workload as close as possible. This includes read/write mixture, %random vs sequential, block size, cache hit […]

SQL

IF EXISTS in SQL

Posted on

For some reason, I always forget the syntax to using IF EXISTS in SQL. Here is a posting that spells it out nicely (http://blogs.msdn.com/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx) SQL: If Exists Update Else Insert This is a pretty common situation that comes up when performing database operations.  A stored procedure is called and the data needs to be updated […]