Want to know about Monitoring SQL with SCOM and Operational Insights?
Then you have to check in with this webinar hosted by the WMUG NL user group and presented by a fellow MVP and friend Simon Skinner. Save your calendars for 28 January 2015 at 20:00…
Just now Microsoft announced the wave of main events of next year. The expected event which brings together several tech events like TechEd and Management Summit and Exchange/Lync/Sharepoint/Project conferences into one big event. Well here it is and it…
This is a post in continuation of my previous post on the topic of upgrading a SCOM 2012 SP1 to a SCOM 2012 R2, which went wrong and how I was fixing it. After fixing the SCOM instance everything seemed alright for half a day. The very next morning we h…
I often get questions for getting SQL info together, such as names, instances, versions, editions and so on for all kinds of purposes. Sometimes as inventory, sometimes to find instances no longer supported, rogue instances, needed for licensing info an…
Purpose
This management pack brings together I/O statistics for SQL data files and log files directly from the SQL virtual file stats view into SCOM where you can report on these for any period of time. It can collect data from SQL 2005, 2008 and 201…
Yesterday a new version of the SQL management pack for SCOM was released. Yes we are now on a roll with releasing new stuff! The fresh version of the SQL mp is now 6.3.173.0.
The new version supports also monitoring of SQL 2012 now and will work for SC…
Today ran into a SCOM Report Server that would not load correctly on a Windows 2003 with SQL 2005 version.
This also gives an error in SCOM console as follows:
Data Warehouse failed to request a list of management packs from SQL RS server..
And in t…
This is an old one as well, but we still see it happening (including in my case). Actually these are two cases.
First had an 404 error when I opened the SCOM Web Console for the first time. Well this links back directly to my previous post where the…
Had a small issue with SQL 2005 Reporting Services on Windows 2003 R2 in a quick quick test environment I was setting up for SCOM. When trying to open http://servername/reports I got an error “HTTP Error 404 – File or Directory not found”. I knew I had…
One nice gem from Steve Rachui’s blog is a trick on how to simply troubleshoot remote SQL connections.
Just create an empty txt file anywhere on the disk and give it an UDL extension and click it. You will see a tool popping up with several tabs. on t…