Capacity Planning Strategies for SQL Server

There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or migration, there is a lot more to think about than space.

Of course, you need to consider sizing and future growth. Also, we also have to consider design, configuration, and other essential resources to ensure your new SQL Server is performing optimally.

DBTA recently held a webinar with Dan Cardino, Sales Engineer, IDERA, who explained how IDERA SQL Diagnostic Manager can help gather data concerning the current usage and growth trends of databases for capacity planning.

IDERA is a software company based in Texas and is a market leader in database lifecycle software, Cardino explained, with over 20,000 customers, and an active community upwards of 60,000 users.

The company offers tools for SQL server and application management including a broad range of tools in categories such as:

  • Security
  • Backup and recovery
  • Inventory
  • Business intelligence

The SQL Diagnostic Manager can provide:

  • Real-time and historical analysis
  • Pinpoint poor performing code
  • Baseline performance
  • Flexible responses to issues
  • Prescriptive analysis
  • Reporting
  • Remote management
  • Customization
  • Interface
  • Metrics
  • Reports
  • Alerts
  • SCOM integration
  • Monitor virtual servers

An archived on-demand replay of this webinar is available here.