SQL Server with Mr. Denny:

September, 2008

September 30, 2008  6:58 PM

SQL Server consolidation: Why it’s an optimization technique

Posted by: Denny Cherry
Consolidation, SQL Server 2005, SQL Server 2008

This morning I released another tip on SearchSQLServer.com called "SQL Server consolidation: Why...

Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication

Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...

September 25, 2008  11:00 AM

A Load Balanced Federated Database Solution

Posted by: Denny Cherry
Federated Database, Scaling Out

If you have a very high load on your database, but no specifically massive tables you may want to look into a fully load balanced solution for your database. This solution falls somewhere between your normal replication solution, and a federation solution. It’s not truly a federation as no one...

September 22, 2008  11:00 AM

The full replication federation

Posted by: Denny Cherry
Federated Database, Scaling Out

Another type of database federation is what I call the full replication federation. This is where you place all the dimension tables (sticking with our data warehouse example from last time) on all...

September 19, 2008  7:04 PM

Great Turnout At the San Diego SQL Server Users Group Last Night

Posted by: Denny Cherry
Federated Database, In Person Events, San Diego SSUG, SoCal Code Camp, SQL

I'd like to say thanks to the San Diego SQL Server Users Group for inviting me to speak last night. I had a great time speaking to the group, and just like last time the questions were all excellent. The slide...

September 18, 2008  11:00 AM

The Pyramid Federation

Posted by: Denny Cherry
Federated Database, Scaling Out

There are several techniques which can be used to federate your database. The first of which, which we will be talking about is the Pyramid Federation (I have no idea if that what it’s actually called, but that what I’ve named it). In a pyramid federation we have a single server which holds...

September 15, 2008  11:00 AM

Scaling the database out, not up.

Posted by: Denny Cherry
Federated Database, Microsoft Cluster Service, Scaling Out

When your database has grown beyond the performance capabilities of a single SQL Server, there are still ways get increase the system performance.  This requires using a technique called a Federating the database, this is also known as...

September 11, 2008  11:00 AM

Service Broker may not remove messages after processing

Posted by: Denny Cherry
END CONVERSATION, Service Broker, SQL, SQL Server 2005, TempDB

I've seen an issue with Service Broker that others may be seeing.  Messages are sent into the service broker, and are processed as normal, and they are removed from the message queue.  However you still see the conversation in the sys.conversation_endpoints DMV in a CONVERSING state instead of a...

September 9, 2008  11:52 AM

Tuning SQL Server performance via memory and CPU processing

Posted by: Denny Cherry

Part two of my two part series on hardware tuning of your SQL Server has just been released on SearchSQLServer.com.  This part is titled "   Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 8, 2008  11:00 AM

How to configure DTC on Windows 2008

Posted by: Denny Cherry
KB 250367, MS DTC, MSCS, RPC, SQL, Windows 2008

This post is specifically about setting up DTC on Windows 2008.  If you are looking for the post about setting up DTC on Windows 2003 you'll want to go to the post "

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: