Scalability. Server. Optimization. Load. Speed. Benchmarking. BizTalk Server 2006: Managing a Successful Performance Lab. If you currently have production-load arriving into another system (perhaps a system you are about to upgrade or replace) you may be able to replay an actual day’s captured load or route/duplicate the day’s normal messages over to the testing environment.
However, this approach may not allow for the control and repeatability that is often desired in a performance lab. To obtain a more scientific approach, load-generation tools can give you the ability to produce predictable and repeatable load patterns, measure throughput and latency with accuracy, and still closely simulate actual production volumes with precision. The following sections offer some suggestions for establishing such a testing regime and producing load. Running Automated Tests. QuickCounters. The Cost of GUIDs as Primary Keys > Natural or Surrogate Keys. In this article, Jimmy Nilsson presents the pros and cons of using globally unique identifiers (GUIDs) as the datatype for primary keys in SQL Server 2000.
In doing so, he shows you test results that hint of performance characteristics and introduces you to a special type of GUID that he invented, called COMBs, that solves what otherwise might give you a big throughput problem. In this article, I will be discussing the pros and cons of using globally unique identifiers (GUIDs) as the datatype for primary keys in SQL Server 2000. You will see concrete test results that give a hint of the performance characteristics.