Browse by Tags

• Database Administration
• Disk IO
• Internals
• Memory Allocation
• Miscellaneous
• Powershell
• Security
• TSQL2sday

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

  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... Posted Tuesday, October 12, 2010 1:58 PM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration, Internals, Memory Allocation, TSQL2sday

• Why the “Toilet” Analogy for SQL might be bad

  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... Posted Saturday, May 08, 2010 3:33 AM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration, Miscellaneous

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

  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... Posted Tuesday, April 27, 2010 10:50 PM by Jonathan Kehayias | 5 Comments Filed under: Configuration, Database Administration, Disk IO

• SQL Server Installation Checklist

  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... Posted Monday, March 22, 2010 11:31 PM by Jonathan Kehayias | 22 Comments Filed under: Configuration, Database Administration, Security

• Configuring SQL Server Audit Logging with Powershell

  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... Posted Monday, March 22, 2010 7:00 AM by Jonathan Kehayias | 1 Comments Filed under: Configuration, Database Administration, Powershell

• Getting Partition Offset information with Powershell

  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... Posted Monday, March 01, 2010 11:53 PM by Jonathan Kehayias | 5 Comments Filed under: Configuration, Database Administration, Powershell Attachment(s): Partition Alignment Report.zip

• Playing with Disk Alignment

  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... Posted Thursday, November 19, 2009 8:58 PM by Jonathan Kehayias | 3 Comments Filed under: Configuration, Database Administration

• Cleaning Out Your Backup History

  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... Posted Friday, October 30, 2009 12:19 AM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration

• SQL Server and Jumbo Frames

  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... Posted Monday, October 12, 2009 2:09 PM by Jonathan Kehayias | 2 Comments Filed under: Configuration, Database Administration