Browse by Tags

All Tags » Benchmarks (RSS)
28 January 2010 20:38

Index Rebuild Observations

As part of a series of migration tests carrying out an all index rebuild on a user database has been used to compare relative performance. As the application is a true 7 x 24, there are no maintenance windows so index rebuilds are very intrusive and elicit...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
21 October 2009 22:57

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: , ,
04 May 2009 19:53

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: , ,
14 January 2009 20:09

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 | 4 comment(s)
Filed under: , ,
05 January 2009 19:51

Testing Times - mdf fragmentation

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

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,