Guru's Guide to SQL Server Architecture and Internals, The

List of Exercises

Exercise 3.1 Monitoring Process CPU Usage

Exercise 3.2 Monitoring Thread Creation in SQL Server

Exercise 3.3 Listing Modules and Processes within SQL Server

Exercise 3.4 Exceptions in Extended Procedures

Exercise 3.5 Displaying Thread Information Using a Debugger

Exercise 3.6 Running SQL Server at Real-Time Process Priority

Exercise 3.7 Determining How SQL Server Sleeps

Exercise 3.8 Viewing Thread Priorities, Affinities, and Other Useful Information

Exercise 3.9 What Happens When Threads Aren't Synchronized?

Exercise 3.10 Implementing a Kernel Mode Spinlock by Using a Mutex

Exercise 4.1 NULL Pointer References

Exercise 4.2 An Obscured NULL Pointer Reference

Exercise 4.3 A NULL Pointer Reference Due to a Memory Overwrite

Exercise 4.4 A GetSystemInfo ...