Tag Archives: SQL Server

Why Service-Oriented Monitoring is here to stay

Many of you are most likely running some kind of monitoring tool in your environment today to make sure that your servers are up and running as they should. Traditionally, monitoring has been focused at checking the state of single components, such as the server itself (does it respond to ping?), memory and CPU etc. […]

SQL Server MP – No More SQL2005

Microsoft just released a new CTP version of the SQL Server Management Pack 6.3.7, that includes new bug fixes and some new features specific to SQL Server 2016. Let’s download updated MP package and review what’s new together! The most important update that matters for all enterprise customers is removing monitoring for SQL Server 2005 from […]

Creating SCOM dashboards showing info from SQL Server or Oracle DB

Previously, SCOM Expert Daniel Örneling wrote about how to use the built-in features of the brand new Live Maps Portal and how it could help you deliver fancy SCOM dashboards to the business. He explained that you don’t need anything else other than having SCOM with Live Maps up and running. If you haven’t read that post […]

SCOM + SolarWinds + Nagios + Azure = Complete Monitoring

Since the inception of Savision in 2006, we have been a proud Microsoft Gold ISV partner in the System Center Operations Manager (SCOM) space. We have seen SCOM become one of the leading component and application monitoring platforms in the market, plus the range of Management Packs available from Microsoft and other ISV partners, has […]

SCOM Service Monitoring

Monitoring your IT Services with SCOM can be quite tricky to realize, but becomes more and more important. Do you want to know how to get your Services monitored, fast and efficient? SCOM Service Monitoring Most people that are looking for SCOM service monitoring are probably looking for information about how to monitor a Windows Service […]

SCCM 2012 R2 (Configuration Manager) – Setup is unable to connect to SQL Server

Chances are you have a named instance for your SCCM SQL install, which is definitely the way to go. However, when installing SCCM 2012 (R2) you are presented with the following error. Setup is unable to connect to SQL Server with the connection information provided. Verify the following: The SQL Server and instance names are […]

What is new in Live Maps 7.4

What is new in Live Maps 7.4 We recently released version 7.4 of Live Maps Unity. In this release we were able to add a number of great new features. We have created an integration with ServiceNow, one of the market leaders in IT Service Management. We also added more ways to show performance information […]

Ready-made, IT-centric and fancy dashboards by SCOM Expert Daniel Orneling

For many of us, Savision has always been synonymous with Live Maps Unity, a Business Service Management solution. Live Maps Unity is a great solution as it gives us a clear visualization of the health, availability and performance of your business services using data from SCOM. But wouldn’t it be great to also have some […]

What’s Taking Up My SQL CPU

I found an article on how to identify the thread(s) that are taking up SQL memory but wanted a single script to do it all.  Below is a powershell script I put together to give me the information on what query the thread is running. Credit goes to Manvendra Singh at http://www.mssqltips.com/sqlservertip/2454/how-to-find-out-how-much-cpu-a-sql-server-process-is-really-using/ for the actual SQL queries […]

SCOM 2012 Disaster Recovery process for SQL Restore

I noticed a lack of documentation on the exact process of how to perform the restoration of the SQL back-end of SCOM 2012. So I decided to put together a step by step process on how to restore if you have a full SQL server failure. http://joshancel.wordpress.com/2013/05/31/scom-2012-disaster-recovery-sql-server-restore/   Intro Recently I had the need to […]