Stop Indexing the Query!
Learn Ways to better tune and Optimize your Queries
If you are like me, when doing tuning and optimization efforts, you tend to find a long running query or a query consuming a lot of resources in the form of logical reads. We dig into these queries and many times, we find that it could benefit from an index or adjusting an existing index.
So, we do that. However, what did we just do to the overall workload? Was it good, bad, or indifferent? Watch now as I explore an alternative approach to tuning/optimizing.
Cross-platform database monitoring and management software built for SQL query performance monitoring, analysis, and tuning.
The Database Self Hosted License provides access to Database Performance Analyzer or SQL Sentry to monitor and optimize multiple database types for cloud and on-premises environments.
More resources similar to this
How to Build a Basic Data Dictionary
In this session, we’ll teach you three methods for building a basic data dictionary useful for database administrators (DBAs), data engineers, and developers.
View Webcast