The new HPE InfoSight App Insights extends AI-driven intelligence into the app layer with predictive analytics, monitoring, and problem notification. Good news. It is now available for Microsoft SQL Server!
Well, let’s first consider the ‘old dog’ in question. HPE InfoSight has a champion pedigree. It is known today as a leading example of advanced AI for IT infrastructure, monitoring over 100,000 systems worldwide. But it was an innovative technology even back before it amassed a database of over a trillion data points, back when it was created at HPE Nimble Storage – a dog’s age ago, as they say – in or around 2010.
Though it also featured a compelling dashboard that obviated the need to scroll logs or piece together performance data from different screens, its breakthrough capability was the event-based Alerting. It had the ability to generate notifications for monitoring and proactively opening support cases.
Back then, the support team at Nimble Storage only wanted to solve problems once. They achieved this by gathering data points from a highly instrumented storage OS, along with physical system sensors, which then correlated problems with related system data. This produced a library of fingerprints that had the power to discover and even predict problems before failures could impact storage operations.
Now known as HPE InfoSight, the sophistication and breadth of this sensor fabric has expanded beyond storage to virtualized software, compute, and applications, driving the predictive value of HPE InfoSight to an industry leadership position.
New tricks with Microsoft Enterprise Databases
The new trick with HPE InfoSight is the addition of HPE InfoSight App Insights, an extension of the popular free tool that adds visibility to applications. Details on the new offering are available in its introductory announcement. Where it had already mastered a course of anomaly detection and prescriptive notifications for infrastructure hardware up to the OS and hypervisor, HPE InfoSight now has the agility to look up the stack to databases, including Microsoft SQL Server.
SQL Server continues to be a leader in relational database management, with many Microsoft customers choosing to maintain their important and growing corporate data on-premises. And with the advent of new HPE GreenLake services such as HPE GreenLake for Microsoft SQL Server, customers can maintain the control and security of on-premises IT, while enjoying pay-per-use pricing, point-and-click self-service, and cloud-like flexibility.
HPE and Microsoft have a 30+ year history of co-innovation for the benefit of shared customers, as reflected in this recent quote by Microsoft VP, Roanne Soanes: “The shared work to integrate HPE GreenLake with Microsoft offerings gives our customers a managed services solution that offers simplicity, flexibility, and the economics that work for their environments...”
HPE InfoSight App Insights and HPE GreenLake services will both work like dogs to keep your SQL Server environment visible, available and highly-performing.
Fetching AI-powered intelligence for SQL Server
There’s information out already on how the new HPE InfoSight App Insights works – with much more on the way. But first, we wanted to dig our noses into specifics on how the new feature makes managing a Microsoft SQL Server environment easy. Here are a couple key takeaways from the engineering lab:
- With HPE InfoSight App Insights, an Infrastructure Admin and SQL Admin can both easily identify the related system resources for a particular SQL Server Database and/or Instance, either in a physical SQL Server deployment or in a virtualized SQL Server deployment.
Below is a screen shot from the application. It illustrates a virtualized SQL Server deployment, and details the system topology of a database Instance “SQL-VM-1”. This view pulls together information on the physical and logical environment, as well as details on the underlying storage resources. Without HPE InfoSight App Insights, assembling this data could take some time, and certainly would require accessing several different tools.
2. HPE InfoSight App Insights is not just collecting data from the Storage array and/or from SQL Server. It correlates the data, presenting it in a very useful way. The charts, as you can see below, make it much easier for Infrastructure Admins and DBAs to identify unusual patterns that relate to resource utilization, either on a SQL Server Instance level, OS level, or hardware (Array) level.
Call to action
If you haven’t already done so, take the opportunity to read the growing amount of HPE InfoSight App Insights content online or watch the various demos that are available.
By harnessing this type of AI-powered autonomous monitoring, along with the simplified, cloud experience of HPE GreenLake, you can have an almost hands-off SQL Server environment that keeps running optimally, while reducing your upfront investment and costs associated with overprovisioning.
Learn more about how to unleash cloud-model innovation for your on-premises SQL Server environment with the new SQL Server on HPE Storage as an HPE GreenLake solution. And read the new blogs on Around the Storage Block about the new HPE InfoSight App Insights and what it brings to Microsoft SQL Server.
- Introducing HPE InfoSight App Insights: AI-driven workload intelligence
- Industry-leading AIOps for infrastructure extends edge with HPE InfoSight App Insights
Also check out: Top five reasons to keep Microsoft apps on HPE Nimble Storage DHCI
Storage Experts
Hewlett Packard Enterprise
twitter.com/HPE_Storage
linkedin.com/showcase/hpestorage/
hpe.com/storage
StorageExperts
Our team of Hewlett Packard Enterprise storage experts helps you to dive deep into relevant infrastructure topics.
