Browse by Tags

All Tags » Benchmarks (RSS)

Benchmarking Hardware and Environments

I suppose it would be fair to say I didn’t pick up the Grumpy Old DBA for no reason, as well as the usual paranoia of a Production DBA , distrust of almost anyone who wants to go near a database and possibly over protective nature regarding databases...
Posted by GrumpyOldDBA | with no comments

A New Record ( How many noughts ????????? )

I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to! One of our production systems has to support a certain element of real...

DBAs should read this post

http://sqlblog.com/blogs/joe_chang/archive/2010/09/28/benchmark-update-astounding-fujitsu-8-way-xeon-7560-tpc-e-scaling.aspx I am a great admirer of Joe's posts, he's been a source of information and inspiration to me for many years and I wish...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: ,

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...

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

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...