Appendix I: Example SQL Server Machine Configurations
This appendix will describe the configuration of systems used for the examples and wait type demonstrations in this book. If it was necessary to modify the system to demonstrate a specific wait type or situation occurring, those details are included in the text inside the chapter holding the demonstration.
All test systems are virtual machines created inside Microsoft Azure. Each VM was built, then SQL Server installed manually, followed by SQL Server Management Studio v19.0 Preview 1 (16.0.19024.0).
Another tool frequently used during examples is Ostress. Ostress is part of the RML utilities provided to manage your SQL Server’s performance. You can download the RML utilities using this link: ...