Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get Optimized SQL Server Configuration for Peak Performance

Kundan K.Status: Offline
Kundan K. Kundan K.
5.0
Rising Talent
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Kundan, priced and ready to go.
Kundan K.Status: Offline
Kundan K. Kundan K.
5.0
Rising Talent
Preview image

Let a pro handle the details

Buy Database Optimization & Design services from Kundan, priced and ready to go.

Project details

Many SQL Server performance issues are caused by incorrect instance and database configuration, not hardware or application code.

This project reviews and optimizes SQL Server settings to build a stable, high-performance foundation using proven best practices.

Where supported by your SQL Server version and edition, Intelligent Query Processing (IQP) features are evaluated and enabled safely to improve query execution without introducing risk.

What’s Included
 • SQL Server instance-level configuration review
 • Database-level configuration review
 • Compatibility and query optimizer behavior assessment
 • Safe, version-appropriate performance improvements
 • Clear findings and actionable recommendations

Note: Intelligent Query Processing features are applied only when supported and validated.
Database Type
MS SQL

What's included $150

These options are included with the project scope.

$150
  • Delivery Time 1 day
  • Number of Revisions 1
  • Number of Tables Added 0
5.0
3 reviews
100% Complete
(3)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)

PY

Peter Y.
5.00
Aug 18, 2024
Someone teach me how to install SQL Server/SMSS Fantastic, walked me through everything I asked for and took the time to show me other ways to solve the problem. Did exactly what I needed!

JL

Jeff L.
5.00
Jul 8, 2024
Review, Audit, and Improve Complex SQL Query

RH

Ryan H.
5.00
Mar 6, 2024
SQL Server / Report Server Performance Troubleshooting Very knowleable and cares about the project. Went above and beyond helping research and providing ideas to solve.
Kundan K.Status: Offline

About Kundan

Kundan K.Status: Offline
Senior MS SQL Server DBA | Performance Tuning | 6-Hour US/EU Overlap
100% Job Success
5.0  (3 reviews)
Samastipur, India - 8:20 am local time
SQL Server performance issues in production environments can be difficult to diagnose and often affect application reliability.
I help diagnose and resolve SQL Server performance problems safely — without risky changes or unnecessary downtime.

Common issues I solve:
- High CPU usage or SOS_SCHEDULER_YIELD waits
- Query timeouts during peak hours
- Blocking chains and long-running transactions
- Deadlocks impacting application stability
- Slow queries and inefficient stored procedures

I’m Kundan, a Senior SQL Server DBA specializing in performance tuning, troubleshooting, and stability improvements.
I work with SQL Server environments that support mission-critical workloads and require reliable and predictable performance.

Most of my work involves troubleshooting live production SQL Server environments where performance issues must be diagnosed quickly and resolved safely, with changes approached carefully after understanding the root cause.

Common root causes I address:
- Misconfigured SQL Server or database settings
- Inefficient isolation levels
- Missing or poorly designed indexes
- Outdated or inaccurate statistics
- Non-SARGable predicates
- Parameter sniffing and parameter sensitivity issues
- NULL value parameters or optional parameters

My focus is not just fixing immediate symptoms.
I identify root causes, prevent recurring issues, and help systems continue to perform reliably as workloads grow — reducing production incidents and improving overall reliability.

I regularly support high-availability SQL Server environments where uptime and consistent performance are critical.

Experience & Platforms
With 10+ years of hands-on experience, I’ve worked extensively with SQL Server versions from 2008 through 2025, including:
- SQL Server (on-premises)
- Azure SQL Database
- Azure SQL Managed Instance
- Amazon RDS for SQL Server

I combine proven optimization techniques with modern SQL Server capabilities such as:
- New Cardinality Estimator
- Columnstore Indexes
- Accelerated Database Recovery
- Optimized Locking
- Query Store
- Intelligent Query Processing
to resolve complex performance challenges efficiently.

If your SQL Server environment is slow, unstable, or difficult to scale, I can help restore performance and keep it running smoothly.

P.S. Most clients contact me when their SQL Server becomes slow during peak usage or starts causing timeouts in production.

Steps for completing your project

After purchasing the project, send requirements so Kundan can start the project.

Delivery time starts when Kundan receives requirements from you.

Kundan works on your project following the steps below.

Revisions may occur after the delivery date.

How we'll work

We'll review your SQL Server instance and database settings via Zoom or secure SSMS access and provide safe performance optimization recommendations.

Review the work, release payment, and leave feedback to Kundan.