Are You Feeling Like Your Microsoft SQL Server Is Slow?

No Other SQL Server Support Firm Can Touch Our Response Time, Range Of
Experience, Quality Customer Service, Or Our Ability To Deliver Database Solutions.

That Works EXACTLY The Way You Want.
We Are The Only SQL Server Support Firm To Offer A 100% MONEY BACK
GUARANTEE on all services.

Call Now:
1-800-984-5704

Mark Varnas
Managing Director, Red9, Inc.

Call Us Today At: 1-800-984-5704

CPU Usage from
100% to 0%

Before

After

See What Other IT Managers Are Saying About Us...

Rare… Penetrating Knowledge of SQL

What a rare, great feeling it is to know when you hand off a project to someone, you can sit back and simply expect the best possible outcome. Mark's cool confidence and eagerness to deliver results are surpassed only by his deep penetrating knowledge of SQL. Whether it's design, development, optimization, or recovery, Mark is a SQL Gem.

David Lerner
President, Lerner Solutions

Complex and heavy 5,000+ concurrent connection databases need tuning, indexes, best practices, up-time, and smooth performance over all

He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, and smooth performance are all important, Mark is the type of DBA who truly knows how to keep these high standards.

Tim Janssen
Application Manager, Service King

Significant Performance Improvement in minutes

In just a few minutes, Mark was able to find significant performance improvement opportunities in my database. These improvements were in areas I hadn’t even considered. Mark came up with many ideas; just the top 2 to 3 were enough to give us a significant performance boost. Mark has extensive knowledge when it comes to SQL Server. I can’t imagine there is anything he does not know. We plan to continue to work with him on a regular basis and continue to enjoy the benefits of his knowledge.

Kess Eburu
Founder and Director, GoodsExpress.com

With little notice, Mark was able to find and fix a number of different SQL misconfigurations and wasteful practices.

After a weekend of work, the customer realized a 60% decrease in CPU utilization as a direct result of Mark's work.

Jason Milgram
Azure Practice Director, Champion Solutions Group, AllAware.com

Why choose us?

Welcome! Since you’re here, chances are pretty high you’re looking at your options for Microsoft SQL Server experts.

We could rattle on about how many decades of combined experience we have, how we’ll make your business more efficient, or how knowledgeable we are. But in the end, we’d sound exactly like every other SQL Server Database firm out there…

We can rightfully claim all of the same accolades the others are preaching, but you’ll see we’re truly different. Beginning with how our website looks, to how our team delivers our service experience, you will notice a difference. The hallmark of the difference is in our commitment: We are committed to being the best SQL Server option for you!

We’ll be the first to admit we aren’t going to be the least expensive. What we CAN promise you is you’ll get the most value of any SQL Server Consulting provider for your business compared to any of our competitors.

Mark Varnas,
Managing Director,
Red9, Inc.

Red9 is your complete outsourced
SQL Server Support department

SQL Upgrades and Migrations

SQL Server Migrations and Upgrades – only for rockstars!

Someone asked me recently about a couple of points about SQL Migrations or Upgrades.

I’ve been lead SQL DBA on few large project lately. In one case company just reached $1 billion in another is about $10 billion and the latest was one that is close to $200 billion. I was lead DBA on all three.

All three SQL migrations went very well!

Why do dollars matter here? Billion dollar companies have a lot more complexities than a startup with 50 people. From SQL perspective if you can handle complex migration, you can surely knock out small ones.

In one case I migrated from one data center to another while doing an SQL upgrade. In another case I upgraded 18 SQL Servers from SQL2008R2 to SQL2016 – including PROD, Reporting with 5000 daily reports, DataWarehouse, DEV, QA, UAT, Test, and DR environments) in a record amount of time for this size of the organization and considering the line of business they are in. I estimate this company will not upgrade for another 10years.

But enough about me.

The key in SQL Upgrades projects success is preparation. Prep work is going to take 80-90% of the time. SQL install and setup is going to be an easy part.

HERE ARE COUPLE OF ITEMS TO CONSIDER (event if you go with someone else)

1. Failover clustering on VMWare
There are few settings in virtualization that you need to get right for SQL Servers. Make sure you talk to VMWare person to get some specific settings turned on for SQL Server. If you just google “VMware SQL Server best practices”, you will find them. The key here is to NOT to allow other guest OS’es taking SQL Server resources.

Some of the settings are not as obvious though. Such as how CPU cores are presented.

In those cases, I suggest to grabbing production workload and re-running it on the NEW SQL server with setting A and then with setting B. Then compare results.

