in

myITforum.com

This Blog

Syndication

SCUG at myITforum.com

June 2010 - Posts

  • Presentation: How To Manage your Sharepoint Environment With System Center

    Hey all, yesterday I had the pleasure of giving a presentation on the Belgium Community Day (www.communityday.be).  This event, organized by some members of the Belgian Community is getting more popular every year.  It was the fourth edition and received a speaking slot for the first time here.

    It is amazing that just a few people of the community succeed in organizing such an event (almost 500 people registered) and find the necessary sponsors, funding and helping hands to do this event, which was still free for everybody, as it is always been.

    The big man behind the event is Gill Cleeren (www.snowball.be) and his team did a fantastic job at Utopolis in Mechelen, Belgium

    So, for my session.  The title was How to Manage your Sharepoint Environment With System Center and for the first time in my life I had to present in a cinema room.

    I presume this should have made me nervous but instead I actually was quite excited

    Here’s a picture from before the session when the audience wasn’t arrived yet.  Still hope that there are pictures when I am actually doing the presentation so if anybody has one… let me know :-)

    IMG_0135

    Although the majority of the attending people were developers, there was quite some people in the room considering that I am giving an IT pro session.  So I was quite happy to start.

    In the end, I was quite happy with my presentation except for one moment were my wireless connection to my demo environment dropped.  Small ackward moment but for the rest everything went ok.

    Unfortunately I only got one hour and in that presentation I had to discuss how to manage your environment (SCOM) and protect it (SCDPM).

    Here are the highlights:

    image

    One of the first items I addressed was the growing pains of SharePoint.  Because of the nature of SharePoint, it can be a pain in the **** for IT Pro administrators.

    Through the years, SharePoint became more and more popular, which gave additional challenges to administrators.

    • Mission Critical information is kept on SharePoint
    • More utilization meant that the performance become worse, and because of the above situation, users started to complain because their data was on there
    • Companies (read Management) started to ask about redundancy plans for this application
    • The capabilities of SharePoint gave the possibility that different regions, different business units had different functions, but this also created headaches for admins
    • Everybody knows by know that custom development is the key to success, but how are we going to keep track of this?  Because of the great platform, developers loved it, creating additional applications and workflows.
    • SharePoint became quite quickly the new datacenter application, so it needed to be managed as an datacenter application
    • Another issue is the fact that SharePoint is everywhere.  It is distributed by nature.  Additional project sites, sites, document libraries and so on are created with ease.
    • This also created additional load and admins needed to provide quickly additional resources which wasn’t always that easy.
    • Luckily there was virtualization, but that also give another problem, the so-called server sprawl

    image

    My next slide was about what benefits can give you when you use it to manage SharePoint

    • With SCOM you can easily do proactive monitoring and reporting.  It even integrates with SharePoint’s native monitoring capabilities.
    • With SCVMM you can manage the capacity and provide additional SharePoint resources as needed (and then I didn’t talk about Opalis who can automate this workflow based on SCOM’s performance data.)
    • SCDPM can help you with rapid and reliable data backup and recovery
    • SCOM will also validate your SharePoint environment through the use of prepackaged validated best practices.  Hey, and if your environment has a good reason for not being setup according to the best practices, then you adapt the monitors to your own best practices
    • Everybody who ever managed a SharePoint environment knows that patching it is a terrible work.  By using SCCM you can automate parts of the entire process.
    • With the new ServiceManager, you can describe your entire farm as a business service (most of it is automated if you are also using SCOM) and get the entire incident and change management process to the application, according to your ITIL or MOF workflows
    • Through SCOM you can manage not only SharePoint, but also the OS, the hardware and even the network if you want, giving you an overview of the health of the entire datacenter for this application.
    • And last but not least, a consistent user interface through the complete suite makes it easy for your IT admins to administer them all.

    This was more a general slide, and then I started to talk about one of the two actual topics.  First one: The SCOM Management Pack for Sharepoint.

    image

    The first slide on this topic discussed the improvements over the previous management pack.

    • The architecture had changed so now it looked on a server level but also on logical components
    • The new SPHA (SharePoint Health Analyzer) rules that are embedded in SharePoint are integrated in the new Management Pack
    • There are only two management packs left, the SharePoint foundation and SharePoint Server management pack

    Also the differences in rules, monitors etc were shown

    image

    And then it was time to just demo the Management Pack.  It is pretty difficult to explain this Management Pack, you just have to see it for yourself to see the value.  This was also the moment I lost my wireless and freezed my remote desktop.  Luckily it returned shortly afterwards so I could continue the demonstration.

    Finally, to close this topic, I explained the pitfalls when installing this Management Pack

    image

    • Make sure you have all the hotfixes necessary.  They are all described in the manuals that come with the management packs.  Another great example of Read The Fine Manual.
    • Make sure that you also install the additional management packs such as the SQL management pack, the IIS management pack and ofcourse the OS management pack.  And if you have a management pack for your hardware and/or network, use them too.
    • When you install the Management Pack on an x64 system, there is a little problem that it installs them in the “%Program Files (x86)\System Center Management Packs” directory while it needs to be in the “%Program Files\System Center Management Packs” directory.  Copy the files to there
    • Don’t forget to create the Run As Account, this account needs to be Farm Administrator and have the correct rights on the SQL databases.
    • Resize your event logs (the windows application log and sharepoint foundation\operational log) to at least 10 MB.
    • Disable event log replication when your environment is running on windows clusters.  Otherwise you will get alerts two times.
    • And last but not least, but this is a best practice for every SCOM administrator, use an override management pack for your overrides.  This is created by default when you run the config task.

    Second part was protecting SharePoint.  And here I wanted to discuss DPM of course, but I also discussed the built-in tools from SharePoint.  The reason for that is quite simple.  Yes you need a backup, yes you need to be able to recover but when a user deletes one document and calls the helpdesk, you don’t want to start recovering that one document because you will have a lot of work.  Yes DPM can do that but you will use this when the user wants the document back but realized it way too late.

    Anyway, here are the important takeaways when you are planning a SharePoint project and are thinking about Business Continuity and Disaster Recovery (which you should always do in the planning phase but hey, it doesn’t always go as it should right…)

    • Understand what you need to protect.  Get an overview of the install base (use SCOM for this), understand for what it will be used. 
    • Get clear goals with your management.  I can’t afford to loose a document and it must be online all the time is only achievable if they want to spent a lot of money.  If they don’t want that, then ask how much they want to loose, and how long it can take to bring everything up again.  Based on that, decide what you need, get pricing and talk again to your management.
    • Read about SharePoint, know what is already included with the product.  Use it in your advantage.
    • Make sure that when the product is online, that Business Continuity management in an ongoing process.

    Another slide is showed is what is already inside the box.

    image

    Oke, the first point was merely explain what the difference is between Warm high availability and Cold availability.

    But the other points are extremely useful.

    • Recycle bin.  Use it, train your users, and set it on a few days so that you have less work when a user deletes a document by accident.
    • Use versioning, force it.  This way, users can’t take an old version and overwrite the newer one.  They can return whenever they want.
    • There is the Read-Only Database option.  This is nice.  Take a content database with important information that doesn’t need to be changed again, make it read-only in SQL and SharePoint see this and handless to it.
    • If you have custom development, let your developers package all solutions.  If it is a real disaster, then you can reinstall that package easily.
    • And finally, there is the possibility of an Unattached Content Database.  You can take a snapshot in SQL or recover one through DPM and read it through SharePoint without the need of being attached to SharePoint.

    After that, some slides on how DPM works, but since I already addressed this topic I’m not going to repeat myself.

    After a demo of a document recovery, I finalized the session with the takeaways which are all described here.

    After the session, I still got a lot of people coming up and ask me a lot of questions on DPM.  Glad to hear that it finally is getting the buzz it needs in Belgium :-)

    One last thing that I forgot to mention yesterday (shame on me) but I will mention it here:

    All the things that I showed yesterday and described here can also be achieved with System Center Essentials 2010.  Certainly now that Microsoft has released System Center Essentials Plus which gives you licensing for SCE and DPM.

    Till next

    Cheers,

    Mike Resseler

    PS: For those who are interested, my presentation can be found at this address: http://www.communityday.be/cd/tabid/130/Default.aspx

    Session 1, room 9

  • Upgrading SCE 2007 to SCE 2010 … the long story part 4

    Hey All, After a rather long upgrade, a disaster OS upgrade, an easy prerequisites flow and an almost flawless SCE upgrade in the end, I’m happy to say that everything is running again.  Next stop will be the upgrade of all the agents, but if I have issues there, I will post them separately. Before I end this post series, I would like to give my conclusion: 1. Make sure you are prepared.  Upgrading an Windows Server 2003 R2 64-bit physical server to Windows Server 2008 R2 64-bit wasn’t...(read more)
  • Upgrading SCE 2007 to SCE 2010 … the long story part 3

    Hey All, Part 3, the actual upgrade.  After a lot of issues with the OS upgrade and the easy part for the prerequisites and “pre-jobs” it is time for the real upgrade. Before I describe the attempt that actually worked, I should mention that I had also an issue.  During the installation wizard, I got this error: Unable to use HTTP site from the http://servername:80/Reportserver_instancename Internet Information Services (IIS) node. Please select HTTPS binding This was easily fixed, I had...(read more)
  • Upgrading SCE 2007 to SCE 2010 … the long story part 2

    Hey All, after part 1, here is part 2. So in the last part, I finally got a working SCE 2007 on Windows Server 2008 R2.  I know this has nothing to do with System Center Essentials, but it learned me something very valuable.  First upgrade SCE 2007 to SCE 2010, and then do the upgrade to windows server 2008 R2 :-).  But anyway, I got through and now I looked at all the things I needed to do before starting the upgrade from SCE 2007 to SCE 2010 So here is the flow I’ve used (this includes...(read more)
  • Upgrading SCE 2007 to SCE 2010 … the long story part 1

    Hey All, The last weeks I had to work on an upgrade from SCE 2007 to SCE 2010.  I had a lot of issues with it so I wanted to give them here so that you can avoid them if you need to do that The situation SCE 2007 is installed on a windows server 2003 R2 x64 physical box.  Because we wanted to use also the VMM part of SCE, we needed to upgrade the server. So here was the plan I’ve built: Do a complete assessment (including MAP) of the server and all the software components.  This was...(read more)
  • Cool new post: DPM licensing explained

    Hey All,

    Great post from Jason Buffington: DPM Licensing explained, make sure to check it out!

    http://blogs.technet.com/b/jbuff/archive/2010/06/23/dpm-2010-licensing-info.aspx

    Cheers,

    Mike

  • Community Day 2010 : Getting Ready

    Thursday 24/06 I am co-presenting a session with my SCUG buddy Kurt Van Hoecke about “Service Manager Integration with System Center” at the Community day 2010. After a hectic week , I we are building heavy on the demo and our slide deck. The session will be from 17.00 – 18.00 @ Utopolis Mechelen Finally everything is falling into place , so relax , sit back and enjoy the show for thursday!   See you there  , Kenny...(read more)
  • New DPM 2010 datasheets released

  • ConfigMgr 2007 R2 & R3 : How to back up SCCM 2007 SQL Reporting Services

    A recent implementation at my ConfigMgr 2007 R3 TAP customer of R3 and SQL reporting services  put me thinking ahead for our disaster recovery procedure . SRS Reporting role needs to be installed in the DEFAULT Instance ! Named instances are not supported !! The standard ConfigMgr 2007 backup task does not back up the SSRS reports or the SRS configuration.You need to take this into consideration if you : you have created any custom reports you have created any custom report models Set some custom...(read more)
  • System Center Service Manager 2010 International RTM!

    Microsoft has announced that SCSM 2010 International RTM is available! This release contains the localized version of SCSM 2010 and supports the following languages:

    • Chinese (simplified)
    • Chinese (traditional)
    • English
    • French
    • German
    • Italian
    • Japanese
    • Korean
    • Portuguese (Brazilian)
    • Russian
    • Spanish

    180-days evaluation version download link to Microsoft download site.

    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=3bacb364-9829-41d0-8faa-b0ed366f73aa

    Important note:

    A single installation of the international version of SCSM supports all the languages listed above.  SCSM Console uses the OS Display Language setting and SCSM Portal uses the Browser’s Encoding setting to render the contents in the appropriate language.

    Important information about this release:

    Frequently Asked Questions about the SCSM 2010 International.

    Some highlights:

    • It is not possible to upgrade from English to the International version of SCSM.
    • Starting from SCSM 2010 Service Pack 1, Microsoft is going to ship English and International versions of SCSM as one version of the product (sim-shipping)
    • The language of the server OS (SKU & OS Display Language) doesn’t impact the language of the client (console/browser) UI on the separate client computer.
    • Windows Client can be in any language (SKU & Display Language) supported by Windows Client OS
    • Language SKUs should be the same for all SQL Servers used for SCSM SM Servers and Data Warehouse
    • All SCSM SQL Servers (SMDB and DW) must have the same collation setting from the list of supported SQL Collations.
    • Read more from Microsoft Team blog - URl above

     

    Have Fun,

    Kurt

  • ConfigMgr 2007 SP2 State Message : MP has discarded a report when processing Ddr.

    Today , I was at a customer and I was struggling with a specific status message ID 5413 in the status messages. I just installed a brand new Configmgr site with sitecode ABC … What is happening ? What I didn’t know is that they already installed a primary site in production with sitecode XYZ before me , played with it and deleted it without further notice . The specific message ID 5413 : ************************************************************************** MP has discarded a report when processing...(read more)
  • VDI Day Sessions online

    Last week we organized a Virtual Desktop Infrastructure day together with Citrix. We’ve published the sessions onto TechNet Edge . Session 1: VDI Day: Citrix & Microsoft Desktop Virtualization Strategy In this session we will guide you through the desktop virtualization strategy and show you how Citrix and Microsoft will help you reduce the costs of Managing your virtual desktop infrastructure. We will answer questions like: “Will desktop virtualization really fit every user?”...(read more)
  • Reporting in System Center Service Manager 2010 (part 1)

    In the following blog posts I want to provide an overview of the reporting functionality in Service Manager. Extracting data out of the service management tool for analysis or performance measuring is an important functionality. System Center Service Manager includes strong reporting capabilities witch are based on SQL reporting services (and also takes advantage of it).

    SCSM reporting is integrated into the management console in the same way as can be seen in Operations Manager 2007. Leveraging the capabilities of SQL Reporting Services, analysts are able to create favorite reports, schedule reports, and automatically generate reports that are sent by mail, uploaded to a Share Point site, or stored on a file share.

    In this post I want to provide an overview of the building blocks of the reporting functionality in Service Manager. Subsequent post on this topic will cover:

    • Reporting functionality in the Service Manager console. Access reports, set permissions, export data, link reports…
    • SCSM reporting - Configure subscription and schedule reports through SQL SRSS.
    • SCSM reporting - Creation and deployment of a custom reports using SQL Server Report Builder.
    • SCSM reporting – SCSM report integration into SharePoint.

     

    Basic SCSM reporting functionality overview

    Service Manager Server is the component that is accessed for importing management packs, import CI’s via connectors or CSV or perform actions via management console by analysts. All these actions and information is stored in the Data Warehouse  database for reporting access or long term retention. The Data Warehouse DB (DWDataMart) and SQL reporting services are the additional SCSM components who enable the access to this data.

    Data Warehouse

    • The Service Manager DataWarehouse is a collection of databases and scheduled processes which automatically ingest and optimize data for reporting & analysis from one or more Service Manager management groups.
    • It is designed to be self managing and highly extensible, automatically altering it’s schema and code based on the management packs which have been imported into the Service Manager management groups to which it is registered.
    • By default, the data warehouse refreshes it’s data for reporting purposes hourly and retains data for 3 years. Out of the box there are 5 automated processes, called jobs, which manage the data warehouse:
      • Management Pack Synchronization (“MPSync”)
        • The MPSync job is responsible for building out the data warehouse structure.
        • It looks for new and/or updated management packs from all of the registered Service Manager management groups, and based on what it finds it deploys new tables and/or code as needed to account for changes in classes, relationships and/or warehouse elements
      • Extract, Transform & Load (ETL): The ETL process refreshes the data in the warehouse. This is logically a sequential flow of data:
        • The Extract jobs acquire data from registered SM servers. There is one Extract job per management group.
        • The Transform job optimizes the data for reporting needs and shapes the data according to the defined business rules.
        • The Load job populates the data mart for long term retention and access.
      • DWMaintenance:
        • The maintenance job takes care of grooming out archived data as well as handling database optimization tasks like partitioning and index management.

    Reporting

    • Reporting in Service Manager is based on Microsoft SQL Server 2008 Reporting Services.
    • The Service Manager console connects to the Reporting Services server specified during installation and displays the folder structure and list of reports stored under the /SystemCenter/ServiceManager folder.
    • The Service Manager console can render any valid Reporting Services report, even if it connects to other databases. This enables consolidating all of your IT organizations’ reporting needs in one place for easy access.
    • The SCSM console is fully integrated with Reporting services security, such that users accessing the console will only see folders and/or reports to which they have access.
    • Analysts and developers can utilize the business intelligence products they are already familiar with such as Report Builder and SQL Server Business Intelligence Development Studio to easily create new reports or customize existing reports.

     

    Bringing it all together

     

    dw

     

    In next reporting post I will cover the reporting functionality that is provided in the Service Manage console.

    Have fun,

    Kurt

  • SCCM R3 : Power Management In Practice (how-to) Part 1

    Hi there , I have recently deployed Configuration Manager 2007 R3 beta (refresh) in production at my TAP customer.In my previous blog post I highlight the R3 the beta installation on your SCCM 2007 SP2 lab environment . See “ http://scug.be/blogs/sccm/archive/2010/05/14/sccm-2007-r3-beta-refresh-installation-howto.aspx ” Disclaimer: You are not allowed to install any beta products in your production environment!!! This is only allowed for selected TAP Customers !!! Always install beta products in...(read more)
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems