List of Listings
Chapter 9. Capacity planning
Listing 1. Code that returns disk space usage information
Listing 2. Extract CPU utilization with T-SQL
Listing 3. Capturing the number of page reads per second with T-SQL
Chapter 10. Discovering your servers with PowerShell and SMO
Listing 1. Creating an Excel worksheet using PowerShell
Listing 2. Loading the SMO reference library
Listing 3. Creating a Server object from the SMO class library
Listing 4. Creating the column headers in Excel
Listing 5. Collecting the SQL Server instance and machine information
Listing 6. Creating row headers for job information
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