I have used SQL Distributed Replay feature for this – it worked great! It’s a lot of steps and maybe your SQL Server is not that important to go through extra pain and time this will take, but it is – is really worth it! I can probably even send you some Excel files that show a comparison of run1 vs. run2 and what you can see there.

SQL Distributed Replay eliminates SQL migration unpredictability

2. SQL Clusters and AlwaysOn
If you get pre-setup correctly – this part is going to be a breeze. Just make sure to think about how you will keep SQL security, SQL Agent jobs, linked servers synched between all nodes at all times (and No, AlwaysOn doesn’t help you there). Setting this up the first time – is easy. Keeping things in synch – requires more work. (I used some automated SQLAgent jobs for this).

3. SAN Config for SQL Server – I’d make this item #1 on this list
Storage is where most SQL Servers bottleneck on today. Here I want to compare how SAN theoretical advertised maximum performance compares to what I am actually seeing. Those two numbers never match – but that’s OK. The real question is how far apart are we? You can do some basic SAN testing using a program such as CrystalDiskMark. But if you playing with a serious SQL Server, you will end up doing diskspd.exe testing (built by Microsoft) and running a ton of tests on each volume. My suggestion – do not proceed with SQL installation until this is done.

Also, save your SAN performance metrics. SAN admin will get you your volumes. But after SQL upgrade is no longer a top item on the project list, other workloads start to creep into your SQL volumes and SAN perf mysteriously goes down. If you know what perf metrics were on day1 and ask that perf drop question quickly, there is a good chance SAN admin may move that extra workload someplace else.

4. Prior experience in upgrading SQL
You want to see past success. I would personally choose the SQL DBA who has done most complex upgrades in the past. And how fast were they? I have seen upgrade projects drag out for 12 months for one SQL Server! Why do I care about the most complex upgrade? Because there is a high chance you going to run into a weird case somewhere during an upgrade (90% chance probably) which you can’t find an answer to online. For one issue, I have run into the past, if I did not go to SQLPASS conference and talked to some serious people there – I don’t know I would have figured it out myself.

5. Architecting High Availability Disaster Recovery site
From SQL migration perspective this is probably easiest component out of all listed. Yes, it takes a bunch of steps. But it simple compared to above items. SQL2016 makes HADR simple. I don’t know what requirements you have, but I am guessing it will be AlwaysOn replica with asynchronous synchronization and you going to want that work as possible. AlwaysOn makes this easy. You just have to put some safeguards in place so you don’t accidentally failover to DR site.

This is all that I can think of for now. Its bit early and it’s time for coffee! 🙂

I’d love to talk to you about any questions you may have about your SQL Upgrade/migration project specifics (even if you don’t hire me!). Just use contact us form below (it will come directly to me.)

We've been fortunate to work with thousands of SQL Servers, from big, established Fortune 100 firms to startups

My site is flying now!

After SQL Database query tuning - My site is flying now! I have already have hired him three times. I am very happy I found him!

Emil Kadlec
Owner, Fantasy Sports Publications, Inc.

Yielded some very impressive results

The breadth and depth of knowledge of the Microsoft SQL Database platform and ancillary technology stack that Mark brought, has already yielded some very impressive results from both a physical and logical architecture perspective.

Preferred to stay anonymous

Highly regarded SQL database expertise

Mark proved to be a highly capable and productive resource for a valuable SolTech client. He provided complete end-to-end evaluation on database design, development and performance capacity and successfully executed those recommendations. Mark's SQL database expertise is highly regarded; looking forward to partnering with Mark again in the future.

Heather Linn
Talent Acquisition & Account Management Specialist, SolTech, Inc.

Put my mind at ease

It has been a great pleasure working with Mark. From the get-go I could tell he knew what he was talking about, and he put my mind at ease. We will be using him going forward for everything database related. I would highly recommend him.

Mike Kennedy
Founder and Developer, Quicket.co.za

Not ready to call us just yet?

If so, we would at least like to send you a copy of our recently published report, How to Hire Database Consultant – 21 Revealing Questions You Should Ask Any SQL Consultant Before Giving Them Access To Your Company’s Database.

Choosing the wrong database consultant to support your SQL Server can not only be incredibly frustrating and expensive, but could end up costing you in downtime, data loss, and expensive repair bills, not to mention headaches, stress and frustration!

Simply fill out the form here and we’ll send you a copy today!

Download your
FREE Copy Now!
We will email you a copy of our report, "How to Hire Database Consultant – 21 Revealing Questions You Should Ask Any SQL Consultant Before Giving Them Access To Your Company’s Database".

We're proud to partner with the best businesses in the industry.