Introduction When deploying SQL Server on Azure VMs, you can boost tempdb performance by storing it on ephemeral (temporary) storage. Microsoft recommends using the local SSD (often D: drive) for tempdb. However, if your SQL Server runs under a Managed…
1. Check if Machine Is Domain Joined (Get-WmiObject Win32_ComputerSystem).PartOfDomain 2. View SPNs for a SQL Server Service Account setspn -L domain\sqlsvcaccount 3. Register an SPN for SQL Server setspn -S MSSQLSvc domain\sqlsvcaccount 4. Create a gMSA Account (Domain Admin) New-ADServiceAccount…
SELECT name, db_name(database_id),replica_server_name,endpoint_url,availability_mode_desc,failover_mode_desc,seeding_mode_desc,backup_priority,cluster_type_desc,required_synchronized_secondaries_to_commit,is_local,is_distributed,is_primary_replica,synchronization_health_desc,synchronization_state_desc,recovery_lsn,last_hardened_lsn,last_hardened_time,secondary_lag_secondsFROM sys.availability_replicas AS arINNER JOINsys.availability_groups AS agON ar.group_id = ag.group_idINNER JOINsys.dm_hadr_database_replica_states AS rsON ar.group_id = rs.group_idAND ar.replica_id = rs.replica_idORDER BY name;
Statspack is a tool available from Oracle 8. It is still an option for gathering workload statistics, if diagnostics pack is not available. Standard Editions of Oracle do not support Diagnostic pack as it is an addon of Enterprise Edition.…
Keep in mind that if normal or extended redundancy are used then additional disk must be added in each filegroup by using FAILGROUP clause.
Setup VM network with NAT. Port forward port 22 to another (example: 3022) in NAT Settings. SSH to 3022
Monitoring tablespace usage is a critical part of Oracle database administration. As DBAs, we need to keep an eye on how much space is used, how much remains, and how it aligns with what’s physically allocated on disk. We’ll explore…
// Author: Microsoft Azure// Display name: Find Errors// Description: Search for errors in the last 6 hours.// Categories: Workloads// Resource types: Azure Database for PostgreSQL servers// Topic: Errors AzureDiagnostics| where TimeGenerated > ago(6h)| where Category == “PostgreSQLLogs”| where errorLevel_s contains…
> rs.status().members.forEach(member => {print(`Member ID: ${member._id}, Host: ${member.name}, State: ${member.stateStr}`); });