Whitepaper : DBA Automation in SQL Server & Azure SQL Database

Database administrators (DBAs) have been hearing about how robots in SQL Server and Azure are going to be taking their jobs by automating performance tuning. However, most of these claims are just marketing hype that Microsoft is using to sell the latest versions of their products.

This whitepaper blows the marketing smoke away on these solutions by explaining their latest features and identifying the ones that are ready for prime time. This information will better prepare you for discussions about whether you should upgrade and how you can use the robots in SQL Server and Azure SQL Database to do your job better.

The whitepaper discusses:

  • DBA automation in SQL Server and Azure SQL Database
  • batch mode execution
  • TVF interleaved execution
  • scalar function inlining
  • adaptive memory grants
  • adaptive joints
  • automatic tuning

Author: IDERA

Register to read the full whitepaper.

Topics : Cloud Databases,Database Administration,Database Backup,Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Whitepaper

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.