check, diagnose and fix slow ms sql query
Budget: $30 – $250 USD
I am looking for an experienced MS SQL expert to tackle and solve performance issues plaguing our large SQL database. Our system is currently hindered by slow query execution and significant delays in response times. This has become a critical issue needing urgent attention.
**Performance Symptoms:**
- Slow execution of queries
- Long response times for queries
**Areas Affected:**
- Both database read and write operations are impacted
- Particularly noticeable when retrieving data from our large tables
**Database Size:**
- Our database exceeds 10 GB, categorizing it as large
**Ideal Skills and Experience:**
- Proficient in diagnosing and optimizing MS SQL Server performance
- Skilled in identifying and fixing issues related to slow query execution and long response times
- Experienced with handling large-scale databases, ideally more than 10 GB
- Capable of optimizing both read and write operations, with a focus on large table data retrieval
Your primary goal will be to thoroughly analyze our server's performance, identify the root causes of these issues, and implement solutions that will bring our system back to optimal speed and efficiency.
**Performance Symptoms:**
- Slow execution of queries
- Long response times for queries
**Areas Affected:**
- Both database read and write operations are impacted
- Particularly noticeable when retrieving data from our large tables
**Database Size:**
- Our database exceeds 10 GB, categorizing it as large
**Ideal Skills and Experience:**
- Proficient in diagnosing and optimizing MS SQL Server performance
- Skilled in identifying and fixing issues related to slow query execution and long response times
- Experienced with handling large-scale databases, ideally more than 10 GB
- Capable of optimizing both read and write operations, with a focus on large table data retrieval
Your primary goal will be to thoroughly analyze our server's performance, identify the root causes of these issues, and implement solutions that will bring our system back to optimal speed and efficiency.