New MP: Windows Azure SQL Database Management Pack

Download, Managament Packs, Microsoft, Software, System Center, System Center Operations Manager, Windows Azure 1 Minute

New management pack is available for Windows Azure service. Now you can monitor your Windows Azure SQL Databases from SCOM. These are the key features:

  • User-friendly wizard to discover Windows Azure SQL Database servers.
  • Provides availability status of Windows Azure SQL Database server.
  • Collects and monitors health of Windows Azure SQL Database databases.
    • Space monitoring:
      • Used space
      • Free space
      • Total allocated quota
    • Track the total number of databases per server
  • Collects and monitors performance information:
    • Average memory per session
    • Total memory per session
    • Total CPU time per session
    • Total I/O per session
    • Number of database sessions
    • Maximum Transaction execution time
    • Maximum Transaction lock count
    • Maximum Transaction log space used
    • Network Egress/Ingress bandwidth
  • Ability to define Custom thresholds for each monitor to configure the warning and critical alerts.
  • Run-as profile to securely connect to Windows Azure SQL Database.
  • Detailed knowledge to guide the IT operator with troubleshooting the problem
  • Custom tasks to redirect the user to the Windows Azure SQL Database online portal
  • Custom query support to enable application-specific availability and performance monitoring

Grab the management pack and the installation and configuration guide from here.

Published by Stanislav Zhelyazkov

Stanislav Zhelyazkov has been working in IT since 2007. Stanislav has started his IT career as a Help Desk Specialist in 2007 while studying Informatics in the University of Ruse. He also worked in HP Enterprise Services (now known as DXC), maintaining large corporate IT infrastructures for clients in Holland, Switzerland and Germany and was involved in a Private Cloud project based on MS Hyper-V and System Center. He was also in the role of Principal Consultant in Lumagate developing and consulting companies on Azure, OMS, management and Private clouds. Currently he is Cloud Infrastructure Engineer at Sentia Denmark. Stanislav is active community member at MSDN forums providing answers on Azure. His blogposts can be found at www.cloudadministrator.net or www.systemcentercentral.com.

Published

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.