When it comes to troubleshooting in relational databases, there’s no better place to start than wait statistics. In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular resource, activity, or process. Since wait statistics are categorized by type, one look will quickly tell […]
Kevin describes three of his favorite tools for running highly scalable database benchmark tests: the free, open-source HammerDB, the native SQL Server Distributed Replay Utility, and the commercial Benchmark Factory from Dell / Quest Software. Plus, a recap of his entire series of articles on database benchmarking.
In this portion of the series on database benchmarking, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING.
Today, I would like to give you a primer on how to read the benchmark reports that are published by the major database and hardware vendors.
Introduction to TPC Database Benchmarks Let’s talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I’ll give you a […]
Get the details on Kevin’s keynote address at the SQLintersection conference in Las Vegas in early April.
Kevin provides two new session slide decks and tells about his week presenting sessions in Colorado from August 14-17, 2012.
If you’re struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap!
Learn about HP and Microsoft reference architecture for very high performance OLTP applications from Shashank Pawar of Microsoft Australia.