Is your database running as fast as it could be? There are many aspects of database and query design
that can have a significant effect on performance.
I can review and optimization your database schema
and your queries, and make suggestions that include:
- How to minimize round-trips
- Using command batching
- Optimizing transaction sizes
- Table partitioning (horizontal and vertically)
- Trade-offs between dynamic SQL, parameterised queries and stored procedures
- Applying instrumentation to your system
- Optimizing your indexes
- Using free-text (particularly as a replacement for certain LIKE queries)
- Using Service Broker (particularly to help with load-leveling)
- When to use native XML columns
- Using database-side pre-caching
- Choosing the best high-availability solution
- When to scale your database by using load-balanced read-only servers
- When to scale-up vs. scale-out
- Minimizing index and table fragmentation
- Optimizing locks and transaction types
- How and when to use Analysis Services to speed up your OLTP database
- General query optimization
- Infrastructure recommendations
I can deliver my recommendations either in written form or as an interactive presentation, or both.
If this interests you, please send the following information, so that I can provide a quote:
- A brief description of your project, your database architecture and the approximate amount of data involved
- Your goals for the engagement
- Any known problem areas with your database
- Your schedule requirements