Search results matching tags 'Troubleshooting' and 'Cloud Computing'

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

What I'm Reading, July 22 2011

KKline — Thu, 21 Jul 2011 14:43:00 GMT

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 partnership on BigData: BigData isn't a particularly new concept. But I was intrigued to learn that the National Science Foundation, Microsoft, and 13 other teams were partnering on developing better BigData analytics for lots of government data from activities such as healthcare, economic development, education, transportation, and the power grid. Cools stuff! Plus, Microsoft has developed a new tool called Project Daytona to better harness the power of the cloud, in general, and Windows Azure, specifically.
While we're on the topic of Federal IT in the Cloud be sure to read this linked article from ComputerWorld. Say what you will about our government, but putting government IT in the cloud and increasing both its transparency and availability will make a huge difference in how the Federal government will be able to service the public. We're talking as big a difference as corporations experienced between the "catalog on the web" experience of the 1990's to the Web2.0 experience of today.
If you're the social media type, give this article a read discussing the Power of Hashtags in Social Media.
The Register, of the UK, whose tagline is "Biting the hand that feeds IT" has a great article on a spat over database technologies between the IT sage Michael Stonebreaker and Google. It's a great read if for no other reason than to prove that databases are worth fighting over.
And if you think Microsoft is still towing the relational database barge without thinking about other technologies, you need to read up on Projects Dryad and Daytona.
Finally, I'm still getting lots of questions about when and where to limit SQL Server's Max Degrees of Parallelism. Be sure to read Microsoft's Recommendations and Guidelines for 'max degree of parallelism' configuration option here.

And just because so many of us in IT are closet or former musicians, there's Live Guitar Lessons with Steven Krenz, sponsored by my hometown boyz at Gibson Guitar. Got a favorite article or tool tip? Let me know! Enjoy,

-Kev

Follow me on Twitter.

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

Join Me May 19th for 24 Hours of PASS

KKline — Mon, 26 Apr 2010 14:16:00 GMT

Join Us for 24 Hours of SQL Server Training

(with a special focus on SQL Server 2008 R2)

Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!?

The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May 19.

Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) - the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more.

When does it start? 12:00 GMT (UTC):

New York: 08:00
Chicago: 07:00
San Francisco: 05:00
London: 13:00
Paris: 14:00
Moscow: 16:00
Mumbai: 17:30
Singapore: 20:00
Sydney: 22:00

The roster of phenomenal speakers features many MVPs and top-rated presenters, including Adam Machanic, Andy Leonard, Brad McGehee, Brent Ozar, Brian Knight, Chuck Heinzelman, Dean Richards, Don Kiely, Don Vilen, Donald Farmer, Glenn Berry, Greg Low, Jacob Sebastian, Jessica Moss, Kevin Cox, Kevin Kline, Louis Davidson, Maciej Pilecki, Peter Myers, Peter Ward, Rushabh Mehta, Sean McCown, Simon Sabin, Thomas Grosher.

Check out all the great SQL Server sessions you can attend for FREE. Share this information with a friend or colleague.

PASS is looking forward to having you join us all for this exceptional event. Please contact us at 24hrs@sqlpass.org with any questions. You can also find lots of general details at http://www.sqlpass.org/24hours/2010/.