Browse by Tags

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 with the old drive made external managed to...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Thu, Apr 15 2010
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 future growth. Essentially we were attempting to...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Oct 21 2009
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 I’d say so some of it may not make complete grammatical...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, May 4 2009
NTFS Fragmentation may be more harmful than you think

I’ve posted previously about the adverse affect of ntfs fragmentation and I’ve also mentioned that it is sometimes suggested that fragmentation is not a concern on a SAN. I’ve yet to finish testing this on a SAN, after all you don’t often get a free play with a SAN for this type of testing, but I did...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Mar 4 2009
Thin Provisioning and ntfs

I'm currently working on a SQL Server storage project and as part of that I'm touching a number of areas that may be of interest to the DBA. The IT industry is full of buzz words, new fads, fashionable terms and so on; and Thin Provisioning was something I was aware of but not fully informed...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Thu, Feb 26 2009
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 an Ethernet network connects us to the internet...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jan 14 2009
Testing Times - mdf fragmentation

Now I've never been convinced that file level fragmentation is irrelevant on a SAN, at least two sources have assured me that this is the case, but then they also assured me of a number of other points most of which it appears I have proved to be basically incorrect. < grin > Now I've followed...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, Jan 5 2009
CompareStorage@GrumpyOldDBA

As a slightly seasonal touch of lightness I though I’d just do a comparison of DAS and SAN storage Item DAS SAN Basic Storage Cost Good Hideously expensive Ease of Use Simple How many storage engineers and system administrators does it take to change a lun ? Performance Monitoring Easy Almost Impossible...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Dec 31 2008
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 not to make any posts based around non disclosure...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Sun, Nov 23 2008
Testing Times 1

It's an interesting time with being asked to performance test/benchmark a new server setup for a migration of sql server and data centre. Both current and new servers are SAN attached and it has been what is effectively the testing of the storage which has proved interesting. To add to the mix I...

Posted to Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Oct 7 2008

Page 1 of 2 (13 items) 1 2 Next >