The Rambling DBA: Jonathan Kehayias : Configuration

TSQL Tuesday #11 Misconceptions – Enable AWE on 64bit SQL Servers

Jonathan Kehayias — Tue, 12 Oct 2010 16:58:25 GMT

This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server...(read more)

Why the “Toilet” Analogy for SQL might be bad

Jonathan Kehayias — Sat, 08 May 2010 06:33:41 GMT

Robert Davis(blog/twitter) recently blogged The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads , in which he uses an analogy for why increasing the value for the ‘max worker threads’ sp_configure option can be bad inside of SQL Server. ...(read more)

Working with Sub-Optimal Disk Configurations (Making the best of what you’ve got)

Jonathan Kehayias — Wed, 28 Apr 2010 01:50:32 GMT

This is the first post in a what will be a series of posts on working with a sub-optimal disk configuration to squeeze as much performance out of it as possible. You might ask what a Sub-Optimal Disk Configuration? In this case it is a Dell...(read more)

SQL Server Installation Checklist

Jonathan Kehayias — Tue, 23 Mar 2010 02:31:33 GMT

The other night I was asked on Twitter by Todd McDonald (Twitter), for a build list for SQL Server 2005 and 2008. My initial response was to provide a link to the SQL Server Build List Blog , which documents all of the builds of SQL Server and provides...(read more)

Configuring SQL Server Audit Logging with Powershell

Jonathan Kehayias — Mon, 22 Mar 2010 10:00:00 GMT

One of the standard configuration options that I set on all SQL Server installs is to log Failed Login Attempts to the SQL Server Error Log. I recently inherited an environment that this option wasn’t standardized across all of the servers and needed...(read more)

Getting Partition Offset information with Powershell

Jonathan Kehayias — Tue, 02 Mar 2010 03:53:00 GMT

Paul Randal recently blogged about Using diskpart and wmic to check disk partition alignment . Lately, I have been writing A LOT of Powershell scripts at my new job, primarily because the size of the environment makes it next to impossible to work through...(read more)

Playing with Disk Alignment

Jonathan Kehayias — Fri, 20 Nov 2009 00:58:20 GMT

Over a year ago I first read about disk and partition alignment on the blog of Jimmy May ( blog / twitter ). I always wanted to look into this further, but there was always a major hurdle to doing this in my environment, almost every one of my production...(read more)

Cleaning Out Your Backup History

Jonathan Kehayias — Fri, 30 Oct 2009 03:19:10 GMT

This week I have been pretty heads down working with a Microsoft Premier Field Engineer learning how to best customize System Center Operations Manager 2007 R2 to monitor things not included in the SQL Server Management Pack. Based on the training...(read more)

SQL Server and Jumbo Frames

Jonathan Kehayias — Mon, 12 Oct 2009 17:09:21 GMT

During the 24 hours of PASS we (Thomas LaRock ( Blog / Twitter ), Argenis Fernandez( Blog / Twitter ) and myself) got into a discussion about enabling Jumbo Frames (network packets over 1500 bytes, generally set to 9000 bytes) for use with SQL Server. ...(read more)