Don't let a slow or crashing SQL Server disrupt your operations. We pair Jacksonville IT teams with dedicated senior DBAs to optimize your databases and keep uptime steady. Only senior DBAs with 15+ years of experience. No juniors. SQL Server is all we do.
Talk to a senior DBA
A senior DBA reads this (not a sales rep) and replies within one business day. No obligation.
You see the findings and the price before you commit.
By clicking, you agree to our Terms of Use and Privacy Notice.
Prefer to talk? A senior DBA is reachable at 1-877-891-1870
SQL Server consulting in Jacksonville: the short answer
Red9 provides senior-only SQL Server consulting, performance tuning, managed DBA services, and emergency response to organizations across the First Coast, including Orange Park, Middleburg, Fernandina Beach, Ponte Vedra, and St. Augustine. SQL Server is the only engine we have worked since 2014. The free 145-point health check comes before any proposal. Our roster carries 120+ clients, from seed-stage startups up to the Fortune 100; Managed Services and Emergency Services clients have production incidents answered inside 15 minutes, and each change is delivered with the numbers measured either side of it.
Want a SQL Server consultant in Jacksonville who measures before promising? Book your free assessment.
Jacksonville is a working port with a large back-office economy around it, and both halves live on transactional databases. Container movements, policy records, and patient charts all grow every year.
JAXPORT is one of the country's leading vehicle-handling ports, a Class I railroad is headquartered in the city, and trucking, warehousing, and customs work sits around them. Those systems track units, movements, and documents continuously, and a gate screen has to answer while the driver is looking at it.
Jacksonville hosts a large concentration of banking, insurance, and fintech operations centers, carrying policy, claim, and payment data through fixed daily cycles. High-frequency application queries dominate, and a few milliseconds a call decides whether the batch finishes.
Baptist Health, UF Health Jacksonville, and the Mayo Clinic campus anchor a substantial care sector, with clinical and revenue-cycle databases under HIPAA behind it. We comply with HIPAA and SOX, sign NDAs on every engagement, and carry cyber insurance, and every action over our access is logged.
Aviation maintenance operations, manufacturers, and building-services contractors across the region keep ERP, work-order, and asset data on SQL Server, where a hardware refresh is usually the next big spend. Benchmarking the new hardware before the move is the cheapest insurance available: see the storage case below.
We work with organizations across the region: Jacksonville, Orange Park, Middleburg, Fernandina Beach, Ponte Vedra Beach, St. Augustine, and Atlantic Beach, out to Gainesville, Daytona Beach, and Brunswick, throughout North Florida and South Georgia, and statewide across Florida, all over secure remote access. Work is scheduled around your cycles on Eastern time.
A senior read on the hardware, architecture, and licensing decisions a Jacksonville team is about to sign for. Benchmarks before purchase orders, wherever we can get there first.
From $4,995 / 20-hr block (hours do not expire)Senior administrators running the estate day to day, and carrying it through the weeks when your own team cannot: monitoring, patching, verified restores, capacity work.
From $395 / moAn engineer who has already handled this failure, reachable the moment production stops, with a 15-minute response for Managed Services and Emergency Services clients.
From $2,500 / incidentWorkload costed per day, the expensive statements rebuilt or rewritten, and scalar functions and computed columns treated as the performance problem they usually are.
Version moves, Azure SQL, or AWS RDS, with the target storage benchmarked before anybody schedules a cutover weekend. Extended support for SQL Server 2016 runs out on July 14, 2026, with 2017 following in October 2027, so the target platform question is live now.
A no-cost, read-only pass over 145 points covering configuration, backups, security, and performance, delivered as a ranked fix list. You are free to run it yourself as well.
Failover rehearsed before storm season rather than during it. We design and tune clusters and Always On Availability Groups, then bring in log shipping, replication, or Change Data Capture (CDC) where only the changed rows need to travel.
Preparation on the databases your team wants to open to an assistant, ChatGPT (OpenAI) or Claude (Anthropic), plus the RAG pipelines, vector search, and analytical traffic those tools push into SQL Server. Where reporting has begun to squeeze the transactional workload, we move the offload, SSRS and Power BI datasets included, onto Snowflake, Redshift, or the warehouse you already have.
"We initially engaged Red9 to troubleshoot a series of ancient SQL databases that had come to a crawl and become a major pain point for our client. Red9 dove in head first optimizing the databases, auditing the results, and once the situation was stable, advising on a strategy for moving forward."
"I can confirm there is noticeable improvement on our clustered SQL Server after work Red9 DBAs have done!"
"Red9 is great. Very communicative, responsive, and extremely knowledgable. Glad we have Red9 on our team."
Four steps, discovery in days, and the senior DBA who runs your audit stays with the work. The roadmap and its expected payback reach you before you commit anything.
Which instances the business rests on, what the symptom looks like from outside, and whether a hardware decision is already in motion. That last one is often time-critical.
145 read-only checks across configuration, whether the backups would truly restore, where security sits open, and what is dragging queries down, all ordered by the value of the fix. You can also run the same audit against your own instance beforehand, free, with our self-serve Health Check.
We go through the findings in value order, with hours and cost against each line, and you finish holding a ranked plan and a firm number.
With approval we work the plan and take readings around each change, so every gain can be re-checked by your team. Managed services then keep the estate where the work left it.
Three real Red9 projects, each followed from the first review to the final measurement. The figures were recorded by the client. Names are withheld at their request.
The problem. A building-services contractor was about to move its production database onto a new server. Nobody had measured the new machine's storage. On paper it was newer, which is the assumption that ruins migration weekends.
What we did. We ran storage benchmarks with CrystalDiskMark across the drives on both machines, sequential and 4 KiB random patterns at the queue depths the report records, and compared the results drive by drive. This was a comparison of two machines rather than a before-and-after of a fix, and we report it that way.
The storage problem surfaced while it was still a purchase question.
The result. The contractor learned that its replacement server would have made the database slower, and it learned that while there was still time to fix the storage configuration rather than explain a regression on the Monday after a migration.
What the benchmark showed. Sequential throughput on the new build sat roughly an order of magnitude below the existing production data drive, and random 4 KiB performance was worse still, with the queue-depth-32 read IOPS about 39 times lower and latency correspondingly higher.
What we measured (identifiers generalized for privacy):
-- CrystalDiskMark 8.0.4, per drive, both servers. -- PROD data drive : SEQ Q8 read ~2,989 MB/s | RND4K Q32 read ~68,643 IOPS -- NEW SQL drive : SEQ Q1 read ~298 MB/s | RND4K Q32 read ~1,746 IOPS -- conclusion: new-server storage layout re-specified before any migration date was set
Benchmarks are cheap. Discovering this after the cutover is not.
The problem. A property software company had a query built on a scalar user-defined function that assembled person data. It ran about 700 times a day at roughly 67 seconds each, which came to something near 13 hours of SQL work daily, and the function forced single-threaded plans so the server could not use the cores it had.
What we did. We reworked the person and address objects to remove the computed columns and scalar functions in favor of persisted values, merged the address calculation into a single function, added an index on the phone lookup path, and replaced the function calls with a precalculated address field. Two further top queries were indexed at the same time.
A 63-fold drop, once the row-by-row function work was gone.
The result. The function-driven query returns in about two seconds instead of over a minute, and the estate got back roughly 12.5 hours of daily SQL work from that change alone, with a further 11 hours from the second query. The application kept its behavior; only the way the values are produced changed.
What the review found. A scalar user-defined function was being evaluated per row, and computed columns compounded it, which both multiplied the reads and blocked parallelism. No index would have rescued that shape of query.
What we changed (identifiers generalized for privacy):
-- Function-backed query: ~700 runs/day at ~67 s, 805,838 reads, single-threaded plans. -- computed columns and scalar UDF calls replaced with persisted / precalculated values -- address calculation consolidated into one function, called once per set CREATE NONCLUSTERED INDEX IX_red9_person_phone_type ON dbo.[person_phone] (personTypeId) INCLUDE (personId, phoneNumber); -- two further top queries indexed in the same pass; rollbacks supplied
Getting the function out of the row path is what allowed a parallel plan and dropped the reads from 805,838 to 12,703.
The problem. A software company had a test-list query running about 42,380 times a day, averaging 606.26 ms and 188.56 ms of CPU per call. Across the day it drove 827,257,600 logical reads. The index supporting it had been built for a different version of the query.
What we did. We replaced that index in place, keyed on the three columns the current query filters and joins on, using DROP_EXISTING so the swap was a single operation rather than a window with no index at all. Before and after were captured on the same workload.
Recovered from a single index replacement, with no code change.
The result. The query answers in about 62 ms, the instance performs 474 million fewer reads every day, and roughly six hours of daily SQL time went back to the platform. One index replacement, applied with DROP_EXISTING so nothing was ever unindexed.
What the review found. The existing index no longer matched the query's predicate order, so the engine was reading far more of the table than it needed and then discarding rows. Adding a second index would have left the stale one behind to be maintained on every write.
What we changed (identifiers generalized for privacy):
-- Test-list query: ~42,380 calls/day, 606.26 ms each, 827.3M reads/day. CREATE NONCLUSTERED INDEX IDX_red9_question_taken_root_correct ON main.[question_taken] (questionRootId, isCorrectAuto, isCorrectMember) WITH (DROP_EXISTING = ON); -- before/after captured on the same workload; prior definition kept for rollback
Replacing in place avoids carrying a stale index beside the new one, which matters when the table is this busy.
Three other companies measured those numbers on their own hardware. Half an hour and we will measure yours.
Get a Free SQL Server Assessment ➜Rather talk it through? A senior DBA answers at 1-877-891-1870.
The person benchmarking your storage and reading your plans has been doing this for over 15 years. No junior bench sits behind them.
Nothing but SQL Server since 2014, across 10,000+ audited databases and thousands of servers.
We measure before we recommend, including the hardware, and we report a comparison as a comparison.
Through storm weeks and quiet ones alike, Managed Services and Emergency Services clients reach a senior DBA inside 15 minutes.
No. The work arrives over secure remote access, which nearly all our clients use, and our coverage is never inside the evacuation zone with you. A senior DBA is reachable across your whole Jacksonville workday on Eastern time, with 24/7/365 emergency cover on top for Managed Services and Emergency Services clients. The access is yours: we connect through your VPN or bastion host on least-privilege logins you create and can revoke in a moment, with additional controls layered on, and every change comes as a script your team reads first.
How the options really differ in the week a Jacksonville migration or a storm forecast lands on your desk.
| Red9 | In-house DBA hire | Generalist IT / MSP | |
|---|---|---|---|
| Seniority | Principal-grade SQL Server specialists, 15+ years on average, with no junior layer behind them. | One person is the entire capability, and they evacuate too. | Generalist teams where SQL Server waits its turn. |
| SQL Server focus | SQL Server is all we do. | Split across every platform in the building. | One product among the many they list. |
| Emergency response | Cover through the whole year, with a 15-minute response for Managed Services and Emergency Services clients. | Bounded by one person, and by whatever week the weather picks. | A queue that lengthens exactly when everyone needs it. |
| Proof | Measurements before the recommendation, hardware included. | Rarely benchmarked before a purchase. | Usually the vendor's data sheet. |
| Cost model | Per project, per month, or per incident, with no salary or benefits carried. | A loaded Jacksonville salary near $110,000 to $135,000, plus benefits and idle stretches. | Wrapped into a broader bill with no database line to check. |
| Ramp-up | Measuring your estate within days. | Months to recruit, then months to be useful. | Slow to start, and the context is retold every ticket. |
Senior SQL Server cover can be in place before your next cutover. Get a Free SQL Server Assessment ➜
Founder & Partner
25+ years making SQL Servers faster.
Chief Operating Officer
Chief Revenue Officer
The bench they lead is senior-only and averages 15+ years, and a single named lead answers for the result from first call to final reading.
We support First Coast teams over secure remote access, from downtown and Southside out to Orange Park and Middleburg, north to Fernandina Beach, and south through Ponte Vedra to St. Augustine. The same senior DBA answers whether the instance sits near the port or in a Ponte Vedra office.
Coverage reaches across the First Coast and North Florida. Explore the areas we serve.
Five questions that separate a measured opinion from a confident one.
Ask what proportion of their work is SQL Server, and how long it has been that way.
Find out who holds the credentials, how senior they are, and whether that changes once the contract is signed.
If a server refresh is on the table, ask whether they will measure the target storage before you sign for it.
On this coast, ask who runs the estate during an evacuation week and what the escalation order looks like on paper.
Look for one that reports a comparison as a comparison instead of dressing it up as an improvement.
| Headquarters | Alpharetta, GA (Atlanta metro) |
|---|---|
| Founded | 2014 |
| Focus | Microsoft SQL Server only |
| Team | Senior-only DBAs, 15+ years average experience |
| Clients | 120+, from startups to the Fortune 100 |
| Databases audited | 10,000+ |
| Rating | 4.9 out of 5, 120+ reviews |
| Emergency response | 15 minutes, 24/7/365, for Managed Services and Emergency Services clients |
| Engagement models | Scoped project, monthly retainer, or per-incident |
| Service area | Jacksonville and the First Coast, plus nationwide via secure remote access |
Yes. Red9 covers Jacksonville and the First Coast, from downtown and Southside out to Orange Park and Middleburg, north to Fernandina Beach, and south through Ponte Vedra to St. Augustine, with a senior SQL Server consultant on every account. Remote is the normal arrangement in this market and what nearly all of our clients use. Secure remote access and a 15-minute emergency response for Managed Services and Emergency Services clients get a senior DBA working the problem while a drive across the bridges would still be ahead of you.
15 minutes, any hour, any day of the year, and a senior DBA answers instead of a ticket queue. This response-time SLA is available to current Managed Services clients and Emergency Services clients. See Emergency Services ➜
The audit is free: 145 points, read-only, no commitment. Managed services and remote DBA run from $395/mo. A 20-hour senior block is $4,995 and the hours do not expire. Emergency work is billed per incident from $2,500. A loaded Jacksonville DBA salary runs about $110,000 to $135,000, the figure sitting in the comparison table above, so a senior block is close to two weeks of that hire and it starts returning inside the first. Bigger programs are quoted after the audit.
We can, and that is one of the practical arguments for coverage that is not in the storm's path. Before the season we rehearse the failover, confirm the backups restore, and write down who has which credential and what the escalation order is. During an event a senior DBA on Managed Services or Emergency Services cover carries the estate on the 15-minute response while your people deal with their homes. Access stays revocable by you throughout.
You benchmark the storage before you cut over, because new hardware is not automatically quicker hardware. A model year proves nothing about the drive layout underneath it. In case #1 above, benchmarking a new build against the existing production server showed the new SQL drive delivering about 298 MB/s of sequential read and roughly 1,746 random-read IOPS, against 2,989 MB/s and 68,643 IOPS on the machine it was meant to replace. That is the kind of finding that has to arrive before the migration weekend.
Yes, and it is usually one of the largest wins available. Scalar user-defined functions and computed columns force row-by-row evaluation and can prevent a parallel plan entirely. In case #2 above, replacing function calls with persisted and precalculated values took a query from about 67 seconds to two, cut its reads from 805,838 to 12,703, and returned roughly 12.5 hours of SQL work every day.
Yes. Nonprofits and government agencies take the same free 145-point health check as everyone else, and the deliverable is a ranked list of findings with the price of each attached, written so a board or a city council committee can act on it. Managed services and remote DBA run from $395/mo. A 20-hour senior block is $4,995 and the hours do not expire.
Supported versions, platform choices, and how an engagement runs are all covered on our SQL Server consulting page.
Give us 30 minutes. We will find where the estate is giving away speed, uptime, and money, and tell you what each repair costs. The free SQL Server assessment shows you the findings and the price before anything is decided.
Schedule My Call Now ➜Rather talk it through? A senior DBA answers at 1-877-891-1870.
