Learn the Performance Monitor counters to avoid and those to exploit for the latest versions of Microsoft SQL Server from database expert Kevin E. Kline.
Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter). View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch [...]
Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including:
* Hardware design
* SQL Server configuration settings
* Database configuration settings
* Application design
* SQL Tuning
Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure?
Gain insight into best practices for SQL Server optimization and ways to alleviate many root causes that can impact performance of your SQL Server database.
Webcast originally presented by renowned SQL Server expert Kevin Kline and learn valuable strategies for addressing these challenges and more.
Kevin will address challenges and explore methodologies to help you efficiently use allocated disk space for enterprise storage and production environments.
Microsoft SQL Server’s relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provided a much-needed equivalent to Oracle’s long-standing and capable V$ and X$ system views. SQL Server 2008 has provided another dramatic improvement to its instrumentation with [...]
In May, learn about SQL Server architecture and usage from the point-of-view of an Oracle DBA. In June, learn about tuning queries for optimal performance on Microsoft SQL Server databases.