All Services

From back-end infrastructure to personal productivity, Ergo has the knowledge and experience to match technology to all our client requirements. Our strength is understanding your business. The end goal is always the same, to make businesses more agile and competitive.

More About Our Services
Managed Services

Focus on your core business and leave ICT operations and management to the experts. From 24/7 service desk support to managing hybrid clouds, Ergo have the depth and experience to meet the most demanding service level requirements and ensure continuous improvement. 

More About Managed Services

Highlighted Services

IT Resourcing

Competition for talented technology professionals is huge, which is why we make hiring more personal, taking time to match the right people to the right roles. Our technical experience and recruiting know-how help find the perfect fit for both parties.  

More About IT Resourcing

Highlighted Services

Consultancy Services

Speed of change demands a new generation of digital investments that will drive business enablement and profitability. We support IT leaders, wherever they are on their digital transformation journeys, with our digital assessment methodology. 

More About Consultancy Services

Highlighted Services

Print and Document Solutions

Our goal is to deliver the best possible print and document service for you, leveraging the latest technologies and innovation to ensure the performance of your print environment is optimised to maximise employee productivity.  We take out costs, add efficiencies, wrap it in end-to-end security and make print integral to digital transformation. 

More About Print and Document Solutions

Highlighted Services


Agility is key to business success and the cloud is where to get it. We offer a wide range of cloud services – public, private, hybrid – and provide the best of both worlds by integrating or migrating legacy systems to streamline the way your IT is consumed. 

More About Cloud

Highlighted Services

Digital Enablement

Ergo provides a clear roadmap for digital transformation with practical steps to make businesses more agile and customer-centric

More About Digital Enablement

Highlighted Services

Mobility and Collaboration

Ergo has provided many of Ireland’s largest organisations with an ecosystem of mobile applications and collaboration services that drive productivity without compromising on security

More About Mobility and Collaboration

Highlighted Services

Software Licensing

Businesses struggle to manage software assets and don’t always get the best value. We can help streamline your software purchasing, simplify deployments and maximise your investments. 

More About Software Licensing

Highlighted Services

Security, Risk and Compliance

Risks around cyber security and data protection are an ever-increasing challenge for businesses. We provide security lifecycle management, from perimeter testing and threat analysis to mitigating the impact of a breach. 

More About Security, Risk and Compliance

Highlighted Services

Microsoft Technology Specialisations

With the largest team of Microsoft IT professionals in Ireland – including two Most Valuable Professionals our expertise spans a comprehensive portfolio of products/services

More About Microsoft Technology Specialisations

Type your query and press the "Search now" button

SCOM - New SQL Management Pack and Summary Dashboard Released

SCOM - New SQL Management Pack and Summary Dashboard Released

Read The Article
SCOM - New SQL Management Pack and Summary Dashboard Released
Return to Blog

SCOM - New SQL Management Pack and Summary Dashboard Released

Microsoft has just released a new management pack update for monitoring SQL. We first got a preview of this management pack at the Microsoft Management Summit (MMS 2013) in Las Vegas during the Workloads: Managing Windows, IIS & SQL Technologies session and since then, we've been waiting in earnest for it's release - mainly because of the new SQL Server 2012 Summary dashboard that comes bundled with it.

The release of this MP is a bonus for me as it's just in time for me to be able to include it into my demo for my upcoming session at System Center Universe 2013 DACH.

Here's a screenshot of what the new dashboard looks like (keep in mind that this dashboard will only run on SQL 2012 databases):

Ergo - New SQL Management Pack









The new MP comes with some additional monitors, rules and all round improvements - here's a list of them taken directly from the MP guide:

  • Collect DB Active Requests count
  • Collect DB Active Sessions count
  • Collect DB Active Transactions count
  • Collect DB Engine Thread count
  • Thread Count monitor
  • Transaction Log Free Space (%) monitor
  • Transaction Log Free Space (%) collection
  • Collect DB Engine CPU Utilization (%)
  • CPU Utilization (%) monitor for DB engine
  • Buffer Cache Hit Ratio monitor
  • Collect DB Engine Page Life Expectancy (s)
  • Page Life Expectancy monitor
  • Collect DB Disk Read Latency (ms)
  • Collect DB Disk Write Latency (ms)
  • Disk Read Latency monitor
  • Disk Write Latency monitor
  • Collect DB Transactions per second count
  • Collect DB Engine Average Wait Time (ms)
  • Average Wait Time monitor
  • Collect DB Engine Stolen Server Memory (MB)
  • Stolen Server Memory monitor
  • Collect DB Allocated Free Space (MB)
  • Collect DB Used Space (MB)
  • Collect DB Disk Free Space (MB)
  • SQL Re-Compilation monitor
  • SPN monitor improved
  • Support for special symbols in DB names.
  • Improved AlwaysOn seed discovery
  • Run As configuration changes to support Low privilege for SQL Server 2012 Cluster
  • Improved performance of AlwaysOn discovery
  • Custom User Policy Discovery and Monitoring performance optimization
  • Hid AG health object from Diagram view

You can download the MP and its associated guide from here: 

As always, make sure you read the guide from front to back (this is a big one!) and test the MP out first before deploying into production.

News and Blog Posts

Vigilance as a Service
Steve Blanche
15 February 2019 • Posted By Steve Blanche Chief Technical Officer

Vigilance as a Service

The speed of digital adoption has been such that we really haven’t previously seen such a drastic cultural...

Read now
Treat Print As Seriously As Other Outsourced IT Functions
David Carthy
04 January 2019 • Posted By David Carthy Technical Solutions Manager

Treat Print As Seriously As Other Outsourced IT Functions

Market research shows that outsourcing continues to grow, no doubt helped by the proliferation of cloud services that offer new...

Read now
Ergo named Deloitte Best Managed Company and Great Place to Work for 2019
News 05 March 2019

Ergo named Deloitte Best Managed Company and Great Place to Work for 2019

Read Now
Ergo joins SimplyVital Health Nexus Blockchain Consortium
News 26 February 2019

Ergo joins SimplyVital Health Nexus Blockchain Consortium

Read Now
Cloud Computing - A Mixed Forecast
News 04 February 2019

Cloud Computing - A Mixed Forecast

Read Now

Subscribe to Our Blog

Scroll to Top