by Contributed | Apr 6, 2022 | Technology
This article is contributed. See the original author and article here.
In many situations, we used to work on performance issue that following the best practices might be resolved by customers. In this article we would like to share a PowerShell Script that checks some best practices for Azure SQL Database and Managed Instance.
We would like to suggest this PowerShell script that you could find out in this URL that contains initial checks we are facing a performance issue. This PowerShell Script is covering the following best practices:
- Check if we have any automatic tuning recomendations . Based on the results of the execution of sys.dm_db_tuning_recommendations DMV informs if your database has any recomendations to apply in your database based on the workload analysis done by the SQL Server engine.
- Check if we have have statistics that are out-of-dated Based on the results of the execution of sys.stats and sys.dm_db_stats_properties DMVs inform if any statistics, automatic , user created or associated with an index has the following conditions: If the rows sample is different than the number of rows (this situation may be indicated that the statistics has been updated automatic by SQL Server using a sample or if the statistics has been update more than 15 days ago.
- Check if you have any TSQL that was cancelled or aborted. For example, after expiring of execution command timeout. This check is based on QDS DVM call sys.query_store_runtime_stats.
- Check if you have missing indexes. Based on the results of the execution of sys.dm_db_missing_index_xxx informs if you have any missing indexes that helps you to improve the execution of your query.
- Check the setting value of MAXDOP. Based on the results of the sys.database_scoped_configurations DMV check if the value of MAXDOP is 0.
- Check the fragmentation of the indexes. Based on the results of sys.dm_db_index_physical_stats DMV check if the fragmentation of the indexes is more than 50 percent.
Basically, once you have download this PowerShell script, you need to provide the details of your server, database, user, password and destination folder. You could fill up directly these parameters in the PowerShell script if you need to perform more time this process. This PowerShell script only will ask those parameters if they are missing. Also, you could specify as a command line.
Once the process is executed, this PowerShell script will save a file called PerfChecker.Log in the destination folder chosen. Every execution this file will be deleted and created a new one.
This project is public and all the contributions to make more accesible, easy and effective will be very welcome.
Enjoy!
by Scott Muniz | Apr 6, 2022 | Security, Technology
This article is contributed. See the original author and article here.
Mozilla has released security updates to address vulnerabilities in Firefox, Firefox ESR, and Thunderbird. An attacker could exploit some of these vulnerabilities to take control of an affected system.
CISA encourages users and administrators to review the Mozilla security advisories for Firefox 99, Firefox ESR 91.8, and Thunderbird 91.8 and apply the necessary updates.
by Scott Muniz | Apr 6, 2022 | Security, Technology
This article is contributed. See the original author and article here.
Mozilla has released security updates to address vulnerabilities in Firefox and Firefox ESR. An attacker could exploit some of these vulnerabilities to take control of an affected system.
CISA encourages users and administrators to review the Mozilla security advisories for Firefox 99 and Firefox ESR 91.8 and apply the necessary updates.
by Scott Muniz | Apr 6, 2022 | Security, Technology
This article is contributed. See the original author and article here.
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A
lock (
) or
https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
by Contributed | Apr 5, 2022 | Technology
This article is contributed. See the original author and article here.
We are very happy to announce that we have enabled evaluation licenses for our WebSphere on Azure Virtual Machines (VMs) Marketplace solutions. The solutions are jointly developed and supported by IBM and Microsoft. We have also added support for standalone WebSphere Base instance on VMs deployments. In addition, we have integrated a sample getting started application into our WebSphere Liberty/Open Liberty on Azure Kubernetes Service (AKS)/Azure Red Hat OpenShift (ARO) solutions. These changes make getting started with WebSphere and Azure even easier. Evaluate the WebSphere on Azure solutions for full production usage and reach out to collaborate on migration cases.
WebSphere Base Standalone Instance on VMs
IBM and Microsoft previously released a Marketplace solution to automate WebSphere Network Deployment (ND) cluster deployments on VMs. We now have an additional offer targeting single instance deployments of WebSphere Base on VMs. The solutions automatically provision a number of resources including virtual network, storage, network security group, Java, Linux, and WebSphere. With minimal effort, you can set up a fully functional WebSphere deployment including the Console. The solutions support WebSphere 9.0.5 on Red Hat Enterprise Linux (RHEL) 8.3.
The solutions enable a variety of robust production-ready deployment architectures. Once the initial provisioning is complete, you can fully customize the deployment including integrating with a wide range of Azure services.
Evaluation Licenses for WebSphere on VMs
The WebSphere traditional on VMs solutions primarily follow a Bring Your Own License model. You must have the appropriate licenses from IBM and be properly licensed to run production workloads on Azure. The solutions ensure that you have adequate WebSphere entitlements. Now you can also use evaluation licenses for both WebSphere ND and Base. This enables key use cases such as exploration, prototyping, and trial. With the evaluation option, it is possible to apply WebSphere entitlements to a deployment later on.
Liberty on ARO/AKS Sample Application
In addition to WebSphere traditional on VMs solutions, IBM and Microsoft have previously released Marketplace solutions targeting WebSphere Liberty/Open Liberty on AKS and ARO. Similar to the VM solutions, the AKS/ARO solutions enable you to focus on developing and deploying your containerized applications instead of initial provisioning and configuration of Java and Azure resources. The resources automatically provisioned by these solutions include virtual networks, an ARO/AKS cluster, the OpenShift Container Registry (OCR)/Azure Container Registry (ACR), and the Liberty Operator. The solutions can optionally deploy a Docker image that includes Open Liberty or WebSphere Liberty and your application. The image must be anonymously accessible from a registry such as Docker Hub. In addition, we now have an option in the solutions to deploy an IBM provided Liberty sample application. The sample application helps you get started with Liberty, containers, and Azure with minimal prior knowledge required.
Note, WebSphere Liberty is available as a limited trial option before entitlement must be applied to the deployment. Open Liberty is open source and free to use unsupported. You can also use Open Liberty supported through WebSphere Liberty entitlements.
Get started with WebSphere on Azure
Explore the WebSphere on Azure solutions, provide feedback, and stay informed of the roadmap. You can also take advantage of hands-on help from the engineering team behind these solutions. The opportunity to collaborate on a migration scenario is completely free while the solutions are under active initial development.
Recent Comments