SQL Sentry Countdown to SQLCruise Contest
This Sunday, a couple dozen database geeks and their loved ones will board the Norwegian Pearl for a week of SQL Server training, professional development, networking, fun, and relaxation. It’s a truly unique event where we get to learn AND teach – everyone involved in the cruise shares things they’ve learned in their daily life. The presenters learn just as much as they share, and that’s what makes SQLCruise my favorite week of the year. I just can’t wait until it starts.
SQL Sentry has been with us right from the start as a top-tier sponsor. I know the guys at SQL Sentry, and they share our passion for having fun while you learn and get your work done. For our very first cruise, they gave away not one, but FOUR cruises to community members! Who could forget Jorge’s hilarious Old Spice video, Erin’s daily job video, or Matt’s heart-string-tugging video? What a great time.
This year, SQL Sentry is helping us count down to SQL Cruise. Here’s our schedule:
- C-4: Wednesday (today)
- C-3: Thursday
- C-2: Friday
- C-1: SQLBBQ in Seattle
- C-0: Departure Day: Sunday
And we’re going to be giving away something fun here in the blog every day. Today, we’re giving away three prizes, each a SQL Server book:
Ooo, free learnin!
We’re giving away a copy of Securing SQL Server by Denny Cherry, Performance Tuning with DMVs by Louis Davidson and Tim Ford, and SQL Server 2008 Internals and Troubleshooting – but not just ANY copy of that last book, the Chinese translation! Yes, you can wow your friends with your knowledge of Mandarin. (I’ll autograph it in plain English though.)
To win, enter a comment on this post answering this question: “When looking at a SQL Server execution plan, how do I determine which operations are using the most CPU?”
Not sure what the answer is? We’ll actually give it to you on our free performance tuning webcast today.
Fine print – the contest is open to US residents only. (International shipping is painful.) Comments must be received before 6:00AM Eastern Thursday morning. Winners will be drawn Thursday morning and announced here on SQLcruise.com. If you prefer one of the three books, include the book name in your answer, and I’ll give priority to whoever gets drawn first. Good luck!
Look at the tool tip(CPU cost) for each operation.
Btw, I’m european but I’m in L.A. for the next two weeks
Preferred book: Performance Tuning with DMVs by Louis Davidson and Tim Ford,
Regards,
Steve
I throw the Query into SQL Sentry, F5 it… go to the Top Operations tab, order by Est CPU Cost… then cry(when working from home).
Answer is “Estimated CPU Cost” and prefer Securing SQL Server book
That’d be Estimated CPU Cost. Like Rob, I’d prefer to find the highest costing operation using SQL Sentry Plan Explorer, rather than in SSMS.
I’ve had my eye on both the perf tuning book and the security one. 😉
Load the plan into SQL Sentry Plan Explorer. Select the Top Operations tab and sort by CPU cost.
Wish I was going on the cruise. Have a great time.
I will use plan explorer and sort by CPU
In you hover over an opertation node and view the Tooltip that appears, it should be listed in the Estimated CPU Cost field. I would the Perf Tuning book.
Thanks,
Nick
Mouse-over elements of the Execution Plan and look for the Estimated CPU Cost.
I’d like any of the books. Though the Mandarin version would just serve to intimidate those coming into my cube.
I’m from Norway, but guessing that the Boat ain’t coming my way 🙂
Btw; cool photo!
SQL Sentry Countdown to SQLCruise Contest (Day 2) | SQLCruise | SQLCruise May 26, 2011 @ 7:06 am
[…] we asked you how to find the highest-CPU-consuming parts of an execution plan. Some of you just said “estimated CPU cost,” but that’s not enough – we […]
Check estimated CPU cost in the SQL execution plan.
Though I do wish I had SQL Sentry – sorting by CPU cost would certainly be easier than sifting through all of the execution plan elements. 🙂
Throw the Plan in SQL Sentry and you have the answer straight away…just sort by Estimated CPU Cost and there you go…………….