• Passed my MOFv4 (Microsoft Operations Framework) exam

    Today I took my MOFv4 exam and passed with a score of 90%. I made 4 mistakes from the 40 questions. Not bad I believe ;-)

    If I’ve some time in the future I want to blog some stuff on how to use MOF with OpsMgr 2007. But I don’t think that’s soon because I’m quite busy at the moment.

    Looking for more info? Go to http://www.microsoft.com/mof

  • Using SQL Nexus to troubleshoot OpsMgr SQL Server performance issues

    SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

    With the RML Utilities you can answer questions such as the following:

    • Which application, database or login is consuming the most resources, and which queries are responsible for that.
    • Whether there were any plan changes for a batch during the time when the trace was captured and how each of those plans performed.
    • What queries are running slower in today's data as compared to a previous set of data.

    If you think you have OpsMgr SQL Server performance issues maybe SQL Nexus together with SQLDiag and RML Utilities can help with performance tuning and analysis.

    Steps:

    1. Download SQLNexus , RML Utilities for SQL Server, Microsoft Report Viewer 2008 Redistributable and PerfStatsScript from websites.
    2. Install Microsoft Report Viewer 2008 Redistributable
      image
    3. Install RML Utilities for SQL Server.
      image
    4. Install\Run SQLNexus by running sqlnexus.exe in folder where you extracted the zipfile.
    5. Connect to SQL server
      image
    6. After starting SQLNexus a new database sqlnexus is created.
      image
    7. Create a folder SQLDiag and Unzip PerfStatsScript files to folder.
    8. Open StartSQLDiagTrace.cmd and change configuration as needed.
      image
    9. Give SQL server service account full control on D:\SQLDIAG folder if you aren’t using the local system account.
    10. Start D:\SQLDiag\StartSQLDiagTrace.cmd. This script registers sqldiag as a service and starts the service with a template (both profiler and perfmon trace)
      Output is being dumped in D:\SQLDiag\SQLDiagOutput folder
      image
      image

      Remark:
      On a busy system quite some data can be collected!!!!. Watch your freespace carefully! Customer experience on opsmgr environment with 2500 agents 20GB of data is collected in 10 minutes.
      Have it running for 10 mins and then stop the SQLDiag service.
    11. Stop SQLDiag with StopSQLDiagTrace.cmd script.

      image
    12. Importing trace data by selecting File\Import in SQLNexus tool.
      image

      Select Options and select BLG Blaster on Enabled and Drop Current DB before Importing.

       image

      image

      Remark: If you are getting the Message PerfStatsAnalysis.sql doesn’t exist message. Just copy the PerfStatsAnalyis.sql file to the requested folder.

      image

      image
    13. The Next Reports are available:
      • Via SQLNexus
        1. Bottleneck Analysis
        2. Blocking and Resource Wait Statistics
        3. Performance Overview with subreports
          • Resource Consumption
          • Unique Batch TopN
          • Interesting Events

    image


     image

        I want to thank David Scheltens for showing me how to use SQL Nexus and creating the PerfStatsScripts.

        References:

        SQLNexus

        http://www.codeplex.com/sqlnexus

        SQLDiag (installed default with SQL2005 and SQL2008)

        http://msdn.microsoft.com/en-us/library/ms162833(SQL.90).aspx

        PSSDiag (to use with SQL2000)

        http://msdn.microsoft.com/en-us/library/aa175399(SQL.80).aspx

        RML Utilities

        http://blogs.msdn.com/psssql/archive/2007/12/18/rml-utilities-for-microsoft-sql-server-released.aspx

      1. New Twitter Background

        Yesterday I got my new Twitter Background created by Dan Kregor. I follow Dan and when I visited his Twitter page I loved his background.

        So I asked him how he created his beautiful background and before I new he suggested to create one for me! How awesome is this?

        image 

        Dan thanks for creating this beautiful Twitter background for me! I’m loving it!

      2. A Windows-enabled and Web-connected coffee maker

        Source: gvenkdaily

        Among the technologies Microsoft is highlighting in its booth at CES this year is a hardware and software platform for the next generation of more useful and flexible household objects, appliances and accessories. The Windows-based platform is the result of a collaboration between Microsoft and a recently formed company called Fugoo. Two of the concept designs featured in a video at the booth are a “net” clock that, in addition to giving the time, can also download and display a stock ticker and local traffic and weather reports, and a digital photo frame that can not only download your latest holiday photos, but can also be programmed to display anything else available on the Internet, from current news headlines and sports scores to full-length movies.

        How cool is this? Read more on Microsoft PressPass and the Fugoo website.

      3. New OpsMgr Tool: GreenMachine (bulk reset health monitors)

        Source: TimHe's Blog of SMS SCCM SCOM MOM and SCE

        Tim Helton created a new OpsMgr utility that can be used to reset or recalculate all monitors for a single agent, or for all agents in your management group.

        Command line tool that facilitates bulk reset of health monitors.

        This can be very useful if you just had an event storm, and you want to reset everything back to "green". It also has the ability to identify "ManualReset" monitors, and reset or recalculate only them.

        It displays most of the same data as healthexplorer, as well as some additional information.

        Read more here.

      4. Reblog: OpsMgr Subscription enable\disable tool

        Source: Everything System Center Operations Manager 2007

        Subscription Tool is a simple GUI based tool that lets you enable and disable all notification subscriptions. This tool is useful if you need to do some major maintenance such as patches, upgrading hardware, redoing AD integration roles, or fixing a major problem.

        The real power of the tool is when you want to re-enable the subscriptions.  The tool will automatically re-enable all subscriptions using “Send notifications for alerts Generated after the subscription is enabled”. This will save you from sending out huge alert storms your notification subscriptions.

         

        Read more on source.

      5. Reblog: Hyper-V Monitor Gadget for Windows Sidebar

        Source: Mindre.net

        Tore Lervik has create a very cool Hyper-V Monitor Gadget for Windows Sidebar.

        The gadget can list multiple servers at once and also support vmconnect when double clicking on a VM.
        PS: The gadget uses WMI to connect to the server so the user need remote WMI access (Step 5) on the Hyper-V server

        I’ve installed it and it’s really cool!

        image

        One feature request though ;-) Resizable Gadget so I can read the whole names of the guests.

      6. The Microsoft MVP Award Program Blog

        Did you know there is a Microsoft MVP Award Program Blog? I didn’t knew that when I used to be a MVP for MOM before starting at Microsoft a little more than a year ago.

        Being awarded as MVP was one of the best things that happened in my professional career. I got access to information which before was impossible to get to. I still have contact with many MVP’s and they sometimes have more info than I have!

        Through our MVP Award Program blog we now share some of the amazing and inspiring activities of Microsoft’s Most Valuable Professionals across the world, helping technical community watchers like you to find information and insight to share with your audiences. The blog is in English but they do feature non-English content. They will add a new story every working day.

        You might also like their Twitter site and Official Facebook Fan Page

      7. Using Script Debugger for debugging OpsMgr Scripts

        When I was watching the recording from the January 2009 SCVUG Meeting, Pete Zerger showed that you could use a script debugger when debugging scripts.

        Till now I had not used a script debugger so I thought why not enable the just-in-time script debugger from Visual C# 2008 Express Edition I’ve running on my laptop?

        But it turned out that Just-In-Time Debugging is not available in the Express Edition.

        Don’t worry you can download and install the Script Debugger for Windows NT 4.0 and Later and use that when you want to debug your OpsMgr scripts.

        How do you debug your scripts? Just open the command prompt and type:

        c:\cscript.exe /x loveopsmgr.vbs

      8. Update Toolbox: Log Smith for Operations Manager

        Source: System Center Forum

        Stefan Koell has released v1 of LogSmith for Operations Manager. LogSmith connects to your RMS and allows you to filter and sort events in the Operations Manager Event Log with ease - very nice for slicing and dicing the log quickly in large environments. I’ve updated my OpsMgr toolbox page with this latest tool.

        Read more on source.

        Haven’t tested it yet but it looks great!

        Update: Tested it and it's really great for OpsMgr Event log analyzing.

        Screenshot Log Smith for OpsMgr

      9. New version of Hyper-V Monitor Gadget for Windows Sidebar

        Source: Mindre.net

        Tore has listened to my request :-) Thanks Tore!

         

        image

         

        image

        Go and download this great Sidebar Gadget!

      10. Audio / Video from the January 2009 SCVUG Meeting

        Source: System Center Forum

        Today I was watching the latest recording of the January 2009 SCUG Meeting and to my surprise I was seeing some info about Debugging Scripts which I blogged about some time ago. 

         

        image

        So if you didn’t had time to join the livemeeting go download the recording.

        Below are the starting times in the video for each speaker so you can fast forward to whatever you like.

        • 1:05 - Savision Live Maps v3 Demo (Dennis Rietvink)
        • 51:46 - Custom Scripting and Script Debugging in OpsMgr 2007 (Pete Zerger)
        • 1:19:45 - Top MS Support Issues for Operations Manager 2007 (Steve Rachui) 
      11. Welcome to a new OpsMgr MVP

        Source: Twitter

        Jeremy Pavleck has been awarded as OpsMgr MVP!

        Congrats to him!