Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the replication linked server that gets created when you run sp_adddistributor. The reason the error was confusing at first is because I was creating local distributors (the best practice for peer-to-peer
read more

Performance Counters: Why It Depends

When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to compare them against. This usually leads to searching the web for resources that will tell you what numbers the counters should be. And sadly, it quite often ends with either misleading advice or with a
read more

Why is Your SQL Server Slow? All-for-one and One-for-all

I have one more thing I want to talk about regarding the conversation I had recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Another “quick performance wins” you can take advantage of is segregating the types of files SQL Server uses. If you install SQL Server by just clicking NEXT until you get to the end, you end up with everything running on the same drive. Different files have different types
read more

Why is Your SQL Server Slow? Here’s a Hint

I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Specifically, the discussion was about things that people could change without a lot of trouble to make their SQL Server run faster. I like to use the phrase “quick performance wins” for these easy-to-fix issues that can generate a considerable performance boost. This conversation led to a whitepaper on 5 things that are making your SQL Servers slow. Watch Idera’s
read more

Performance Tuning Pre-con and More at SQLSaturday 277 RVA

Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and 22, 2014. I will be delivering an all-day pre-con session, Performance Tuning and Troubleshooting Like a Pro, on Friday, March 21. The session is only $99 if you sign up before February 20. On February 20th, the price goes up to $125. Title: Performance Tuning and Troubleshooting Like a Pro Level: All levels Description: Do you wish you could turbo
read more

T-SQL Tuesday #49: Wait For It Roundup

A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of T-SQL Tuesday. I hope I didn’t keep you waiting too long for the roundup. <rimshot> Let’s take a look at this month’s participating blog posts: Fellow Certified Master (MCM) Rob Farley (blog|@rob_farley) led off with Waiting, waiting…. Rob talks about what causes SQL Server (and computers in general) to be slow and how to baseline SQL Server waits to detect
read more

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL Tuesday, hosted by yours truly, is … wait for it … Waits and Queues. For my donation to this little blog party, I’m contributing my favorite go-to query for waiting tasks. Do you ever get complaints that SQL Server is “slow”? Yeah, that’s a helpful report, right? when I get those kinds of reports, I like to take a quick
read more

Introduction to Integrity: Data Purity Errors

The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL Integrity Checkhas finally reached its conclusion. Today is the final post and the final integrity issue that I am going to talk about: Data Purity Errors. Data purity issues are when the value stored in a column is out of range for the data type. This is a rare error for databases created in SQL Server 2005 or newer. The
read more

Introduction to Integrity: Chain Linkage Problems

We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings this week. One of the last two integrity issues, and the one I’ll cover today is chain linkage problems. Chain linkage problems are metadata corruption issues. It is possible in certain situations for the links from one page to another to get corrupted. All pages in an object or index have pointers to the previous and next pages in the
read more

New Whitepaper: 5 Most Common Critical SQL Integrity Issues

Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to do? Stop hesitating and get started right now. If you are new to database integrity and corruption, we have a helping hand to get you started. A new whitepaper on the 5 Most Common Critical SQL Integrity Issues that DBAs will face in their career will get you started. A crucial part of managing SQL Server is performing regular integrity
read more