STAREAST 2025 - Performance Testing
Wednesday, April 30
SQL Server Indexing Strategies Using Query Store for Improved Performance in Retrieving Data
In the realm of database management, optimizing query performance is crucial, especially for SQL Server environments dealing with large datasets. The challenge lies in identifying and implementing effective indexing strategies that can significantly enhance data retrieval performance. During her talk, Navya will address the common issues of slow query performance and inefficient indexing, often exacerbated by the complexity of modern data systems and the dynamic nature of query patterns. To tackle this problem, she leveraged SQL Server's Query Store feature, which provides a powerful tool...
Expanding Your Testing Scope: Thinking Beyond System Health
A big part of testing is ensuring that you're anticipating and proactively detecting problems before they appear. This means thinking beyond bugs and errors and considering tests that assess your system's ability to meet the needs of the business and customers. For example, most businesses and architectures are designed to deliver operational and cost efficiency. The challenge is, many organizations don't actively test/measure their efficiency. Customers also have expectations about their experience. What testing do you do to evaluate how the system is meeting its experience goals? This...