1. SQLServer: Buffer Manager: Buffer cache hit ratioThe buffer cache hit ratio counter represents how often SQL Server is able to find data pages in its buffer cache when a query needs a data page. The higher this number the better, because it means SQL Server was able to get data for queries out of memory instead of reading from disk. You want this number to be as close to 100 as possible. Having this counter at 100 means that 100% of the time SQL Server has found the needed data pages in memory. A low buffer cache hit ratio could indicate a memory problem.Read More →

$Subs = Get-AzSubscription # Set array $DiagResults = @() # Loop through all Azure Subscriptions foreach ($Sub in $Subs) { Set-AzContext $Sub.id | Out-Null Write-Host “Processing Subscription:” $($Sub).name # Get all Azure resources for current subscription $Resources = Get-AZResource -ExpandProperties -ResourceType microsoft.insights/components # Get all Azure resources which have Diagnostic settings enabled and configured foreach ($res in $Resources) { $resId = $res.ResourceId If ( $res.Type -match “microsoft.insights/components” ) { # Write-Host $res.Type }else { continue } #Write-Host $res.Properties.IngestionMode #Write-Host $resId $DiagSettings = Get-AzDiagnosticSetting -ResourceId $resId -WarningAction SilentlyContinue -ErrorAction SilentlyContinue | Where-Object { $_.Id -ne $null } #Write-Host $DiagSettings foreach ($diag in $DiagSettings) { #Write-Host $diagRead More →

As you know we can use the variable in some of the format such as : [[variable]]$variable${variable} When upgrading to v10.3.1 , i realize that the variable __interval_ms can’t be used as [[__interval_ms]] , we need to to use it as $__interval_ms as [[]] is going to be depreciated soon, it’s recommended to use the new format. If you have old dashboard and it’s not displaying correctly, check the variable.Read More →

I recently bought a used Canon 70-200mm F2.8 IS . The lens is in good condition, but it has an issue with auto focus. When you try to focus, you can see the focus ring spinning very fast, but it’s failed to focus , it seems only focus for object over 10mm  or it’s at infinity. After some research, it turn out that the issues was caused by a dirty focus sensor and focus bar.  Below are the 2 videos that will help you to fix that problem. I did it it’s half success – the focus is now working, but i damage a flexRead More →

Are both static and dynamic thresholds available? Can you combine static and dynamic thresholds? Are thresholds configured out of the box? Are there AIOps capabilities such as root-cause diagnosis and event filtering and correlation? Once set up it is it transparent to the operator what the metrics are and why they have been set I.e., can your frontline support understand why alerts are being triggered What ITSM service and help desk tool (e.g., ServiceNow, JIRA, Autotask) integrations are available? Once thresholds trigger alerts how do you intend to manage the IT issues they have highlighted? Can metrics be aggregated – e.g., an alert triggered ifRead More →

This query can help you to identify the orphan smart detector alerts – there is also a command column which can help you to run it in shell.portal.com resources | where type in (“microsoft.alertsmanagement/smartdetectoralertrules”)| project subscriptionId, id,name,resourceGroup,properties.actionGroups.groupIds[0] , properties.scope[0] | project-rename alert_id = id, alert_subscription=subscriptionId,alert_name=name,target_id=properties_scope_0,actionGroupId=properties_actionGroups_groupIds_0 | extend target_id=tolower(tostring(target_id)) | join kind=leftouter ( resources | project id,name,type,resourceGroup,subscriptionId | extend id=tolower(tostring(id))) on $left.target_id==$right.id | where name==”” | extend target_name=split(target_id,”/”)[-1] |extend cmd_delete=strcat(“az resource delete –ids \””, alert_id,”\””)Read More →