Geek Sync Webcast : Care and Feeding of Your System Databases
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You’ll leave with a better understanding of these shared resources and how they affect your database applications.
Topics :
Products :
With 14 years of professional software development experience, Vicky Harp is always interested in learning new ways to improve performance and maintainability of database code. Vicky is a product manager with Idera, where she has worked for the past 10 years creating software to make DBAs’ lives easier. She speaks frequently at PASS events and is active on Twitter.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.