[Music] hi everybody this is juniverse product manager SRO in today's demonstration we'll talk about clusters and what does service now SRO does does to support these clusters in terms of license compliance and optimization but let's first understand what is a cluster and details about it so cluster is a virtualization concept and uh the concept is such that uh it allows a group of hosts to work together to share their resources and essentially have a bunch of virtual machines that can run on top of these uh host and these virtual machines can carry software loads such as Microsoft SQL server or Microsoft Windows server or Oracle database server and so on and so forth this technology is provided by a number of vendors with VMware being the the most prominent but we have got hyperv nutonic Acropolis and a lot of them along with some considerable differences majorly uh they provide mechanisms that uh either allow the virtual machines to move across the host or log them to particular host in in in the in the cluster and what essentially uh happens because of that is that the license compliance of products which are deployed on top of these virtual machines uh may get affected and we'll see that but these are all the tenants of a cluster as you can see that a virtual machine can Mo easily move across host on a cluster and you can see here that vm4 and vm5 are locked because of something known as to Affinity which doesn't allow them to move across the cluster so these are some of the infrastructure attributes of a cluster if you move a little bit more uh and depict this infrastructure for uh VMware and vmware's environment is known as V spere and as you can see that there is a cluster which is a virtualization concept we have got host on top of the host we have something known as esxi which is like an operating system which is installed on the host and on that esxi layer are the virtual machines uh uh running and uh on these virtual machines we have got uh uh other software such as Windows Server Microsoft SQL server or even Oracle database running and you can see that there's something known as V and a server which is on one of these Merchant machines which is for overall management of this cluster so that's the infrastructure aspect uh if you see and compare that on the data model of service now cmdb you'll see that we have got a Venter cluster table which is a members of ESX server which is the hypervisor and which is virtualized by uh a server which could be a Windows Server a Linux server Etc and on that server which is basically a virtual machine with is virtual as true uh it would have uh software install on it which means that it would have an installation record for Microsoft SQL server or Windows server and this is really important to understand uh before we go into licensing uh one important difference between this form of cluster which is a virtualization mechanism to something known as SQL cluster now SQL cluster is another failor mechanism but it is at the SQL Server database level however this virtualization technology is at the VM layer and hence it's known as VM level failover and this is known as SQL Server instance level failover basically the primary purpose of this form of cluster is uh for high availability of virtual machines and the SQL Server the primary purpose is the high availability of SQL Server databases so that's a difference impact on licensing the impact on licensing on clusters is immense uh there are some examples to prove that point you can see that for Microsoft uh if a virtual machine with Microsoft products like uh SQL or Windows is hosted on one server but that virtual machine can potentially move to another server the design ation or the destined servers must also be licensed as if the virtual machine is currently running on it what it basically means is that let's say this virtual machine VM van can move across the cluster now this needs to be licensed for all the host which on which the uh the VM can potentially move that means that it needs to be licensed for host one to host 5 so that's the big impact on licensing uh the similar impact on licensing is even for Oracle products uh wherein uh what Oracle says that such kind of virtualization Technologies are known as soft partition Technologies in which we have got the products that we just discussed right uh VMware hyperv and even nutanix and what it say is that if a virtual machine with an oracle product installed is hosted on one server but can potentially migrate to another server the destination servers must also be licensed as if the virtual machine is running on it so similar concept potential movement is really critical for licensing and that's uh What uh U you know if if you deploy a software on a cluster you need to make sure that uh you're taking care of this potential migration uh input now if you look at uh the cost analysis uh or the licensing for a case like uh SQL Server uh in which you have got um let's say a virtual machine with some vcpus running SQL serice standard and you have got uh entitlements available for Enterprise and standard uh if you just look at the uh the licensing cost you will see that you could license the Enterprise uh with SQL Server Enterprise entitlement with either option one which is license all the host U on the on the cluster or option two which is licensing with virtual machines as and when you are licensing through virtual machines the assumption is that the virtual machine can potentially move across all who in the cluster um and again if you're licensing using SQL serice standard at the virtual layer you need to have have software Assurance in place uh and if you uh and and if you have software Assurance in place assuming that the virtual machine can potentially move across all who's in the cluster you can license using SQL service standard in this case it is cheaper to license using SQL service standard uh uh as you have got software Insurance in place and uh uh that means that you could license at the virtual layer using SQL service standard if you compare this option with another option of Oracle database server you can see here that uh the impact on licenses licensing is again huge because this virtual machine can move across the entire cluster and what it means that it needs to be licensed for all the host on which it can potentially live so this use case showcases the huge risk that organizations face while deploying Oracle database on a VMware cluster and uh just as a fact you know servers now can automatically determine uh the licenses that would be consumed in this particular scenario so that the Sam managers can be alerted and take requisite action now let's go into service now support first of all we are discovering a lot of virtualization Technologies or cluster virtualization Technologies including VMware hyperv red hat nutanix Acropolis and so on and so forth as you can see here that the relationships are different uh on the cmtb of service now this owning to the fact that all the different virtualizing technologies have got uh different uh Technologies and so uh the relationships are discovered a bit differently in terms of Discovery support as I said we discover the cluster infrastructure including the host and virtual machines we're able to discover the host Affinity rules uh which uh prevent the movement of virtual machines we're able to discover the software installed on these virtual machines we're able to disc discover the important attributes of uh products like SQL Server such as the version edition as well as uh SQL Server component services including their version and editions and of course the relationships of all these things like cluster host and virtual machine we'll talk about s Licensing in a bit uh in SRO we support the reporting of the infrastructure so you'll be able to see uh in a reported format you know what is uh what is the uh the host the virtual machine on which the SQL Server is deployed you will be able to understand the license compliance of SQL Server uh deployed on different virtualization Technologies we support optimization we'll talk about optimization uh as a primer we able to determine and apply the most cost- effective license either SQL Server standard or Enterprise uh on a cluster we able to Showcase health checks across the cluster so in case you have got uh any Discovery issue like uh the CPU count has not been discovered or a relationship has been missed or even like a configuration of software Assurance on S we're able to uh showcase that through health check and show a recommendation to support that and we have got an interesting feature known as Sam cluster 360 where we able to visualize all this thing together and we'll show that in a demo now let's go to SRO support SRO support as we saw uh and discussed U we able to visualize the cluster host and virtual machines with the software installs we're able to visualize the potential movement of virtual machines again remember potential movement is an important Concept in licensing because uh uh with with the nature of virtual machines if they can potentially move across a cluster you will have to license all the hes in the cluster we're able to determine the license compliance of uh softwares like SQL Windows Oracle on different virtualization Technologies such as uh uh VMware hyperv nutanix Acropolis Etc as I said we will talk about optimization so we implement optimization we showcase the savings achieved through optimization and in case there is any potential savings that can happen uh we showcase those potential savings as well and lastly we're able to show health checks across the cluster so this is the feature which is uh a very prominent feature coming up in zanadu known as cluster 360 or Sam cluster 360 it allows a holistic and Strate iic analysis of cluster to Support Compliance and optimization across a cluster it basically brings everything together so you can see your infrastructure host VMS and software installs including the potential movement of virtual machines see the CES on them easily you're able to see all these softwares uh entitlements or models which are consuming licenses um on the entire cluster so suppose you have got a Windows Server a SQL Server an Oracle database server running on a cluster you can see all the license consumption of these entitlements on the cluster in one view we support optimization so you'll be able to determine all the optimization applied as well as the potential uh optimization that can be achieved on the cluster and of course you can see all the health issues uh across the cluster so it gives Sam managers a holistic and strategic analysis of infrastructure licenses optimization and health so that they can take strategic action the next one is um cost optimization analysis this is an interesting feature we always supported optimization what it means is that we able to apply SQL Server standard or Enterprise depending on the most cost effective license to apply we that for uh Windows Server Data Center and standard as well the new thing about this feature is that we're able to showcase the cost savings uh on this optimization we are able to Showcase uh what is the dollar amount that uh service now saved for you and also what is the logic that service now used to determine this optimization and lastly we show potential savings that is let's say you uh you know we were not able to apply the most optimal license because that license may not be available we show uh that as a potential saving so that if the customer can procure that license this is the amount of savings that you can get so that's we bring all this together in form of a report so that that can be easily downloaded for further uh action and sharing with your stakeholders as well so uh in terms of um in terms of what we can do on cluster with SRO um you know we have all these issues uh we have all the causes of the issue and the solution of them I'll read a few of them such as you know why do I only see four host on the cluster why where can get a complete picture uh this is because you know it could be that only four hosts have been licensed in one is a passive Pho but with this visualization we're able to visualize um all the hosts on the cluster I see only 154 VMS um with software installed on each of the host what does it mean in cmdb I only see 21 VMS this is because you know we consider potential movement of VMS on other host however this uh visualization of potential movement is missing but with this uh solution we're able to analyze all host and VMS that can potentially move on them uh why did service now license the host not the VM so we have got this optimization feature where we'll be able to determine exactly why service now chose to license the VM over the host Etc so all these questions their causes and solution have been listed here now let's move to some use cases before we go to the demonstration of the feature as we saw license compliance is the rules of Microsoft which we need to follow but at the same time we have to apply the cost uh apply the licenses in the most cost effective manner so there is a balancing aspect between both of them and that's what service now s does the use case one the use case one is uh for a specific cluster let's say cluster 103 it's a BMW cluster um and it has got about 11 virtual machines with four on Enterprise SQL Server Enterprise and seven with SQL Server standard we know that uh Enterprise is about four to five times costlier than standard and we have uh the available licenses for them now what service now S pro does is that it looks at your infrastructure it looks at your licenses available and tries to determine what is the uh best uh applicable license based on all the options that Microsoft licensing provides you so the first option is to license using uh the Enterprise license on the host layer so it checks you know uh that it requires these many core licenses uh and if it applies to the host layer uh this is the cost that it's going to be now SQL Server Enterprise also licenses at the virtual layer in case you have got software Assurance so it checks that what is the license if I apply uh SQL Server Enterprise at the virtual layer this is the cost that's going to be and then it looks at uh what if V apply equal server standard and Enterprise at the virtual layer because you have got software Assurance right so with software Assurance you can license at the virtual machine even with SQL service standard so it uh applies that and checks all this and then determines that hey the option number three seems to be the most cost effective so let me apply that and that's what it does it it applies this license and then through that feature which we just talked about cost optimization analysis it provides a reliz saving which is basically uh the difference between option one which is the conservative option to the recommended option and then it provides uh a a logic explanation of why it did it so in this particular case it gives an example that following an assessment with these available licensing option it applied uh SQL Server standard and SQL Server Enterprise uh at the virtual layer because it's the most cost effective option so that's um the feature and U let's see it working so I've logged into s um as I said you know we have got uh two entitlements one uh with sqls of Enterprise 1800 cor rights all with uh software assurance and 2019 uh we have got uh 600 entitlements again with software Assurance so let's see the consumption so I'll go into the licens metric result for 2019 Enterprise uh our example was uh cluster 103 so let me see that I'll Group by cluster and I'll see that U there are about uh four virtual machines which are licensed with the virtual layer because is virtual is true I can go into the license required I can read more details about per cor uh licensing model used here I can see the processor course I can see the installs I can even check host Affinity is uh configured or not similarly I can uh go to 2019 standard and check the same for cluster 103 so in this case let me do show matching I can see that there are about seven virtual machines uh with SQL Server standard licenses again as the virtual layer so uh we just saw that uh SRO applied the licenses for SQL Server standard as well as Enterprise at the virtual so things are working good but now as a Sam manager I would like to understand really in more details how did service now Sam Pro perform this action you know what are the details behind this assessment so we have here a beautiful visualization known as Sam cluster 360 it shows that the cluster has got three host with 11 virtual machines running on VMware virtualization technology uh I can see the infrastructure here I can click on the host I can uh Group by environment if I want to uh I can see the CES and other information uh for this particular host I can go to Virtual machines and see all the virtual machines so we looked at it and there are about 11 virtual machines running again all the different elements of the virtual machine the core count the CPU core count all of that uh I can easily determine um if I want to go a step further I can uh dig deep into that virtual machine and see uh what all potential host can it run so this virtual machine can run across the entire cluster because you can see that it can run on all the three host of that virtual machine of that cluster so that's good information and now uh I can see the install calls I can uh Group by product or publisher just to understand what are the different software installations running on uh on this cluster so this is all about the infrastructure now if I go into consumption or licensing uh consumption I can look at all these softwares entitlements which are consuming license on this cluster so in this case there is 2019 Enterprise 2019 standard if it was Windows Server it would have shown Windows Server Oracle it would have shown Oracle so all these software entitlements which are consuming uh licenses on this cluster are shown uh we can also see all the devices which are consuming licenses on this cluster so very good analysis on licensing I can move to issues and understand all the different issues I can see that there are some issues with uh uh CPU account missing or environment missing and so on so all the issues of the cluster across all the host all the virtual machines are in one View and last but not the least is optimization so I can look at this optimization realized I can see that you know this is for this product SQL Server uh cluster 103 I can look at uh the number of host the cores number of VMS virtual machines VM core licensees required the current license consumption so it says that it use SQL Server standard licenses and SQL Server Enterprise licenses 28 CES and 2 before course the license consumption currently was virtual the rep recommended license consumption is also the same and the recommended license consumption layer is virtual the conservative license consumption is when you're licensing with SQL Server Enterprise at the physical layer or the host layer and this is the cost which comes through conservative license cost this is the recommended license cause which comes when you apply the licenses in the most cost effective Manner and the current license cost is also the same that means that whatever SRO recommended it applied the same and uh you can see that recommended license applied is yes which basically means that it was able to apply the recommended licenses and the licensing status is licenses and then it shows a recommendation details that following an assessment of uh of the available licensing options uh we applied this license which is uh standard Enterprise license uh with essay at the virtual layer because it's the most cost effective one and you can see that the optimization savings realized is yes so had it been that uh um uh had it been that uh you did not have enough standard licenses for example uh you would not be able to achieve the optimization in that case we would have shown potential savings so that uh you know we uh we were not able to apply the most cost effective license but yeah because the licenses were not available but you know if you uh procure this licenses for SQL standard uh you could potentially save save this amount of dollars so very good insights to uh Sam managers uh to understand all the infrastructure needs of a cluster in one view again uh you know we have got uh reporting in place so you can see this thing as a report as well so then entire thing for cluster 103 you're going you can see it here and also you know if you want to have the view across all the Clusters and Standalone host all the optimization for Microsoft in one view you can see that as well so uh that concludes a view of our support on clusters in terms of compliance and optimization let us know if there's any questions thank you