You will get SQL Server Query Optimization
Project details
Instead of just focusing on one aspect (like query tuning), your entire system will be considered - schema design, indexing, query efficiency, and even server-level performance. Additionally, emphasis will be on continuous monitoring and documentation, ensuring long-term performance improvements and smooth handover.
My expertise in using advanced tools like SQL Profiler, DMVs, and execution plans, combined with a customized optimization plan, guarantees results tailored to each client's specific needs, unlike generic optimization methods that others may employ. This comprehensive, client-centered approach differentiates me in the market.
My expertise in using advanced tools like SQL Profiler, DMVs, and execution plans, combined with a customized optimization plan, guarantees results tailored to each client's specific needs, unlike generic optimization methods that others may employ. This comprehensive, client-centered approach differentiates me in the market.
Database Type
MS SQLWhat's included
| Service Tiers |
Starter
$200
|
Standard
$500
|
Advanced
$2,000
|
|---|---|---|---|
| Delivery Time | 7 days | 14 days | 30 days |
Number of Revisions | 6 | 6 | 6 |
Number of Queries | 6 | 6 | 6 |
Query Debugging | |||
Query Optimization | |||
Query Scheduling | |||
Query Analysis | |||
Source Code |
About Simon
Azure and SQL Server DBA Wizard | T-SQL Developer
San Diego, United States - 6:31 pm local time
Get your SQL Server bugs fixed and make your sluggish databases run faster. I have the skills and experience to effectively fix whatever SQL Server ailments you may have. I fix SQL problems before they become a problem.
#1 15 year SQL Server DBA wizard that's currently managing over 200 TB of data and simultaneously supporting over 100 end users and developers. Administered Azure SQL and VM resources for the last 6 years.
#2 Database Administration is pretty routine. What's more important is setting up communication channels for alerts and notifications. We help set up text alerts, email notifications, automated phone calls, Alexa notifications, and Zapier workflows to ensure any potential issues are addressed before they blow up into bigger issues
#3 Performance tuning and optimization is also my specialty. I can detect and discover bottlenecks, inefficient code, and recommended indexes for your system to run faster and healthier. Tools I use are:
Indexing - Use DMVs to find index recommendations
Max DOP - Ideally set to 8
Statistics - Update regularly especially after index maintenance
Table Partitioning - Best for large tables you may be querying against.
Subqueries and CTE - Best to avoid and use #temp instead
Parameter Sniffing - Possibly for some sprocs. OPTIMIZE FOR UNKNOWN
SQL Profiler - Set up to trace bottlenecks in code
Query Store - Set up and use to track down poor performing queries less
Extended events - Audit users and trace performance.
#4 Replication and Disaster Recovery. I can setup and manage a whole host of suites to safely geo-replicate your data whether it be database mirroring, log shipping, replication, HADR, or simply backup and restore.
#5 Backups. Safely store your backups in Azure vaults. Ransomware is a serious issue and one that SOC auditors will not overlook. I can safely secure your backup files and keep them away from internal and external malicious threats.
Steps for completing your project
After purchasing the project, send requirements so Simon can start the project.
Delivery time starts when Simon receives requirements from you.
Simon works on your project following the steps below.
Revisions may occur after the delivery date.
Received Performance Data from Client
I will provide a document with detailed recommendations on how it will improve the client's database performance.