Search results matching tags 'Best Practices', 'Performance', and 'Internals'

SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

KKline — Mon, 23 Apr 2012 13:15:00 GMT

One last reminder - If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday. Full details are here: http://sqlperftuning.eventbrite.com/. We'll be working some exercises, so bring your laptop with an instance of SQL Server 2008 (or later) running on it. It'll be fun!

I also encourage you to come on down to SQL Saturday 130 the following day - whether there's an official registration for you or not. (But don't tell 'em I said that). :^)

Come by the booth for a visit. I'll be hanging out most of the day and have some nice swag to give away.

Enjoy,

-Kev

Follow me on Twitter!

New on SQLMag.Com: Update to SP_WHOISACTIVE

KKline — Thu, 21 Apr 2011 14:12:00 GMT

I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time. Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - http://www.sqlmag.com/blogs/tool-time/entryid/76341/new-release-of-sp_whoisactive).

Enjoy!

-Kev

Twitter at kekline

The Most Important Performance Monitor Counters for SQL Server

KKline — Fri, 28 Mar 2008 19:18:00 GMT

If you're well-versed in using PerfMon, I'd like to hear about the counters that you use regularly and what constitutes a good or bad value.

However, it's a rare individual who knows their way around PerfMon and its multitude of performance objects and counters. Which ones should you track? And even if you know the right ones to track, what values indicate good or bad performance?

If you've ever struggled with knowing which PerfMon counters to track for SQL Server performance, take a look at my TechTarget series of screencasts at SearchSQLServer.com. They'll give you most everything you need to know about using PerfMon and assessing PerfMon counters to learn about the behavior of SQL Server. It's a four-part series with the first two sessions, PerfMon Counters for Tracking Memory and PerfMon Counters for the Windows OS, already posted. These screencasts not only tell you which counters to track and why, but also what are the general rules of thumb for good performance when using these counters.

Enjoy!

-Kevin

P.S. I cover a variety of PerfMon counters in these screencasts. Many of them are discussed in an excellent document put together by Microsoft PSS. Read their blog at http://blogs.msdn.com/psssql/default.aspx.