I wrote this to share a series of scripts that help identify if workloads are appropriately separated on the SQL Server host. The main reason we look for this is to avoid I/O contention and waits, which is a challenge that can significantly impact performance. If you are unsure if your server is experiencing I/O … Read more
Featured image photo by alexey turenkov on Unsplash A client reached out for help with a performance problem that had been going on for over a day. The application was performing so slowly that it was nearly an outage to their users. I love working on production emergencies where there’s a severe performance problem. I … Read more
IMPORTANT NOTE: This requires SQL Server 2017 or newer, Query Store and Enterprise/Developer edition. In SQL Server 2016, we were given the Query Store feature, and all the perf tuners rejoiced. Finally we had a great tool to help us with SQL Server parameter sniffing issues. These days, any time I work on a parameter … Read more
I wish you knew a few things about VMware and SQL Server best practices. If you’ve ever asked yourself “Why does my storage seem slower on my SQL Server VMs?!”, this post may help. We love VMware in our SQL Server consulting practice. But there are some things you should know and do first. These … Read more
We’ve been working with Relativity for at least 4 or 5 years now here at Straight Path. Helping clients with their Relativity SQL Server environments. Helping folks get the most performance out of their Relativity SQL Servers. Running our SQL Server Health Checks for many firms. From small firms to a few on the AmLaw … Read more
At Straight Path Solutions, we love performing SQL Server Health Assessments. These are our exams that dig quickly into the root of your SQL Server instance and find problems that you are currently suffering from. Then we give you an action plan to stop suffering from them today. Rather than just performing the checks and finding the … Read more
I do a lot of SQL Server Health Assessments on SQL Server environments. I’m always checking sys.configurations to look for problematic instance level configuration settings. I almost always find configurations worth changing. But the approach I’ve always used is a bit manual and I wanted to fix it. So I finally wrote a script to … Read more