Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

April, 2012

  • Business Intelligence for the Private Cloud part 1

    If you have looked at any of the new components of System Center 2012 you may have noticed that everyone seems to have a bunch of reports, some of them have data marts or data warehouses and some of them have analytics in the form of analysis services cubes.  Apart from the confusion over when to use what, why has so much effort been put into this?

    In order to answer that let’s consider what information we need from System Center. I use the term information here deliberately as you may be aware that System Center chucks out tons of data, e.g. virtual machine X is running SQL Server, this update failed, that server has restarted, etc.etc. A good example of this how a badly setup Operations Manager will swamp the IT team with all the messages it throws out.

    Rather than all this noise what we need is answers such as:

    • What tasks are assigned to me?
    • Is everything that needs to be running actually working OK?
    • How can I predict demand and so be more proactive?

    This isn’t an exhaustive list rather these questions characterise the way you might interact with the information coming out of System Center, and help frame an understanding of how business intelligence fits into the picture.

    What task are assigned to me ?

    This is operational reporting also referred to as consumption reporting because in the process of acting on the report the data in it becomes obsolete.  In this case If I action a task assigned to me from a report. it’s then closed and won’t appear on the report if I run it again.  This is the simplest type of report  and is usually directly sourced form the operational database (hence the other name).  In System Center 2012 these reports are usually built in to things like management packs in Operations Manager and Service Manager.

    Is everything that needs to be running actually working OK?

    This often expressed as a dashboard and is often found running on a large screen in a large helpdesk or operations room. In order to answer this type of question you might need data from more than one source and a deeper understanding of the source data is needed, for example to understand what systems need to be monitored and what the components of those systems are. In the BI world we might use a dashboard for this kind of analysis which might be interactive rather than static, enabling the end user to drill into a problem area to see more detail. Dashboards typically get their data from a data warehouse which is nothing more than a specialised database where the design (schema) is optimised for reporting rather than input. System Center does include some dashboarding capability but this a set of components and tools rather than a finished solution as dashboards are very individual to an organisation so there’s no right answer than can be implemented in a product. For example your System Center dashboard would probably compare actual performance against service levels, across time across business units. However the SLAs in your business will vary considerably e.g. “server uptime bust be greater than 99.999% between 8am- 6pm on working days”  or “client login time on our corporate internet site must be less than 500ms “ so you’ll have to do some work to get those to show up.

    How can I be more proactive?

    In order to answer this kind of question a data warehouse is also needed because the answer might depend on what’s happened before where operational systems e.g. Operations Manager are routinely purged of older data to maintain performance.  However writing endless reports and running them to get an answer as vague as this would take too long what is need is an interactive way to navigate through the data to understand the trends and discover patterns that might not immediately be apparent. This is the realm of OLAP and data mining both of which are built into SQL Server standard edition, (which you get with System Center 2012), and there’s an option to use this as part of Virtual Machine Manager 2012 for this kind of reason. 

    Hopefully that’s got you thinking, but if not let me leave you with a though and a question

    • The question: With so much reporting and analysis in Systems Center how can I make sense of it?
    • The thought: I spent ten years in business intelligence and saw numerous attempts by software vendors to deliver vanilla BI on the back of their erp systems which were of only limited value.
  • Drinking the Champagne – SQL Server 2012 on Windows Server 8

    Dogfood is the commonly described term for running your own beta software, however I prefer the term drinking your own champagne and to that end I have spent  a days leave today playing Window Server 8.   Yes its very different to what you have seen before and rather like having the decorators in while you are away it can  be difficult to find your old stuff when you return. However the new UI is a lot cleaner and once you know what your doing you will be more productive than you are now. 

    Anyway a server OS is not much use without services running on it so I thought I would see if SQL Server 2012 would be at home here now that it’s been released.  The first thing I do when installing SQL Server is to declare the server as an application server by adding that role, which adds in the .Net framework.  SQL Server 2012 needs the >Net Framework 3.5 sp1 and to get that onto Windows Server 8 you’ll need it connected to the internet when you add the feature in, as it’s not included in the install media (as I found out at #SQLBits).  So having got that installed..

    ijnstalled features

    I can then crack on with the install.  notice that the SQL installer does tell you about this in the install screen bottom right below..

    feature selection showing net 35

    I imagine the SQL installer will do this for you but you’ll need that internet connection for it to work.

    Anyway after a clean install I know get a load of icons on my metro desktop..

    tidy up

    Right clicking on any of these means you can remove them and of course drag them round as you need to.  You might wonder what that interface is doing on a server OS.  My answer would be that many of us manage servers via remote desktop and if your client device has touch then this interface will work well with that.

    I also included Reporting Services in my install to see if that would work and it does..

    report managerl

    Although I had to turn on IE compatibility mode as it didn’t render quite as it should.

    Of course this is all just evaluation as we are a long way from releasing Windows Server 8 and I would imagine that there will be a service pack of SQL Server 2012 that will fix any issues when Server 8 does come out.

    I will be doing SQL Relay for Tony Rogerson in May (Edinburgh, Manchester, Birmingham & Bristol) and I’ll have this running if you want to know more.

  • Cloud Cookery class

    Cooks would rather not wash up, and the best chefs have someone else do the shopping prepare the vegetables etc. and often end up planning and managing the menus and kitchens. In our IT professional world I would rather not worry about patching, I hate doing all the repetitive boring stuff and would rather work on projects.  Essentially that’s the promise of the cloud, so I am continually surprised that so many of you don’t get it, possibly you don’t think this stuff applies to you.

    I have been trying to explain this at the various IT Camps we have been running up and down the country, but I also got a cameo role on cloud at SQL Bits with my good friend Buck Woody.  We were filmed so that should be out on the SQL Bits portal in the next month, but we also shot a 2 minute intro while he was making pizza at my house..

    Which I hope you enjoy as much as we enjoyed his proper American pizza!