Subscribe to our Newsletter!
If you like our blog posts make sure you subscribe to our newsletter . We will share all kinds of great stuff for FREE!Top Posts & Pages
- Adding a VLDB database to an SQL Server Availability Group
- Azure Managed Instance Changing DNS prefix
- SQL Server 2025: Is the Upgrade Worth the Money?
- Free Training: Performance Tuning with Free Tools!
- First SQL Server UG Meeting in Harrisburg, PA
- SQL Server 2025 Standard Developer Edition
- Benchmark SQL Server Disk Latency
- Building Your First Data Warehouse with SQL Server
- Building a Data Warehouse with SQL Server
- May Adventures!
Categories
Search Results for: performance
When will my replica be synchronized?
Recently, I was pulled into a gig to help troubleshoot an windows failover cluster service issue that was hindering an availability group. Just to give a little background information its a two node windows cluster with two replicas the availability … Continue reading
Posted in Cluster, High Availability
Tagged Availability Group, High Availability, Monitoring, synchronized
May Adventures!
This month is going to be an exciting month for me. I enjoy training and sharing my knowledge with others and this month I am going to have several opportunities to accomplish that goal. This weekend, May 10th I will … Continue reading
Posted in Uncategorized
Throwback Thursday #4: Plan Cache
Welcome to the first Throwback Thursday blog post of 2014. Throwback Thursday is a blog series where I dig deep into my evernote collection and find some great content on a single subject and share it with you. In the fourth installment … Continue reading
Posted in Uncategorized
T-SQL Tuesday #50: Automation for LazyDBAs!
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month. … Continue reading
Throwback Thursday #3: SQL Server & Disks
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some great content on a single subject and share it with … Continue reading
Posted in SQLServerPedia Syndication, Uncategorized
Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find the queries causing the top waits. Next, I like to understand what is running and monitor disk latency. Finally, I … Continue reading
Posted in SQLServerPedia Syndication
Tagged DMV, performance tuning, wait statistics
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid) changes its status from running to suspended it is typically due to resource wait or a signal wait. For example, … Continue reading
Posted in SQLServerPedia Syndication
Tagged benchmark, performance tuning, wait statistics
Table Partitioning: Secret Weapon for Big Data Problems
Is big data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you … Continue reading
Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance tuning usually starts with finding your top offenders so you can get the biggest bang for your tuning bucks. For … Continue reading
Posted in Performance Tuning, SQLServerPedia Syndication
Tagged Extended Events, Monitoring, SQL Server 2012
I am Speaking at 2013 PASS Member Summit!
Every single year I look forward to the PASS Member Summit. In a nutshell it is the SuperBowl for SQL Server Professionals. It is so vital to my career I have paid my own way. It is the best place to … Continue reading
Posted in Professional Development, SQLServerPedia Syndication
Tagged big data, PASS, Presentation, table partitioning