Search results matching tags 'Troubleshooting' and 'Best Practices'

Recap - SQL Saturday 151 in Orlando

KKline — Tue, 02 Oct 2012 14:19:00 GMT

It's always a feel-good experience for me to return to SQL Saturday in Orlando, the place where SQL Saturdays were started by Andy Warren (Twitter | Blog). On this trip, I delivered a full-day, pre-conference seminar on Troubleshooting and Performance Tuning SQL Server. I also delivered a session on SQL Server Internals and Architecture to a totally packed house. For those of you who emailed me directly, here's the link for the special SQL Sentry offer.

I got to attend the extended events session by Jack Corbett (Twitter | Blog), middle in the photo above. Good stuff, Jack! Jack led the Orlando PASS Chapter for a few years and, although he relocated back up to New England, he enjoys getting back to Orlando when the opportunity presents itself.

I also got a chance to do a podcast with Rodney Landrum (Twitter | Blog), in the SQL Saturday chef's outfit on the right. Rodney, you should get your blog details up at the PASS SQL blogger page, btw. Rodney is also known as "the guy with the Red-Gate tatoo". Ask him why, when you meet him in person. I'll post the direct link to our podcast when I get it from Rodney. But in the meantime, be sure to check out his SQLBeat webcast. There are lots of great speakers and respected authorities to hear on his podcast.

As I mellow with age, I've found that I most enjoy connecting with friends and building relationships. The above picture shows me, Eddie Weurch (Twitter | Blog), and Pam Shaw (Twitter), head of the Tampa PASS Chapter. Pam, Eddie, and I were swapping some hilarious stories about our early years in snowy climates. Pam had the good fortune to be pulled, face first, through the snow by her mom during a trip to the school bus stop on the first big snow of the season. Mom, it seems, wanted to make sure she got to the bus stop safely, but instead fell down two steps from the front door of their home, sliding all the way to the bus stop firmly clutching Pam's hand. ROFL!

I got to spend some time with Ryan Adams (left) and Kendal Van Dyke (right), as well. There may have been some liquor involved. However, the highlight of my evening was definitely when Kendal yelled "FINALLY!" at the waitress bringing our plates out ten minutes after the appetizers were served. Kendal was actually paying no attention to the waitress or the plates and was instead yelling at the TV where the Florida State vs South Florida football game was playing. The waitress, on the other hand, was mortified. Hilarity ensued as he tried to explain that he was not the least bit cross with her. :^)

Ryan is going to be presenting at the upcoming spring 2013 SQLCruise event. You should definitely attend! Ryan Adams has lot more content here (Twitter | Blog). Kendal, by the way, is a standing member of the current PASS Board of Directors. He's written some excellent content and, just recently, moved to Upsearch consultancy where my friend Allen White (Twitter | Blog) works. Kendal Van Dyke has more content here (Twitter | Blog).

I hope you're planning to attend a SQL Saturday event soon. And not just the event, but also the after-event gatherings as well. You can almost always be sure that most of the speakers will be there. It's a great way to enlarge your professional network as well as to make real and lasting friendships!

Enjoy,

-Kev

-Follow me on Twitter

New White Paper: SQL Server Extended Events and Notifications

KKline — Wed, 25 Apr 2012 13:13:00 GMT

SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look?

As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white paper, we will look at a couple technologies – event notifications and extended events – that can help you achieve these goals. With these two features, we’ll look at the error log and deadlocks, and demonstrate how you can get relevant information delivered as it occurs. We’ll also look at ways that run-time errors can be captured and used to help reduce the amount of time required to investigate issues.

This white paper, written by SQL Server MVP Jason Strate (blog | twitter), is a free download but requires a registration. Download the Extended Events white paper here.

And, as always, I enjoy your feedback. Thanks!

-Kev

Follow me on Twitter!

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!

Plan for Diagnostics in Cloud Computing From the Git-Go

BuckWoody — Tue, 06 Sep 2011 13:11:22 GMT

“Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch the system from end-to-end.

