SQL Server with Mr. Denny:



April 2, 2014  5:00 PM

How I Setup TempDB

Posted by: Denny Cherry
Back To Basics, Database Administration, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, TempDB

How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there.  So here's how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well.

Number of Files

The number of files that...

January 15, 2014  2:00 PM

Fixing TempDB database problems when starting SQL using a minimum config

Posted by: Denny Cherry
Data Loss, Database, Database Administration, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, T/SQL, TempDB

So the other day I typo'ed something. Usually this isn't that big a deal, but in this case when fixing tempdb for a customer I told SQL to put two logical files into the same physical file. I was able to get it to let me do this because I first added the files, then realized that I had put them...

October 30, 2013  2:00 PM

TempDB latch timeouts with lots of RAM

Posted by: Denny Cherry
Blocking, Database Administration, Microsoft CSS, RAM, SQL Server, SQL Server 2008 R2, TempDB

Recently I had an interesting problem where the SQL Server 2008 R2 instance would randomly in the middle of...

April 4, 2011  2:00 PM

Can tempdb data and log put on on RAID 1 one physical disk, or keep it separate physical disk?

Posted by: Denny Cherry
SQL Server, Storage, TempDB

It really depends on the amount of load that you put on the tempdb database.  Everything which is done within the tempdb database is going to be logged in the transaction log just like any other database so if the tempdb database has a very high IO then it may make sense to put the tempdb log on a...

August 3, 2009  11:00 AM

Single Instance vs Multiple Instances

Posted by: Denny Cherry
Instance, Multiple Instance Configuration, RAM, SQL Server, TempDB

I see this question quite a bit, should I use a single instance or one instance per application database on my server. Continued »

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

May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem

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

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


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: