Webcast : Capacity Planning Done Right for SQL Server
Capacity planning, especially when done for SQL Server, is not for the faint of heart. Storage and disk capacity are obvious, but when you want to right size your database(s) for a new SQL implementation or migration, there is a lot more than space to think about. Of course, sizing and future growth must be considered. In addition, we also have to consider design, configuration, and other important resources to ensure your new SQL Server is performing optimally.
Penton Tech contributing editor and industry expert Robert Pearl digs into what you need to equip yourself with – and how you need to plan – before you deploy your next SQL Server. This will include disk size, memory, I/O, indexes, transaction logs, file growth, current utilization stats, and more.
Subsequently, Bullett Manale from IDERA will discuss how to gather data concerning the current usage and growth trends of databases for capacity planning. In this session, you will view database capacity usage for data and logs; see database file statistics for available and used space for data and logs; review and compare metric and baseline statistics; identify fast-growing tables; predict future disk space, database, and table needs from growth forecasts. You will also see how to create custom usage and trend reports using any pre-defined and custom counters.
IDERA’s VP of Sales Engingeering, has been working in technology for over 25 years. Starting as a tech support technician for Iomega supporting their backup software, he has since been a technical trainer and consultant for Deloitte, a sales engineer at Centerbeam, and a project manager at Shell Oil Company.
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.