Category: Career

  • Creating a Cluster for HadoopOnAzure CTP – Small Bites of Big Data

    Creating a Cluster for HadoopOnAzure CTP

    Small Bites of Big Data

    Cindy Gross, SQLCAT PM

    UPDATED Jun 2013: HadoopOnAzure CTP has been replaced with HDInsight Preview which has a different interface: Getting Started with Windows Azure HDInsight Service http://www.windowsazure.com/en-us/manage/services/hdinsight/get-started-hdinsight/

    Are you ready to dive into this “Big Data” thing you keep hearing about? A good way to get started without having to understand and install all the HDFS, MapReduce, and other pieces yourself is to join the Hadoop CTP. It’s a very popular program so once you sign up you may have a short wait before you are given an account. Any cluster you create is time-bombed to free up unused resources for other eager CTP participants. This post will assume you’ve been granted a CTP account to use on https://www.hadooponazure.com/.

    1)      Sign in to your Hadoop on Azure account. Go to https://www.hadooponazure.com/ and click on the “Sign in” button.

     

    2)      If you don’t currently have a cluster allocated, you will be taken to a screen where you can request one.  Note that the saying at the top of the screen will change randomly each time you navigate to a screen.

    • Choose a unique name for your cluster and it will append .cloudapp.net.  My cluster is called cgross.cloudapp.net.
    • If you are just playing around be respectful of the fact that this is a very popular CTP and choose the “Small” cluster size (currently 4 nodes, 2 TB disk space).
    • Choose a Cluster login and password. I use a different login than my cluster name, cgross1.
    • You can choose to use SQL Azure for your Hive Metastore but I’m going to skip that for the sake of simplicity.
    • Choose “Request cluster”

     

    3)      It will take several minutes for your cluster VMs to be created and allocated.

     4)      After a few minutes you will see a message that your cluster is ready for use. In the upper left you can see how long you have before the cluster expires. When you reach about 6 hours left you can choose the “Extend now” button to keep your cluster longer. You can also choose to “Release cluster” when you are finished to free up those resources for other CTP participants.

       

    Explore the various tiles and what you can do in each. You may want to start with the “Downloads” tile and go through the “How-To and FAQ”. If you are idle for a while you will be logged out of the site, but this as long as the cluster has not expired it will all still be there once you log back in. The “Job History” stays around across cluster builds, it is not cleared out when a cluster is released or expired.

    I hope you’ve enjoyed this small bite of big data! Look for more blog posts soon on the samples and other activities.

    Note: the CTP and TAP programs are available for a limited time. Details of the usage and the availability of the CTP may change rapidly.

  • Leadership – Influencing Others

    Leadership – Influencing Others

     

    A good leader is able to influence others, whether it’s directly or indirectly. Influence is about your ability to have an impact; it’s not about getting exactly what you want. Generally you are participating in a joint effort and you may be delegating actions to others with or without authority. However, influence goes beyond getting a specific task or project done. It’s really about building relationships. If you’re a good influencer you use your influence for good and don’t stoop to manipulation. Most people influence others to some degree all the time whether they know it or not.

    As you decide where to focus your networking time you’ll want to factor in both who you need for your success and the success of your projects and who needs your help to be more successful themselves. Have both a long term strategy and short term tactics in mind as you foster your networks and decide who try to influence and what influence you will accept from others.

    In order to influence effectively you need to build trust. Be authentic, admit when you are not sure you will be able to help or have other uncertainties, and be willing to open yourself up in return for others’ openness. Once you have given and earned trust you will find it easier to get others to buy in to your goals and make their own contributions. When you keep long-term trust in mind you stay in the “good” arena of influence and are less likely to lower yourself to pure manipulation. This helps build your credibility and image.

    A successful influencer is good at understanding and communicating “what’s in it for me” (WIIFM) for everyone involved. There may be direct, easily visible, and/or immediately applicable reasons as well as less tangible “good for someone’s career” type motivations. What is an obvious advantage from your viewpoint may not be easily seen by others or may have unseen and/or unintended consequences you haven’t thought of. Verbalizing WIIFM is key.

    From a tactical perspective, make sure you engage people before decision making points such as meetings. Have 1:1 conversations and get a feel for who will be supportive. Pay attention to body language and tone of voice. Give credit to others when appropriate and don’t feel you have to get visible credit, no matter how deserved, for every item you contributed. If someone else puts forth an idea that you’ve already expressed don’t assume bad motivations. It could mean the circumstances have led multiple people to the same conclusion or it could be that something you said earlier sank in over time and was well received, whether they consciously remember where they first heard the idea or not. If you feel you really have to point out that you already presented an idea, try phrasing it as “thank you for articulating that so much better than me”.

    Make sure you celebrate successes and give praise. Praise should be specific and include the impact, not just the action. For example: “Susie provided a key resource for this project that enabled us to include a highly-requested feature in the program that would have otherwise been cut. This has led to increased sales (of X%) and increased customer satisfaction.” Celebrating success leads to more success.

    When you influence others you are practicing a skill that is key to your success. Build your networks, build trust, give credit and rewards when appropriate, and learn to think in terms of WIIFRM. Being a good influencer can have a positive impact on projects, people, and your own career.

    Take a look at my other leadership blogs and share your own leadership stories! http://blogs.msdn.com/b/cindygross/archive/tags/leadership/

    Influence is a key takeaway for me from my Women Unlimited sessions.

  • SQL Server 2012 RC0 available

    Release Candidate 0 (RC0) of SQL Server 2012 is available for download! That means you can start to experience a feature complete version of the next great SQL release. 🙂 We’re still looking at the first half of calendar year 2012 for the RTM release of SQL Server 2012.

    FURTHER.  FORWARD.  FASTER.

    Downloads:

    Greater availability. Deliver the required 9s and data protection with AlwaysOn, delivering added functionality over CTP3 that allows customers to experience multiple, readable secondaries for distributed scale of reporting and backup workloads and support for FileTable and FILESTREAM which brings first-class HA to complex data types.

    Blazing-fast performance. More effectively govern performance in multi-tenancy environments like private cloud. Resource Governor enhancements include support for 64 resource pools, greater CPU usage control, and resource pool affinity for partitioning of physical resources and predictable resource allocation.

    Rapid data exploration. Empower end users with new insights through rapid data exploration and visualization. Discover new insights at the speed of thought with more feature/functionality in Power View, the highly interactive, familiar browser-based data exploration, visualization, and presentation experience for end users.

    Credible, consistent data. In addition to CTP3 functionality delivered for Data Quality Services and Master Data Services, customers can better support heterogeneous data within Data Warehouses through new Change Data Capture (CDC) support for Oracle.

    Optimized productivity. Optimize IT and developer productivity across server and cloud with the new SQL Server Data Tools, a unified development experience for database and business intelligence projects, and cloud-ready capabilities within SQL Server Management Studio for snapshot backups to the Windows Azure Platform. Additionally, SQL Server 2012 offers a new version of Express – LocalDB. SQL Express LocalDB is a lightweight version of Express with all its programmability features, yet runs in user mode with a fast, zero-configuration installation and short list of pre-requisites. For more information and to try it out, go here.

     Licensing:

     SQL Server 2012 Wallpaper/backgrounds:

     More about SQL Server 2012:

     If you don’t already use it, now might be a good time to run the Microsoft Assessment and Planning (MAP) Toolkit. If you load the sample MAP database and go to File.Prepare New Reports and Proposals you can see what typical SQL inventory reports look like. The output includes version, service pack level, edition, whether it’s clustered, # of procs and cores, and system memory. You would need to have a SQL database to store your own inventory results.

     Microsoft Assessment and Planning (MAP) Toolkit http://technet.microsoft.com/en-us/solutionaccelerators/dd537566.aspx

     Data Sheet:

    MAP provides you with actionable information from the start. In a matter of hours, MAP helps provide you with answers to key questions like:

    • Which of my PCs can run Windows 7, Microsoft® Office 2010, and Office 365?
    • Are my web application portfolios and databases ready to migrate to the Windows Azure platform? What is the TCO-ROI?
    • What next steps should I take to plan a private cloud?
    • Which of my servers are capable of migrating to Windows Server 2008 R2, or can be virtualized using Hyper-V?
    • Where can I find Microsoft® SQL Server® 2000, MySQL, Oracle, and Sybase instances for migration to Microsoft® SQL Server® 2008 R2?
    • Is our software usage in compliance with software license agreements?

  • Leadership – Strengths and Weaknesses

    Leadership – Strengths and Weaknesses

    As part of my attempt to grow as a leader I took the StrengthsFinder survey. I got this one from the Go Lead Idaho sessions I am attending. It’s based on a Gallup survey and is all based on self-assessment. It was a quick and painless survey with clear, concise output. It’s based on a series of questions created and vetted over many years by Gallup, the experts in polling and finding out what people are thinking. Some of the questions seemed nonsensical and all were time-limited. If you can’t decide in 20 seconds where you fit on the scale then it’s not a defining question for you. The premise is that there are 34 themes that people are strong or weak in. Based on talking to a couple of career coaches the results are remarkably accurate for most people, no matter how much you resist the names of the themes. You take your top 5 strengths and concentrate on those. Don’t try to “fix” your weaknesses since that would focus your attention in the wrong area. Focus on your strengths instead. In that vein, the output from the survey only tells you your top 5 areas. Not the top 6, not a ranking of them all, not a clue what your “worst” 5 areas are. There’s a worksheet that helps you highlight which aspects of each area resonate with you and you should pick a key point from each to focus on. As an illustration of the themes, my strengths are listed below with the points I feel best describe me included below each item.  

    • Harmony
      • You rely on collective intelligence and wisdom of experts to guide you towards the best solutions or answers
      • You regularly point out what is wrong
      • You zero in on difficulties, glitches, obstacles as early as possible so individuals can deal with them easily
      • Key terms: Logically, unemotionally, practical thinker, consensus
      • My key point: You help others see things as they actually are
    • Consistency
      • Set up clear rules and adhere to them
      • You study and examine plans before you leap into action
      • You want everyone including yourself to be happy
      • You go out of your way to treat every person you meet with the same amount of respect, care, concern, and hospitality
      • Key terms: unsentimental, realistic, streamline, overlook no detail, concentrate on facts, practical
      • My key point: Because you check so many things beforehand, the number of misunderstandings and miscommunications between people is likely to decrease dramatically
    • Learner
      • You fill your mind with new ideas
      • Process of learning, rather than outcome, excites you
      • Accumulate facts, data, stories, examples, or background information from the people you meet
      • Want to be kept in the information loop
      • You gravitate to people who converse about ideas at a deeper and more thoughtful level than most individuals are capable of doing.
      • Small talk is seen as a waste of time
      • You capitalize on your ability to ask questions and listen to people’s answers
      • Key terms: thirst for knowledge and new ideas, continuously improve
      • My key point: examining the interaction between various parts is as important to you as knowing what each part is designed to do
    • Achiever
      • Resist being held back, restrained, or controlled by people or events
      • Prefer to be in charge
      • Need fewer detailed explanations than many people require
      • Prefer people who are trustworthy
      • Key terms: stamina, hard work, busy, productive
      • My key point: outstanding results and demanding standards (on self)
    • Analytical
      • Want to understand how one idea or fact links neatly to whatever precedes and follows it
      • Search for causes and reasons, think about all factors that could influence a situation
      • Automatically double-check your work
      • Prefer company of people who carefully listen to what you say
      • You make sure you know as much as possible about a contest before you decide to enter it
      • You revel in gathering data and evidence to get answer before being told answer
      • Key terms: examine, sound reasoning, reader, values information
      • My key point: reduce things to their simplest parts

     Note that many of these things can be described in less flattering terms by those who don’t appreciate these strengths. For instance, pointing out what is or could go wrong is to me a key strength. From my perspective if I don’t point out a weakness no one can address it and make the final output stronger. In my world you create a list of things that don’t seem quite right and things that could go wrong, you look it over and see what’s worth addressing, and if what’s left isn’t insurmountable go ahead with a good sense that things will succeed. But over the years I’ve been told I am trying to make projects fail, that I am too negative, and that I am making things overly complicated. It took me a while to find a job where that was seen as beneficial, and I also have to temper my approach. So take your strengths, own them, and make it clear that they are strengths. Don’t let others define you and your traits.

    One trait most people share is that they tend to hire and reward others like themselves. That includes preferring people with similar strengths. Therefore many teams have a lot of people who are good at the same things and big gaps in other areas. That means there are potential strengths that the team has difficulty exploiting. Other teams have a good mix of strengths and team members can rely on other team members to fill in their own gaps. That sounds great, but you have to be able to manage the inevitable conflict. As an Achiever “down in the weeds” implementing something I will be annoyed by the Activator who from my perspective is always starting things and never finishing them. The Activator is annoyed by the Achiever who can’t keep up with their new and inventive ideas. Alone the Achiever works on the unimportant projects and the Activator never gets anything done. But together we can define the strategic, game changing projects and get them implemented to near perfection – as long as we recognize and utilize each other’s strengths. Asking an Activator to slow down and follow through (or from their perspective getting stuck in the weeds) is asking them to work in their weak area and holding them back from doing what they do best. Asking an Achiever to abandon a project (from an Activator perspective move on to something new because they’re done with the last one) is only asking for frustration.

    One key point is that you have to satisfy your motivators every day. A great example came from a Learner. She figured out that she was getting sidetracked with meaningless web searches and Wiki reading during critical projects. But when she purposefully looked up a few interesting topics each morning or read a chapter before starting work, she had satisfied her learning motivator and could concentrate on her work. Find a way to satisfy your motivators in a way that moves you forward.

    The themes themselves are simple. You can take them at their face value or you can spend hours upon hours diving into the explanations and action plans around them. How you approach it will reflect your individuality and your personal strengths. However you get there, find your own strengths, surround yourself with smart people, and lead from your strengths.

  • SQL PASS: All the Magic Knobs – Tools

    SQL PASS: All the Magic Knobs – Tools

    In my All the Magic Knobs talk at #SQLPASS 2011 I discussed some easy ways to determine if you’re using some of the performance magic for SQL Server. When you have many consolidated, non-tier 1 databases you don’t have a lot of control over, the best way to tune is to provide a solid, performant infrastructure through low effort, high impact choices. The same steps help in your tier 1 environments as well. The quickest way to see how close you are to that standard is to run one of our automated health checks. They check the SQL instance itself and some of the most important Windows settings that help SQL Server operate optimally.

    SQL Best Practices Analyzer (BPA) is available for SQL Server 2000, 2005, and 2008/2008 R2. It is an add-in to the Microsoft Baseline Configuration Analyzer (MBCA). Both the MBCA and the SQL BPA are free. You can run the BPA locally or remotely and you can find plenty of sample scripts to run it against multiple instances. You choose your schedule for execution and you can either review the output after each execution manually or write your own program to alert you to what you consider the most serious items.

    The System Center Advisor (SCA) is at this point still in pre-release. Licensing details will be available after release, for now you can download a free trial. It works for SQL Server 2008 and newer on Windows 2008 and newer. SCA runs on a schedule and sends alerts when a registered instance is not configured as advised. What it checks can change dynamically as PSS finds new important items.

    Several companies, including Microsoft through our Premier Field Engineering (PFE) team, offer various health checks that include knowledge sharing and additional advice to help you decide if, how, when, and where to implement the recommendations.

    Of course, you have to actually implement the recommendations to get the benefit; the tools listed above don’t do any remediation on their own. While that should go without saying, in my experience known recommendations often go unimplemented until some problem they would have prevented pops up.

    For more SQL Server best practices see some of my other blogs: http://blogs.msdn.com/b/cindygross/archive/tags/best+practices/  

     

  • Leadership – Taking Feedback

    Leadership – Taking Feedback

    As you may have seen from my other blogs, I’m taking leadership courses and trying to stretch and define myself. It is hard work but I think it is going to be well worth the trouble. I’m getting great input from many sources and writing about it helps me think it through.

    One great piece of advice I’ve gotten is to look at feedback as a growth opportunity. Feedback is like gold; take it, mine it, and use the best parts. But all feedback is not equal. If you get a low rating on a survey or what you consider “bad” feedback from an individual it might indicate you don’t do that particular thing well, it might mean you do it well but don’t make yourself visible when you do it, or it might mean that person has some other agenda. Take feedback in context and look for trends, patterns, and situations. If multiple people or people whose opinion you really value (or need) say something, that’s probably more meaningful than an offhand comment from someone you rarely interact with. If the feedback is about something that has nothing to do with improving your leadership skills, do you really need to prioritize it?

    Once you have the feedback, make sure you truly examine it. Don’t jump to conclusions. Look at your reaction. If you immediately dismiss it or get defensive, think about why. If you’re constantly repeating it as something unbelievable that someone has said, maybe you’re missing the point. If they say you need to do something you think you already do, maybe you just haven’t made it clear that you already do that. Or maybe you don’t do it as well as you think. Maybe you are using the same terminology to mean different things. Go back and ask, without being defensive, for clarification and more details. Don’t accept “you need to work harder” – ask “what does hard work look like to you?” Ask “how will you and I know when I’m working hard enough?” If you’re told to be friendlier, ask for specific examples of when you appeared to be less than friendly and tips on how a friendly person acts in that person’s eyes. Don’t immediately offer a defense of the situation, ask for more examples. Offer suggestions such as “If I do X instead of Y do you think that would be better?”

    If the feedback indicates you need to do something that doesn’t fit with your values, needs, and desires go back and address it. Doesn’t stew about and wonder if the person giving the feedback is clueless or out to get you. If you’ve asked for clarification and still believe it doesn’t fit with you, try to find out how important it is. Do you need to change? Does the person’s expectation need to change? Does their expectation really matter to you? Can you substitute something else that’s close enough for their needs but fits better with the real you? Can you agree to disagree and agree that this one thing isn’t going to be a big obstacle to good assignments, promotions, and raises? Don’t obsess about, do something about it.

    Last week at #SQLPASS there were about 14 people attending from Boise! That’s a great showing since sometimes we don’t have many more in our Boise SQL Server Users Group meetings. At the chapter lunch one of the regular user group attendees made an offhand comment that I was always correcting people during chapter meetings. Others at the table agreed. I obsessed about it for a while… ok, it still bothers me. But I think he’s right. Whenever we have a speaker at the user group I always have to add something. And by add something I probably mean correct them. Most of the user group probably doesn’t need each subtle point explained at great depth, but I have trouble controlling myself. Should I change that aspect of myself? I’m still debating if and how to deal with it. But at least now it’s on my radar. I can think about it before I make a comment during a presentation or when talking to a customer. How important is it to really get that subtle distinction (correction?) into the conversation? That was a good piece of feedback and I am trying to treat it as the gem it is instead of reacting with “no I don’t”. Because “no I don’t” is a correction to his feedback. Instead I’ll take the golden nugget and use it to improve my own interactions. And that’s what feedback is about.

  • Leadership – What Does It Mean?

    Leadership – What Does It Mean?

    What is a leader? Are you a leader? Do you have to be a people manager to be a leader? Do you care about leadership?

    These are all questions I’ve faced recently. I’m attending some leadership training and I’m doing a lot of introspection. When I got to the first Women Unlimited session I actually started my answer to the ubiquitous “why are you here” question with “my manager made me come.” And I sort of meant it. But really that was a cover for my reluctance to face the hard questions about myself, my career, and my life. I knew that once I started digging I would find things I didn’t want to know or address. I knew it meant a lot of time and hard work. But as my friend Suzanne Jackowski said at the #SQLPASS #PASSWIT lunch, “What would you do for a Klondike bar?” That’s the first time I’d heard it related to getting ahead at work, but it’s a perfect fit. Does it really take “too much time and effort” to figure out your true desires and goals? To take that knowledge and search for a job that lets you use your strengths and doesn’t force you to constantly work on your worst weaknesses? To figure out what you want to be known for? What exactly am I willing to do for an even better job and career? And if I’m not willing to do it, who’s to blame when I wish my career were going in a different direction?

    So now I’m commencing a round of trying to define my brand, interviewing respected leaders, analyzing the difference between managers and leaders, learning to play to my strengths, taking surveys, and thinking all the time about how everything I do or don’t do looks to those who matter – whoever that may be. Because letting leaders know what you’re doing is key to your success. I signed up for a series of four sessions with Go Lead Idaho, attended a talk at work given by people one level above myself, and am thinking hard about what else I need to do to gain control of my future.

    Back to the questions I started with. A leader is someone who gets people to follow. It’s that simple. Sometimes I’m a leader, oftentimes I’m a follower. Managers might be leaders, and leaders might be managers. But there’s no true relationship between them. We like to think managers are chosen for leadership skills, but quite often they’re chosen for doing their last job well. And when someone is chosen for leadership rather than knowing the job well, we all complain that they don’t understand us and our jobs. I work for a company that highly values leaders and gives them the option of a non-management track to advance very far up the chain, so I don’t have to be a manager to be a leader. As for the question of do you care about leadership, that’s up to you. Do you want to be in control of your life and your career, or are you comfortable following? For most of us the desire and need to be a leader will change over time, perhaps even over the course of a day. Be a leader when you can and follow when it makes sense. The hard part is knowing when each is appropriate.

  • SQLPASS: Are You Smarter Than an MCM? VLF Demos

    Are You Smarter Than an MCM?

     I had a great time on Wednesday co-presenting with some great SQL peeps! We dressed up, had a lot of fun, and shared a few technical tips along the way. My demo was on VLFs, an often forgotten and/or misunderstood part of the transaction log technology. The demo files are attached below. Thanks to everyone who came to the talk! #SQLPASS

    The Team for DBA-414-M

    Our fabulous “Smarter” team is

    VLFs

    Question: Cindy has ADHD.  In the past she we able to keep up with multiple tasks at once, but lately she has slowed down.  Why? 

    Answer: Excessive VLFs

     A VLF is the boundary within your log file(s) for log operations such as scans (replication, recovery, mirroring, CDC, etc.) and log clearing/truncating.

    • 100s of VLFs might be ok, 1000s is probably bad, 10s of thousands is almost certainly bad. Bad means much slower operations for activities that operate within VLFs boundaries.
    • DBCC LOGINFO is undocumented and unsupported but is the only way to see your VLF distribution. It returns one row per VLF.
    • Often you get too many VLFs from autogrow/small growths.

     VLF Lessons Learned:

    • Avoid autogrow by pre-sizing your data and log files appropriately. This includes alerting when your free space starts to decrease significantly and planning for data growth over the lifecycle of the system. Make sure you check your system as well as your user databases.
    • Set autogrow values to reasonably large amounts to avoid a series of small autogrows in an unexpectedly high volume period, but not so big the growths themselves slow down the system.
    • Alert on autogrows and check (and possibly correct) VLFs afterwards.
    • Check your VLFs periodically and during performance troubleshooting and consider shrinking/regrowing properly (with the proper presizing) to reduce the total number of VLFs when the number gets “too high”.
    • Never grow (manually or via autogrow settings) in increments of exactly 4GB. Values such as 4000MB or 8000MB are good, but there is a bug with multiples of exactly 4GB.
    • Do NOT shrink your data or log files on a regular basis. Shrinking should be extremely rare and in response to a specific issue.
    • And because it can’t be said too often, pre-size your databases to avoid autogrow.
    • Revisit the sizes periodically.

     Thanks everyone for coming to the talk and for the great feedback afterwards! You did fill out your evaluation forms, right? 🙂

    Pictures:

    http://yfrog.com/z/h88chpvj

    http://flic.kr/p/awbV6h

    VLFDemo.zip

  • SQL PASS: All the Magic Knobs

    SQL PASS 2011 DBA-319-C #SQLPASS

    All the Magic Knobs – Low Effort, High Return Tuning

    Key points covered:

    • Power Savings = High Performance
    • Smart Virtualization
    • Enough Hardware
    • Control other apps, filter drivers
    • Optimize for ad hoc workloads = ON
    • Compression = ON
    • Set LPIM + Max Server Memory
    • Pre-size files, avoid shrink and autogrow
    • Fast Tempdb
    • Proper Maintenance

    My presentation from 10/13/11 is attached.

    AllTheMagicKnobs.pptx

  • Data Gathering – SQL Server Setup Problems

    Data Gathering – SQL Server Setup Problems

    Cindy Gross, Dedicated Support Engineer

     

    Gathering the right data during a problem can get you a long ways towards resolving the problem. When you ask the right questions and clearly define the problem it changes the way you approach the remaining steps. Sometimes the answer to a seemingly simple question leads you right to the solution. In this series of data gathering blogs I am NOT going to tell you how to solve the problem, but I am going to tell you how to get a good set of troubleshooting data you can use to do your own troubleshooting.

    Any time you have a SQL Server setup issue you will need to collect this information:

     

    • Date/time of the failed setup
    • Type of install and parameters used – GUI, unattended/command line, slipstream, sysprep
    • Number of attempts, any actions you took to cleanup or remove prior installs
    • Version/Edition/Exact build #/32bit or x64 or IA64 for
      • Windows
      • SQL Server
      • Virtualization software (Hyper-V, VMWare for example)
    • How many cluster nodes and SQL instances or state that it’s standalone
    • Whether the problem is with RTM, SP, and/or CU
    • Whether the problem is with a new install or an upgrade
    • What components you are installing (Client tools, SSIS, SQL, RS, AS, BOL, samples) and whether any succeed
    • Exact error message
    • Repro steps and/or failure scenario
    • All setup logs (i.e. %ProgramFiles%Microsoft SQL Serverx0Setup BootstrapLOG)
    • Which step in the build doc you are at when you see the setup failure
    • What permissions have been enabled/granted for MSDTC
    • Any steps you take to attempt to resolve the problem and the result
    • If on a cluster, have you re-run the cluster verification log and addressed all errors and warnings?
    • Did you run setup using “run as administrator”?
    • What account did you log into Windows with when you ran setup and what groups does it belong to?

    Armed with this information you are now ready to solve the problem!