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

Listing 4. Calculating the BufferCacheHitRatio 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

Listing 7. Collecting SQL Server Agent job information

Listing 8. Creating the row headers for database information

Listing 9. Collecting database information

Chapter 12. Build your own SQL Server 2008 performance dashboard

Listing 1. Query to list dynamic views and functions

Listing 2. T-SQL code for enabling CLR integration in SQL Server 2008

Listing 3. C# code of user-defined function that returns value of a performance counter

Listing 4. T-SQL code for granting UNSAFE permission to the assembly

Listing 5. T-SQL code for adding the assembly and the function

Listing 6. T-SQL code for creating table and generating baseline

Listing 7. T-SQL for evaluating the values of monitored performance counters

Chapter 15. Using SQL Server Management Studio to the fullest

Listing 1. Output query after adding template parameter values