Browse by Tags

All Tags » Benchmarks » SAN (RSS)

1 Million IOPS

As a keen follower of storage performance I couldn't help but be drawn to this article in The Register http://www.theregister.co.uk/2010/04/14/lsi_million_iops/ this morning. I gave my 5 year old laptop a new lease of life with a SSD and in combination...

When does 2+2 != 4 ?

Disclaimer: Results and observations are from a specific series of tests using sql 2008 enterprise on windows 2008 enterprise. I've been working on a series of benchmarking tests for an application with the aim of showing scaling of the storage for...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,

Storage – The Final Frontier

This is the presentation for the UK SSUG that I gave the other night. The link below is a pdf of all the slides and the script / notes that I wrote to go with each slide.  I’ve not edited this for style or anything – this is as I worked out what...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,

Tracking contention on the SAN - testing Times

One hotly disputed topic on SAN performance is the matter of contention. This may materialise in the fabric due to over subscription or excessive fan in. A fibre channel fabric is a network which connects servers and storage through switches, just like...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,

Testing Times - mdf fragmentation

NTFS fragmentation degrades SAN performance? Well it does for insane fragmentation....
Posted by GrumpyOldDBA | with no comments
Filed under: ,

Testing Times 3

( I was on holiday for three weeks so sorry for the delays ) In my previous posts I briefly mentioned the task in establishing a method to benchmark a SQL Server new build or migration. This hasn't been an easy task by any means and I am under pressure...