The Zombie PerfMon Counter That Never Dies! Quick Tip

The PerfMon Counters That Just Won't Die One of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away.  (Some day, politicians will realize this.  We can easily fact check their consistency).  Because of longevity of content posted to the Internet, a lot of performance tuning topics become "zombies".  We shoot 'em in dead, but they keep coming back! In other words, those old recommendations were a suggested best practices for long ago, for a specific version of SQL Server, but are now … [Read more...]

Two New Slide Decks. Plus, the Week in Colorado.

I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver.  At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers.  Denver, in fact, was standing room only and had nearly 30 first time attendees.  Great news!  I also want to give a special shout-out of thanks and appreciation to Chris Shaw (Twitter | Blog) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to … [Read more...]

Accelerate OLTP with HP and Microsoft’s New High Performance Reference Architecture

If you haven't started to read Shashank Pawar (blog), you're missing out.  Shashank is part of Microsoft Australia and has been writing some very good content lately.  Here's an example from the Reference Architecture for High Performance SQL Server: HP and Microsoft engineering teams have worked together to create a reference architecture to Accelerate Online Transaction Processing (OLTP) database workloads with a fully-flash based HP/Microsoft architecture and achieve significant performance increases, simplified database manageability, and industry leading TCO. The details come in a … [Read more...]

New on “Database Trends & Applications”

In last month's column, "2012 Might Really Be the End of the World as We Know It," I described a number of major developments in the IT industry that are likely to disrupt the life of database professionals everywhere.  I categorize those four disruptors - virtualization, cloud computing, solid state drives (SSD), and advanced multi-core CPUs - into two broad groups.  I'm going to continue an analysis of these disruptive technologies in inverse order.  Today, let's discuss SSDs. [READ MORE ON DATABASE TRENDS & APPLICATIONS ] … [Read more...]

What I’m Reading, July 22 2011

I read too much, and that, my friends, is an entirely separate topic for a blog post. But I thought I'd share with you a little more about what I'm reading because sometimes, if I'm lucky, it might be something you'd enjoy too. So I'm going to start sharing what I'm reading at least once per week, partly so that I don't firehose too many reading links directly into your brain (where I to do it say once per month) and partly to solidify in my own mind the information that I'm reviewing. So here are a few good links for the seven days leading up to July 22, 2001: Microsoft and Whitehouse … [Read more...]

Available Online – SQL Server Training Videos

Interested in my various performance tuning and troubleshooting videos about SQL Server?  These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter).  View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE. You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE. Enjoy! -Kev ~~~ Twitter at kekline More content on my Blog … [Read more...]

Come Aboard. We’re Expecting You

Those of us over a certain age (read - old as dirt) can remember the theme songs to certain TV shows better than we can the National Anthem. Try these lines out and see if you don't immediately remember the tune that goes along with them: Come and knock on our door | We've been waiting for you ... Makin' your way in the world today | Takes everything you've got ... Just some good ol' boys | Never meaning no harm ... Thank you for being a friend | Travel down the road and back again ... So when I got the news that my employer, Quest Software, wanted to send one of the team to an … [Read more...]

Wednesday Quest: On-Line Demos for Toad Data Analyst and Benchmark Factory

If you've attended any of my public sessions about SQL Server technology, then you might remember that I extend a standing offer to provide a free, long-term license to any of several products from Quest Software, such as Toad for SQL Server (including the SQL Optimizer), Toad Data Analyst, Toad Data Modeler, and the awesome performance and scalability testing tool Benchmark Factory. If you've ever wondered about these tools and why I tout them, why don't you take a couple minutes to look at the on-line demos available at each of the preceding links?  If you like what you see, drop me a … [Read more...]

Video: Magic Formula for SQL Query Tuning

Featuring Kevin Kline this video focuses on accelerated Disk Optimization and improved productivity with SQL Query Tuning. Posted December 18, 2006. … [Read more...]

Video: Ensure Optimal Performance When Deploying SQL Server 2005

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including: * Hardware design * SQL Server configuration settings * Database configuration settings * Application design * SQL Tuning Posted December 20, 2006. … [Read more...]