This approach is a mistake for an on-premise system, and it’s definitely a problem for a distributed architecture. You simply do not own all of the components from end to end in a cloud environment, nor are you always able to attach a debugger or other remote monitoring tools to the various areas within the code path. So you need to make sure that from the very outset of your design that you build in diagnostics. My personal preference is to build a system such that a control file turns on deeper information gathering from the system, up to a minimal level.

When I do that, I set a high level of logging, a medium level, and a moderate level. I normally use the deepest level of information during the testing and acceptance phase of the deployment, then switch to moderate and then the least level of information gathering. Also in my design I often set an error condition to begin gathering the deeper information along with the exception, where possible.

There are decisions you need to make as to where to store the diagnostics (many operations in the cloud cost money), how often you collect them, and so on. You can get a quick overview on using the diagnostics that come with Windows Azure here: http://www.azuresupport.com/2010/03/getting-started-with-windows-azure-diagnostics-and-monitoring/ This is where you should start first. More detail on that: http://msdn.microsoft.com/en-us/library/gg433048.aspx

My friend Dave Pallman has a great tool he’s released for free: http://davidpallmann.blogspot.com/2009/03/azure-application-monitor-now-on.html

If the issue is in storage apps: http://social.msdn.microsoft.com/Forums/en-US/windowsazuredata/thread/d84ba34b-b0e0-4961-a167-bbe7618beb83

If you have System Center, this is the quickest and easiest way to implement the monitoring – really handy: http://pinpoint.microsoft.com/en-us/applications/windows-azure-application-monitoring-management-pack-release-candidate-12884907699

Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

KKline — Mon, 27 Jun 2011 14:39:00 GMT

First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective. Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster!

The bigger your databases get, the longer backups take. That doesn't really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible.

Join my buddy Brent Ozar (blog | twitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important maintenance tasks run faster.

You'll discover:

Why Instant File Initialization is so important for restores
How to use DMVs to check restore progress
How to find the bottleneck while you're backing up or restoring data

Watch the recorded presentation at http://www.quest.com/events/ListDetails.aspx?ContentID=13358!

Enjoy!

-Kev

Follow me on Twitter at kekline

More content at http://KevinEKline.com

Available Online - SQL Server Training Videos

KKline — Thu, 02 Jun 2011 03:37:00 GMT

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

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

More content at http://KevinEKline.com

Reminder: Totally Awesome and Totally Free Training SQL Server Training

KKline — Mon, 21 Feb 2011 13:45:00 GMT

One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world),

Don't forget that free DVDs of our virtual conferences featuring me, along with Buck Woody (blog | twitter) and Brent Ozar (blog | twitter) will be mailed anywhere in North America free of charge, now available at this link.

Enjoy!

-Kevin

Twitter at kekline

More content at http://KevinEKline.com

Have You Heard About Project Lucy?

KKline — Wed, 16 Feb 2011 19:17:00 GMT

Lucy, You Got Some 'Splainin to Do!'

Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse. The best things about Project Lucy include:

It’s Free - just like our SQLServerPedia website, Project Lucy is free to anyone who wants to upload a trace file
It’s 1oo% web-based - you don’t have to download or maintain anything and updates roll out seamlessly, all the time
It really helps - just generate a SQL Trace on a SQL Server 2000, 2005 or 2008 instance, upload it on www.projectlucy.com, and see for yourself

This initiative empowers DBAs and IT professionals to gain a better understanding of their database performance through automated analyses and collaboration with their peers. Our goal is to allow users to go beyond the benefits of installing and using a commercial product, and tap into an online community to share and compare experiences and results. Our goal is to test the best ways we can help users learn and understand what their performance data really means, and how they should act upon that data – if at all – in a collaborative, meaningful way. For this debut, Project Lucy will accept SQL Trace files, or zip files containing multiple traces, and will provide a summary of the content and areas where performance can be improved. As y'all use the service, information will become available to help you compare your performance and engage in meaningful discussions with others about the issues you are facing. Your feedback, your feedback, and participation will drive how Project Lucy evolves. Get involved by participating in the pilot program! And let me know what you think.

