Part 2 – Guide on How to Compare Performance of Two SQL Servers (and the end result we want out of DReplay testing) In Part1, I talked about: Why would you compare performance of two SQL Servers. And end result that we want to get by doing this comparison. In big picture, here
(using the least known SQL Server feature – SQL Distributed Replay) Simple question we are trying to answer is – how does NEW SQL Server compare to an OLD? Why? Why would you want to compare two SQL Servers? We just paid $75,000 for a new server and I need to prove to someone higher
What hardware your SQL Server is bottlenecking on? What hardware components does your SQL Server depend on the most for speed? Only 4 components that matter: CPU RAM Disk Networking Which hardware component SQL Server bottlenecks on in 99% of cases? Disk. I bet you $100, that your SQL Server is bottlenecking
SQL Server Health Check – Case Study Industry vertical: National Automotive Service Client background: 2000+ employees $1 Billion+ in revenues 300 locations nationwide Problem Summary: Client is experiencing severe issues with the Microsoft Windows Failover Clustering stability. Four node Windows Cluster goes down about two-three times per day and takes about 30 minutes
SQL Performance tuned! Done! But wait…why cant I feel a (damn) difference?! I ran into an issue recently. After doing (an incredible!) job at tuning SQL Server Performance, I received this note from the client: “the changes are made, but we don’t feel the difference” [shortened to distill down to the point] Which…umhh… really bothers me… If I
Microsoft Azure Stack on-premises and how it’ll blow your mind Azure Stack Summary Today I watched Ultan Kinahan (from Microsoft Global Black Belt Consulting team) presentation on Azure Stack. Short summary – it blew my mind.
Azure SQL Managed Instances Pros and Cons Here are few notes I took at SQLSaturday Atlanta about Azure SQL Managed Instances. Today there are two managed db options in Azure: Azure SQL and Azure Managed SQL Instance Azure SQL database Pros: – Simple, easy – most things are managed like backups, but which
4 Ways to Check SQL Server ERRORLOG Location You can check sql error log path in a few ways: 1. Use TSQL 2. Use SQL Configuration Manager 3. Use EventViewer 4. Registry
Here’s a comprehensive list of Database blogs that scour the Internet with a fine-toothed set of queries to compile the most informative posts about Database. Congratulations to all the bloggers who made it to the list!
 SQL Server Health Check Checklist Some clients want a FULL SQL Health Check, while some only want to go deep on analysis for a SINGLE database. This is a SINGLE database health check. Even though it’s a single db health analysis, we still check for some server/instance level items. That’s intentional.
The Guide: SQL Server Installation Checklist (settings which increase SQL Server Performance) How’d you like to see my secret stash of untapped SQL Server tuning items I personally use when setting up new SQL Servers to make them go faster and be more reliable? Well consider yourself very lucky…