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

Managed People

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 Managed People

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

Cloud

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:

http://www.microsoft.com/en-us/download/details.aspx?id=10631 

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.http://www.microsoft.com/en-us/download/details.aspx?id=10631

News and Blog Posts

What is ISO 27001 and Why Do I Need It?
22 May 2018 • Posted By Nikos Vasileiadis IT Security Officer

What is ISO 27001 and Why Do I Need It?

The field of cybersecurity is changing rapidly, and the challenges faced by businesses are mounting considerably. Couple this together with...

Read now
Power BI: 6 Steps to building reports that really work
Kate Cunningham
17 May 2018 • Posted By Kate Cunningham

Power BI: 6 Steps to building reports that really work

In an era of Big Data, analytical strategic decision making is becoming pivotal for success. Managers at every level are...

Read now
Managed Print and Document Services: Navigating a Sea of Data
News 10 May 2018

Managed Print and Document Services: Navigating a Sea of Data

Read Now
CRM: Don’t just jump on the bandwagon
News 14 March 2018

CRM: Don’t just jump on the bandwagon

Read Now
Business Analytics and Big Data: How to Read the Future
News 14 March 2018

Business Analytics and Big Data: How to Read the Future

Read Now

Subscribe to Our Blog

Scroll to Top