Go to www.projectlucy.com to get started!

Enjoy! -Kev

Twitter at kekline

More content at http://KevinEKline.com

My Last "Catch-Up" Post for 2010 Content

KKline — Fri, 31 Dec 2010 20:57:00 GMT

I did a lot of writing in 2010. Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active.

So here are a few more posts from my blog, put on-line during the months of November and December 2010, that I didn't get posted here on SQLBlog.com:

1. It's Time to Upgrade!

So many of my customers and many of you, dear readers, are still on SQL Server 2005. Join Kevin Kline, SQL Server MVP and SQL Server Technology Strategist for Quest Software and Brent Ozar, SQL Server Domain Expert for Quest Software as they introduce the top ten features and capabilities in SQL Server 2008 that they find to be the most exciting and valuable.

2. Dealing with the Micromanaging Boss

This is probably my favorite professional development article of the year. Micromanagers make us feel untrusted and stymied by their constant need for tediously detailed and frequent updates, constant changes to minor details of our work, and overly developed attention to administrative details that really don’t matter in our daily job. But there’s hope! Get all of my career advice on dealing with micromanaging bosses here.

3. [Video] Troubleshooting Memory Pressure on SQL Server

This is a little bit of an older video. But it's still useful info if you're working with SQL Server 2005 or 2000. Check it out here.

4. [DBTA] What the Heck is Microsoft's Database Product Trajectory?

I was once asked what I thought Microsoft's overall product trajectory for SQL Server was, in light of Oracle's rather obvious trajectory of acquiring multiple application vendors who will, in turn, deploy more and more of their applications to the Oracle database platform. You can read all about my thoughts in my monthly column at Database Trends & Application magazine - [READ MORE]

5. Eight Characteristics of Excellent Leaders [Plays Well With Others]

In this installment of my professional development column called Plays Well With Others, I talk about what distinguishes truly great leaders. There's a lively discussion on the topic and I encourage you to take part. Read it here.

6. The Shape of Database Licensing Costs to Come [DBTA]

One fall semester many years ago, I was a university freshman. Actually, I was anything but "fresh." I was dumb enough to think that 8 a.m. was a wonderful time to attend Economics 101. After staying up until the wee hours most every night, the "dismal science" took on more than one meaning as I set my clock just early enough to get to class on time. Along with 30 other very naïve classmates, I staggered into class and did my bleary-eyed best to focus on the lessons at hand. There were lots of Greek compound words and lots of graphs.

I learned, for example, that the word economics derives from the Greek "oikonomikos," which means, approximately, "death by slidedecks" and, specifically, "house" (oikos) and "management" (mikos). I barely survived the experience and never took an 8 a.m. class again. Imagine my surprise, then, when a lesson I'd learned (and promptly forgotten) all those years ago jumped back into my consciousness late last year. - [READ MORE]

7. So You're the Boss Now... [Plays Well with Others]

If you have any ambition at all, you have probably wanted (and possibly gotten) a promotion over your current colleagues. If you've been there before, you know that once friendly relationships can get, well, weird. Read my tips and tricks for how to make the most of this situation in this professional development article.

8. The NoSQL Movement - Hype or Hope?

NoSQL is no fad. And you need to be in the "know", not necessarily in the "No". Gno? Pneu? Too many phonetically similar pronunciations! Read my thoughts on the NoSQL movement on one of Database Trends & Applications magazine's most popular articles of the year. - [READ MORE]

9. Effectiveness and Efficiency at Work [Video]

In this golden oldie (yes, two years constitutes "old"), I present my thoughts on how to be both effective and efficient on the job and in life in general. And if you didn't know that these are different concepts, then you need this video most muchly.

10. What's Your Data Management and Retention Policy? [DBTA]

If managing your corporate data for the long term isn't currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE]

Follow me on Twitter!

Originally Posted on YoutTube November 12, 2008.