Guide on How to Compare Performance of Two SQL Servers – Part2

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

Guide on How to Compare Performance of Two SQL Servers

(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 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

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 improved! Wait…why cant I feel (damn) difference?!

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

Azure Stack on-premises (and how it’ll blow your mind)

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

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

How to check SQL Server ERRORLOG location

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

Database Blogs – Top 20 List

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!

55 Point SQL Server DATABASE Health Check Checklist

[2019] 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.