The Voice of the DBA Testing at Scale

MEVIOtoday

Nov 15, 2009 Testing at Scale

One of the things that I often hear from large companies is that they spend time testing systems, burning them in, and looking at the ways different configurations might affect their applications. However in so many of the companies I've worked for, we haven't the extra hardware or luxury of time to test different configurations, or even alter our configuration once we have hardware. It seems to fall to the DBA to "guess" right from the start about the specifications needed for new servers.

That got me thinking about something that would be handy for examining hardware. What if a tool could take the workload of a server, looking at the volume of queries, and then determining the rate, ratio, and types of I/Os that the application performs. Rather than look at the queries, look at the work that the queries do.

Read the rest of Testing at Scale at SQLServerCentral.com