SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Interesting Article about Measuring Performance in Software Test Mag

The Jan 2008 issue of Software Test & Performance Magazine  (available as free PDF download, you can also download back issues through 2004) has an article called 'Gauging Performance in the Absence of Metrics' that I found interesting. From a SQL perspective it's a good read because it talks about how you decide what is fast enough and it takes into account there are a lot of pieces vying for time; UI, network, database. It also talks about setting goals for concurrency and how it's possible to acheive the goal but still not hit the mark because of the way the goal is described.

To some degree it's all in how you write the requirements (tests)! It's not often we (DBA's) get a real definition of how fast anything needs to be, in practice we just try to make everything fun fast! Not the worst strategy, but all tuning is about trade offs and having some real values to hit would help us assess the trade offs in formal fashion. If nothing else this is an interesting view into the world of the tester and I suspect we all agree that we could stand to improve our testing.


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


No comments.

Leave a Comment

Please register or log in to leave a comment.