Meta tags:
Headings (most frequently used words):
create, configure, availability, the, volumes, sql, server, for, on, group, storage, groups, and, cluster, netapp, block, to, always, domain, clustering, up, windows, failover, quorum, use, google, cloud, stay, organized, with, collections, save, categorize, content, based, your, preferences, objectives, costs, before, you, begin, accounts, compute, engine, vms, join, servers, prepare, mount, iscsi, each, vm, set, test, clean, host, provision, pool, firewall, file, share, enable, in, database, dnn, resource, delete, project, products, pricing, support, resources, engage,
Text of the page (most frequently used words):
the (244), and (184), #create (161), for (150), vms (111), server (94), with (85), sql (72), select (62), troubleshoot (62), about (59), instance (53), disk (52), configure (50), cloud (46), manage (46), using (46), windows (45), click (40), google (39), view (39), availability (38), cluster (38), use (36), compute (35), disks (35), name (34), from (34), mig (33), your (32), group (31), performance (31), overview (31), set (30), you (29), connect (29), engine (29), storage (27), reservation (27), project (26), network (26), volumes (26), new (24), configuration (24), access (24), machine (24), host (23), failover (22), sqlnode1 (22), groups (22), hyperdisk (22), resources (21), add (21), data (21), mssql (21), microsoft (21), images (21), that (20), sqlnode2 (20), monitor (20), service (19), management (19), tcp (19), database (18), type (18), instances (18), gpu (18), run (17), following (17), example (17), backup (17), iscsi (17), domain (17), image (17), linux (17), policies (16), manager (16), log (16), apply (16), account (16), install (16), snapshots (16), reservations (16), right (15), load (15), enable (15), file (15), virtual (15), ssh (15), recommendations (15), delete (14), mssqlserver (14), workload (14), creation (14), custom (14), resource (13), open (13), share (13), modify (13), logs (13), netapp (13), bulk (13), high (12), node (12), based (12), sole (12), persistent (12), best (12), regional (12), page (11), always (11), restore (11), zone (11), each (11), location (11), existing (11), boot (11), practices (11), workloads (11), stateful (11), application (10), dns (10), files (10), quorum (10), choose (10), protocol (10), allow (10), start (10), agent (10), list (10), pool (10), internal (10), managed (10), metadata (10), migs (10), machines (10), attached (10), migrate (10), zones (10), action (9), dnn (9), update (9), properties (9), back (9), recovery (9), steps (9), tempdb (9), login (9), change (9), target (9), addresses (9), networking (9), licenses (9), tenant (9), multiple (9), openshift (9), shutdown (9), time (9), hpc (9), all (8), this (8), license (8), ssms (8), alter (8), nodes (8), wizard (8), tab (8), section (8), netfirewallrule (8), displayname (8), direction (8), inbound (8), localport (8), powershell (8), administrator (8), these (8), clustering (8), manually (8), remove (8), startup (8), directory (8), multi (8), local (8), console (8), snapshot (8), region (8), deploy (8), import (8), cpu (8), optimize (8), disaster (8), guest (8), keys (8), h4d (8), flexibility (8), optimized (8), tpu (8), thumb (7), need (7), projects (7), after (7), both (7), default (7), mode (7), full (7), options (7), databases (7), perform (7), enter (7), then (7), next (7), path (7), witness (7), control (7), tools (7), move (7), locations (7), volume (7), capacity (7), block (7), pools (7), security (7), active (7), accounts (7), usage (7), commitments (7), balancing (7), benchmark (7), idle (7), request (7), scale (7), mysql (7), zonal (7), maintenance (7), templates (7), join (6), events (6), information (6), details (6), send (6), can (6), replica (6), ensure (6), mydb1 (6), object (6), model (6), services (6), permissions (6), clusters (6), master (6), stop (6), paths (6), filename (6), sqlsvc (6), advanced (6), command (6), vpc (6), flex (6), get (6), operating (6), between (6), migration (6), updates (6), instant (6), nested (6), gpus (6), across (6), applications (6), demand (6), extension (6), transfer (6), customized (6), spot (6), code (5), samples (5), system (5), support (5), understand (5), down (5), more (5), tutorial (5), check (5), sys (5), replicas (5), automatic (5), created (5), expand (5), role (5), roles (5), distributed (5), follow (5), creating (5), ldf (5), mdf (5), temp (5), size (5), shell (5), iqn (5), uses (5), monitoring (5), errors (5), future (5), drivers (5), virtualization (5), nvidia (5), operations (5), placement (5), highly (5), available (5), build (5), schedules (5), audit (5), symphony (5), email (5), scripts (5), systems (5), enhanced (5), capabilities (5), tenancy (5), regions (5), types (5), workstation (5), faq (5), other (4), primary (4), running (4), listener (4), manual (4), ars (4), group_id (4), where (4), query (4), connection (4), complete (4), balancer (4), transaction (4), tasks (4), copy (4), settings (4), shared (4), before (4), udp (4), msdb (4), backups (4), dialog (4), portal (4), initiator (4), mount (4), specific (4), project_id (4), windowsfeature (4), net (4), prepare (4), series (4), plan (4), how (4), guides (4), authentication (4), issues (4), ubuntu (4), bandwidth (4), pmu (4), number (4), ssd (4), upgrade (4), live (4), autoscaling (4), cross (4), requests (4), calendar (4), single (4), metrics (4), health (4), containers (4), container (4), postgresql (4), extensions (4), work (4), suspend (4), resize (4), graceful (4), plans (4), replication (4), review (4), bound (4), sign (3), terms (3), pricing (3), see (3), content (3), under (3), are (3), apache (3), selecting (3), verify (3), which (3), configured (3), synchronous (3), bring (3), client (3), traffic (3), only (3), synchronization (3), port (3), 5022 (3), specify (3), pane (3), restart (3), grant (3), folder (3), computer (3), static (3), address (3), 3343 (3), rpc (3), firewall (3), wsfc (3), errorlog (3), their (3), drives (3), exec (3), xp_instance_regwrite (3), hkey_local_machine (3), software (3), reg_sz (3), repeat (3), format (3), device (3), devices (3), mpio (3), targets (3), one (3), ips (3), replace (3), two (3), volume_name (3), gcloud (3), host_group_name (3), pool_name (3), throughput (3), provision (3), hosts (3), rsat (3), core (3), features (3), close (3), credentials (3), interface (3), subnet (3), interfaces (3), balanced (3), memory (3), general (3), api (3), user (3), rdp (3), costs (3), through (3), cloning (3), infrastructure (3), observability (3), analytics (3), troubleshooting (3), encryption (3), pro (3), serial (3), configurations (3), patterns (3), higher (3), discounts (3), cuds (3), scalable (3), resilient (3), autoscale (3), prevent (3), policy (3), testing (3), ibm (3), spectrum (3), deploying (3), during (3), deployment (3), rhel (3), environment (3), protect (3), certificates (3), state (3), disable (3), increase (3), schedule (3), lifecycle (3), design (3), non (3), workstations (3), tpus (3), product (3), 한국어 (2), 日本語 (2), עברית (2), português (2), brasil (2), italiano (2), indonesia (2), français (2), español (2), américa (2), latina (2), deutsch (2), english (2), third (2), site (2), youtube (2), center (2), started (2), status (2), products (2), last (2), updated (2), 2026 (2), utc (2), licensed (2), its (2), feedback (2), used (2), also (2), clicking (2), secondary (2), replica_server_name (2), availability_groups (2), availability_replicas (2), replica_id (2), commit (2), test (2), include (2), have (2), don (2), must (2), checkbox (2), any (2), online (2), provide (2), point (2), instead (2), endpoints (2), explorer (2), specifying (2), norecovery (2), browser (2), finish (2), sqlcluster (2), customize (2), different (2), validation (2), validate (2), msc (2), endpoint (2), 135 (2), sharing (2), smb (2), 445 (2), 49152 (2), 65535 (2), 3260 (2), 1433 (2), commands (2), old (2), program (2), mssql16 (2), mastlog (2), parameters (2), drive (2), modellog (2), msdbdata (2), msdblog (2), templog (2), member (2), password (2), foreach (2), appears (2), discover (2), associated (2), iscsicpl (2), exe (2), 165 (2), 128 (2), note (2), range (2), private (2), psa_range_name (2), vpc_name (2), west1 (2), 1024 (2), total (2), iops (2), sqlnode2_iqn (2), sqlnode1_iqn (2), record (2), cvsdemo (2), framework (2), required (2), administrators (2), when (2), servers (2), premium (2), save (2), 2022 (2), enterprise (2), 2025 (2), public (2), purpose (2), activate (2), within (2), identity (2), enabled (2), selector (2), resourcemanager (2), require (2), iam (2), begin (2), generate (2), cost (2), documentation (2), sdk (2), languages (2), frameworks (2), industry (2), solutions (2), hybrid (2), multicloud (2), pipelines (2), hosting (2), development (2), quota (2), commitment (2), consumption (2), standard (2), registration (2), sles (2), export (2), collecting (2), report (2), arm (2), app (2), latency (2), analyze (2), visible (2), cores (2), automatically (2), committed (2), generation (2), underutilized (2), insights (2), utilization (2), globally (2), web (2), autohealing (2), iis (2), external (2), reserve (2), autoscaler (2), autoscalers (2), activity (2), kubernetes (2), provider (2), place (2), setting (2), redis (2), writer (2), alwayson (2), authenticate (2), method (2), global (2), switch (2), byol (2), payg (2), byos (2), changes (2), families (2), guide (2), securing (2), event (2), simulate (2), topology (2), together (2), repairs (2), repair (2), failures (2), template (2), suspended (2), stopped (2), distribution (2), physical (2), cancel (2), once (2), limit (2), ipv6 (2), decrease (2), basic (2), consistent (2), scoped (2), appliances (2), asynchronous (2), encrypt (2), names (2), extreme (2), organization (2), rdma (2), preemptible (2), provisioning (2), models (2), rtx (2), vws (2), constraints (2), accelerator (2), apis (2), reference (2), technology (2), areas (2), subscribe, newsletter, our, decade, climate, cookies, privacy, tech, twitter, blog, engage, training, certification, architecture, getting, github, release, notes, community, forums, contact, sales, marketplace, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, hard, hardtounderstand, incorrect, sample, incorrectinformationorsamplecode, missing, missingtheinformationsamplesineed, otherdown, tell, except, otherwise, noted, java, registered, trademark, oracle, affiliates, developers, creative, commons, attribution, avoid, incurring, charges, shutting, clean, show, dashboard, reconnecting, checking, servername, initiate, ag_name, primaryreplica, dm_hadr_availability_replica_states, role_desc, availability_mode_desc, failover_mode_desc, strings, multisubnetfailover, true, binds, exclude, them, possible, owners, clear, aren, route, initial, yes, readable, tree, confirm, option, actions, cno, browse, shares, folders, window, intend, recommend, preferably, serve, prompts, administering, tests, pass, proceeding, cluadmin, mapper, printer, allows, respectively, parameter, pointing, script, redirect, mounted, backupdirectory, defaultdata, defaultlog, modeldev, tempdev, logins, necessary, default_database, default_language, us_english, sysadmin, studio, previous, step, left, mounting, respective, item, itemtype, force, structure, newly, formatted, assign, letter, ntfs, 64k, allocation, unit, initialize, gpt, compmgmt, rebooting, reboot, prompted, panel, discovered, adapter, 216, 217, iscsitargetportal, targetportaladdress, replacing, assigned, configuring, listed, unique, eight, times, 200, protocols, hostgroups, false, separate, allocated, match, level, unified, psa, iscsi_initiator, description, containing, iqns, ensures, specified, 1991, com, initiatorport, nodeaddress, qualified, alternatively, cmdinterface, includeallsubfeature, includemanagementtools, multipath, msdsmautomaticclaim, bustype, prereqs, localgroupmember, restarts, welcome, message, now, link, workgroup, second, named, tier, gvnic, card, datacenter, version, highmem, 8vcpu, privileges, domainadmin, installation, rules, computers, established, administrative, billing, keep, procedure, removing, creator, contains, permission, learn, projectcreator, doesn, been, granted, billable, components, estimate, projected, calculator, objectives, explains, internet, small, provides, fully, such, categorize, preferences, stay, organized, collections, home, concurrent, operation, renewal, nvme, resizing, common, pay, viewing, output, diagnostic, sudoers, screenshots, bug, blackwell, soft, lockups, bus, locks, rescue, inaccessible, dumps, kernel, panic, fstab, unresponsive, suspension, reboots, shutdowns, connectivity, tips, nics, dpdk, improve, resiliency, communication, reduce, compact, idpf, irdma, driver, nic, threads, per, sustained, merge, split, extend, renew, without, purchase, savings, dynamic, overcommit, cpus, floating, reliable, backends, routing, https, scaling, consuming, consume, combine, cud, decisions, signals, serving, predictions, organize, labels, states, observe, reports, tensorflow, inference, tensorrt5, learning, monte, carlo, methods, spark, forwarding, others, integrate, exchange, 2016, sharepoint, strategies, passive, inactive, setups, built, integrations, were, deployed, transition, hammerdb, bucket, aws, ec2, pacemaker, s2d, hot, standby, drbd, architectures, mailjet, mailgun, sendgrid, sending, blue, green, deployments, lamp, joomla, asp, interactive, mongodb, flask, terraform, over, mtls, random, generator, virtio, rng, accurate, ntp, append, els, restrictions, packages, deprecate, versions, family, trusted, red, hat, knowledgebase, functionality, risks, controls, confidential, kek, secure, expiration, shielded, attributes, predefined, handle, notices, process, faulty, unmanaged, affect, preserved, turn, off, alternate, fails, repairing, maintain, upgrades, override, selectively, applying, accelerate, out, outage, rebalance, reenable, proactive, redistribution, shape, distribute, define, info, accidental, deletion, spread, edit, rename, reset, resume, referrers, source, uuid, recover, corrupted, duplicate, clones, alerts, vss, regionally, protection, considerations, consistency, failback, replicate, make, provisioned, limits, evaluate, help, kms, customer, supplied, symbolic, links, practice, ram, attach, additional, exapools, ptr, failure, rates, tags, restrict, automate, sac, securely, apps, root, vpn, bastion, iap, connections, networks, iso, imported, prerequisites, importing, exporting, own, detach, reattach, constraint, accounting, examples, slurm, reserved, team, slice, slices, adds, scenarios, deterministic, base, requirements, ready, aci, preempted, historical, alternative, similar, displays, ops, logging, has, gpudirect, ultra, minimum, platform, hostname, quickstarts, office, licensing, strategy, gemini, bare, metal, accelerators, platforms, scores, free, skip, main,
Text of the page (random words):
lable applications globally autoscale a web service on compute engine patterns for scalable and resilient applications patterns for using floating ip addresses on compute engine optimize resource utilization use recommendations to manage resources apply machine type recommendations to vms configure machine type recommendations apply machine type recommendations to migs view and apply idle resources recommendations view and understand vm insights view and understand mig insights manage idle vm recommendations idle vm recommendations overview view and apply idle vm recommendations configure idle vm recommendations manage reservation recommendations reservation recommendations overview view and apply idle reservation recommendations view and apply underutilized reservation recommendations configure idle reservation recommendations configure underutilized reservation recommendations overcommit cpus on sole tenant vms manual live migration about manual live migration manually live migrate vms share sole tenant node groups next generation dynamic resource management cost savings get discounts for committed usage about commitments and committed use discounts cuds resource based cuds purchase resource based commitments without attached reservations with attached reservations for os licenses manage resource based commitments renew commitments automatically extend commitment terms merge and split commitments upgrade commitments share resource based cuds across projects get discounts for sustained usage disk performance optimize hyperdisk performance optimize persistent disk performance optimize local ssd performance workload performance set the number of threads per core customize the number of visible cpu cores analyze the cpu performance using the pmu pmu overview enable the pmu in vms manage the pmu in vms network performance network bandwidth use google virtual nic use irdma network driver use idpf network interface configure a vm with higher bandwidth reduce latency by using compact placement policies optimize tcp network communication optimize tcp network performance optimize tcp network resiliency benchmark higher bandwidth vms optimize app latency with load balancing use dpdk to improve network performance network performance and gpu vms networking and gpu machines use higher network bandwidth patterns for using multiple host nics troubleshoot general tips troubleshoot connectivity troubleshoot rdp troubleshoot ssh troubleshoot os login troubleshoot vms troubleshoot vm operations troubleshoot vm creation troubleshoot resource availability errors troubleshoot bulk api vm creation troubleshoot vm reboots and shutdowns troubleshoot vm suspension troubleshoot vm updates troubleshoot unresponsive vms troubleshoot vm startup troubleshoot fstab errors troubleshoot kernel panic collecting core dumps rescue an inaccessible vm troubleshoot cpu bus locks troubleshoot cpu soft lockups troubleshoot vm configurations troubleshoot arm vms troubleshoot gpu vms troubleshoot nvidia gpu errors generate a nvidia bug report for blackwell gpus troubleshoot nested virtualization troubleshoot using vm screenshots troubleshoot sole tenant nodes troubleshoot vm performance issues troubleshoot sudoers files troubleshoot windows vms troubleshoot windows vms collecting diagnostic information troubleshoot using the serial console troubleshoot using the serial console viewing serial port output troubleshoot instance groups troubleshoot managed instance groups migs troubleshoot os management troubleshoot licenses troubleshoot image import and export troubleshooting sles pay as you go registration troubleshooting ubuntu pro registration troubleshoot metadata server troubleshoot metadata server troubleshoot networking issues troubleshoot common networking issues troubleshoot network drivers troubleshoot vm performance issues troubleshoot storage troubleshoot disk creation troubleshoot full disks and disk resizing troubleshoot disk encryption troubleshoot nvme disks troubleshoot instant snapshots troubleshoot standard snapshots troubleshoot reservations and commitments troubleshoot reservation creation troubleshoot reservation consumption troubleshooting reservation monitoring troubleshoot reservation updates troubleshoot future reservation creation and updates troubleshoot automatic commitment renewal troubleshoot quota errors troubleshoot concurrent operation quota errors troubleshoot workload authentication troubleshoot default service accounts troubleshoot workload to workload authentication ai and ml application development application hosting compute data analytics and pipelines databases distributed hybrid and multicloud industry solutions migration networking observability and monitoring security storage access and resources management costs and usage management infrastructure as code sdk languages frameworks and tools home documentation compute compute engine guides send feedback use google cloud netapp volumes block storage to configure a sql server always on availability groups stay organized with collections save and categorize content based on your preferences this tutorial explains how to deploy a microsoft sql server always on availability group on compute engine virtual machine vm instances by using google cloud netapp volumes block storage with the internet small computer system interface iscsi protocol using netapp volumes for your sql server storage provides access to a high performance fully managed storage service with advanced data management features such as snapshots and cloning objectives this tutorial guides you through the following tasks provision compute engine vms for sql server create netapp volumes block storage volumes configure sql server on each node configure windows server failover clustering wsfc create and configure a sql server always on availability group costs this tutorial uses the following billable components of google cloud compute engine netapp volumes to generate a cost estimate based on your projected usage use the pricing calculator before you begin before you begin ensure you have the following in the google cloud console on the project selector page select or create a google cloud project roles required to select or create a project select a project selecting a project doesn t require a specific iam role you can select any project that you ve been granted a role on create a project to create a project you need the project creator role roles resourcemanager projectcreator which contains the resourcemanager projects create permission learn how to grant roles note if you don t plan to keep the resources that you create in this procedure create a project instead of selecting an existing project after you finish these steps you can delete the project removing all resources associated with the project go to project selector verify that billing is enabled for your google cloud project a google cloud project with administrative permissions for compute engine networking identity and access management and cloud storage a vpc network with a subnet in your target region active directory and dns services established within the region an active directory user with permissions to join computers to the domain and access vms using rdp ensure that vpc firewall rules allow traffic between nodes for iscsi tcp 3260 wsfc udp tcp 3343 sql server tcp 1433 sql server ag endpoints tcp 5022 smb tcp 445 and rpc tcp 135 tcp 49152 65535 enable the netapp volumes api in the google cloud console activate cloud shell activate cloud shell configure domain accounts configure two active directory accounts for sql server installation account an account with domain administrator privileges for example domain domainadmin to sign in to vms and configure the cluster and availability group service account an account for example domain sqlsvc for the sql server service and sql agent service on both sql server vms create compute engine vms for sql server create two compute engine instances sqlnode1 and sqlnode2 running sql server 2022 enterprise on windows server 2025 in the google cloud console go to the create an instance page go to create an instance for name enter sqlnode1 in the machine configuration section select general purpose and then do the following in the series list select n4 in the machine type list select n4 highmem 8 8vcpu 64 gb memory select the region and zone where you configured your vpc in the boot disk section click change and then do the following on the public images tab select sql server on windows server from the operating system list from the version list select sql server 2022 enterprise on windows server 2025 datacenter in the boot disk type list select hyperdisk balanced set the size gb to 50 to save the boot disk configuration click select expand the advanced options section then expand networking for network interfaces select the vpc and subnet for your project in the network interface card type list select gvnic for network service tier select premium click create repeat these steps to create a second instance named sqlnode2 join servers to the domain and prepare for clustering perform these steps on both sqlnode1 and sqlnode2 connect to the vm using a local administrator account in the server manager select local server select the workgroup link in the computer name section select change select the domain checkbox enter your domain name for example cvsdemo internal and click ok in the windows security dialog enter the credentials for your domain administrator account and click ok when the welcome message appears for the domain complete the following steps a click ok b click close and then select restart now after the vm restarts connect to it using your domain administrator account add the domain sqlsvc account to the local administrators group on the vm you can use the following powershell command add localgroupmember group administrators member domain sqlsvc open powershell as an administrator and run the following commands to install required windows features install failover clustering and tools install windowsfeature failover clustering rsat clustering powershell rsat clustering cmdinterface includeallsubfeature includemanagementtools install and enable mpio for iscsi install windowsfeature name multipath io enable msdsmautomaticclaim bustype iscsi install net and other sql prereqs install windowsfeature net framework 45 core net framework 45 features install windowsfeature rsat ad powershell to get the iscsi qualified name iqn for the vm run iscsicpl exe go to the configuration tab and copy the initiator name alternatively run the following powershell command get initiatorport select object nodeaddress record the iqn for both sqlnode1 and sqlnode2 you need these in the next section example iqn 1991 05 com microsoft sqlnode1 cvsdemo internal create netapp volumes block storage volumes follow these steps to create a host group storage pool and iscsi volumes create a host group a host group ensures that only the specified hosts your sql server vms can access the volumes you create in cloud shell create a host group containing the iqns of sqlnode1 and sqlnode2 gcloud netapp host groups create host_group_name location location type iscsi_initiator hosts sqlnode1_iqn sqlnode2_iqn os type windows description sql server ag nodes replace the following information host_group_name the name for the host group for example sql ag hosts location the region for your host group for example us west1 sqlnode1_iqn the iqn of sqlnode1 sqlnode2_iqn the iqn of sqlnode2 provision a storage pool in cloud shell create a storage pool for your volumes gcloud netapp storage pools create pool_name project project_id location zone service level flex type unified capacity 1024 total throughput 64 total iops 1024 network name vpc_name psa range psa_range_name replace the following information pool_name the name for the storage pool for example sql pool project_id your google cloud project id zone the zone for your storage pool which must match the zone of your vms for example us west1 b vpc_name the name of your vpc network psa_range_name the name of the allocated range of your private services access connection create volumes create separate volumes for sql server data logs tempdb and backups for each node in cloud shell run the following command for each volume you need to create gcloud netapp volumes create volume_name project project_id location zone storage pool pool_name capacity 200 protocols iscsi block devices name volume_name host groups projects project_id locations location hostgroups host_group_name os type windows snapshot directory false replace volume_name with a unique name for each volume for this two node tutorial you need to run the command eight times to create volumes for data logs tempdb and backups for each node for example sqlnode1 data sqlnode1 log sqlnode1 temp sqlnode1 backup sqlnode2 data sqlnode2 log sqlnode2 temp and sqlnode2 backup mount iscsi volumes on each sql vm for each vm sqlnode1 and sqlnode2 mount the volumes you created for that specific node in the google cloud console go to the volumes page for netapp volumes go to volumes select a volume assigned to the node you are configuring note the target portal ip addresses listed in the iscsi target details section you need these addresses to connect to the volume on the vm open powershell as an administrator and run the following command replacing the example ips with the target portal ips for your volume 10 165 128 216 10 165 128 217 foreach object new iscsitargetportal targetportaladdress _ run iscsicpl exe to open iscsi initiator properties go to the targets tab select one of your volume targets from the list and click connect in the connect to target dialog select enable multi path and click advanced in the advanced settings dialog local adapter select microsoft iscsi initiator initiator ip select an ip address on the vm target portal ip select one of the portal ips you discovered click ok in the connect to target dialog click ok repeat the connection steps for all targets associated with the vm to configure mpio for iscsi devices open mpio properties from control panel or server manager click the discover multi paths tab select add support for iscsi devices and click add reboot the vm if prompted after rebooting open device manager and expand disk drives your iscsi disk appears as a multi path device open disk management compmgmt msc for each new disk bring the disk online initialize the disk gpt create a new volume assign a drive letter for example d for data e for logs f for backups g for tempdb and format it using ntfs with an allocation unit size of 64k create the directory structure for sql server on the newly formatted drives for example paths d mssql data e mssql log f mssql backup g mssql temp paths foreach object new item itemtype directory path _ force configure sql server perform these steps on both sqlnode1 and sqlnode2 after moun...
|
