Free (Email Address-ware) "Performance Tuning with SQL Server Dynamic Management Views" eBook from Red Gate
"Dynamic Management Views (DMVs) reveal the hidden activity of your database sessions and transactions – and this book is packed full of practical advice on getting to grips with them.
Download your free copy of Performance Tuning with SQL Server Dynamic Management Views by Tim Ford and Louis Davidson to demystify DMVs. The eBook provides you with the core techniques and scripts to monitor your query execution, index usage, session and transaction activity, disk IO, and more.
You can track down and fix even more SQL Server problems with the SQL DBA Bundle. You’ll get web-based monitoring and six more tools to support your core SQL Server administration tasks, so pick up a free trial and put your new knowledge into practice.
1. Free eBook: Performance Tuning with SQL Server Dynamic Management Views
- Root out the queries that are causing memory or CPU pressure on your system
- Investigate caching, and query plan reuse
- Identify index usage patterns
- Track fragmentation in clustered indexes and heaps
2. Free trial of the SQL DBA Bundle
- Real-time performance data and alerts
- Built with advice from SQL Server experts and MVPs
- Compress SQL Backups by up to 95%
- The industry-standard schema and data
With the advent of the Dynamic Management Objects (DMOs) in SQL Server 2005, Microsoft vastly expanded the range and depth of metadata that could be exposed regarding the connections, sessions, transactions, statements, and processes that are, or have been, executing against a database instance. These DMOs provide insight into the resultant workload generated on the server, how it is distributed, where the pressure points are, and so on, and are a significant and valuable addition to the DBA's troubleshooting armory.
In short, if you look hard enough, you will find an almost overwhelming amount of data regarding user activity on your SQL Server instances, and the CPU, I/O, and memory use and abuse that results. The focus of this book is squarely on core engine activity, and troubleshooting. We'll describe the most important columns that these DMOs return, and provide a core set of scripts that can be saved and adapted for your own environment, to shine some light on previously dark corners of SQL Server performance optimization. In the process, we'll cover about a third of the total number of available DMOs, spanning 6 of the available 19 categories of DMO, outlined below.
Full time DBA, or accidental, this free 337 eBook is one that's going to be hard to beat. Normally these run 60+ bucks, so get it... get it now (or later, it should be around for a while... ;)
Related Past Post XRef:
“The SQL Server DMV Start Pack” (eBook and T-SQL) from Red Gate and more Dynamic Management Views (DMV) stuff