Meta tags:

Headings (most frequently used words):

best, practices, for, sql, server, and, workload, manager, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, severity, levels, workloads, products, pricing, support, resources, engage,

Text of the page (most frequently used words):
the (53), for (40), and (38), sql (34), best (23), #server (23), overview (20), google (19), #practices (19), cloud (18), more (17), medium (16), performance (16), projects (16), locations (16), workload (14), list (14), see (13), information (13), manager (13), get (12), your (11), with (9), log (9), delete (9), resources (8), files (8), disk (8), thumb (7), that (7), data (7), you (6), setting (6), set (6), number (6), vms (6), create (6), code (5), system (5), resource (5), practice (5), severity (5), workloads (5), which (5), local (5), memory (5), compute (5), enable (5), reference (5), down (4), this (4), backup (4), stability (4), virtual (4), file (4), max (4), high (4), ssd (4), failover (4), clustering (4), tools (4), management (4), application (4), deployments (4), evaluations (4), samples (3), need (3), content (3), run (3), how (3), console (3), consider (3), solutions (3), optimal (3), agent (3), core (3), industry (3), one (3), costs (3), regular (3), backups (3), new (3), use (3), tables (3), default (3), power (3), profile (3), recommend (3), documentation (3), persistent (3), buffer (3), pool (3), extension (3), access (3), storage (3), evaluating (3), resolve (3), product (3), types (3), rest (3), executions (3), 한국어 (2), 日本語 (2), português (2), brasil (2), français (2), español (2), américa (2), latina (2), deutsch (2), english (2), sign (2), action (2), terms (2), site (2), about (2), youtube (2), support (2), pricing (2), products (2), understand (2), other (2), last (2), updated (2), 2026 (2), utc (2), licensed (2), under (2), are (2), details (2), license (2), send (2), feedback (2), when (2), their (2), current (2), level (2), each (2), non (2), icon (2), following (2), table (2), levels (2), might (2), impact (2), disaster (2), recovery (2), not (2), threads (2), per (2), then (2), size (2), cores (2), further (2), possible (2), using (2), consult (2), disabling (2), smt (2), licensing (2), monitor (2), prevent (2), fragmentation (2), fixed (2), ssds (2), tempdb (2), compressed (2), perform (2), faster (2), matches (2), cpus (2), works (2), degree (2), parallelism (2), match (2), instead (2), available (2), physical (2), instance (2), secondary (2), enabling (2), engine (2), lets (2), push (2), clean (2), pages (2), them (2), insights (2), unplanned (2), sdk (2), languages (2), frameworks (2), infrastructure (2), usage (2), security (2), observability (2), monitoring (2), networking (2), migration (2), distributed (2), hybrid (2), multicloud (2), databases (2), analytics (2), pipelines (2), hosting (2), development (2), cancel (2), operations (2), actuations (2), discoveredprofiles (2), cross (2), guides (2), technology (2), areas (2), close (2), subscribe, newsletter, our, third, decade, climate, join, manage, cookies, privacy, tech, twitter, events, blog, engage, training, certification, architecture, center, getting, started, github, status, release, notes, community, forums, contact, sales, marketplace, all, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, hard, hardtounderstand, incorrect, sample, incorrectinformationorsamplecode, missing, missingtheinformationsamplesineed, otherdown, tell, except, otherwise, noted, page, java, registered, trademark, oracle, its, affiliates, developers, policies, apache, creative, commons, attribution, evaluation, evaluates, comparing, state, doesn, comply, selected, assigns, indicates, far, out, compliance, marks, compliant, explains, these, icons, corresponding, recommendations, modifying, adhere, service, protection, detected, tco, most, right, shape, according, requirements, controlling, custom, visible, technical, account, reduces, vcpus, half, reduce, agreement, disable, simultaneous, multithreading, cost, optimization, optimizing, growth, take, optimize, autogrowth, amount, schedule, instances, store, windows, paging, compressing, could, make, parallel, query, processing, recommends, good, value, configure, balanced, place, separate, drives, preconfigured, image, comes, everything, installed, boot, mounts, drive, attaching, moving, move, indexes, fragmented, scheduling, defrag, jobs, avoid, index, add, flag, metadata, wsfc, true, formatting, allocation, unit, read, write, extents, efficiently, increases, format, disks, feature, dropping, along, same, lines, say, gives, than, going, fetch, swapping, backing, taking, database, careful, consume, too, many, iops, stage, bucket, regularly, name, description, category, note, must, host, shows, although, there, resolution, needed, reviewing, can, provide, useful, informational, essential, behavior, low, earliest, convenience, suboptimal, supportability, during, next, planned, maintenance, window, degraded, soon, availability, integrity, due, risk, outage, reliability, outages, unsupported, configuration, critical, recommendation, impacts, document, lists, supports, running, learn, save, categorize, based, preferences, stay, organized, collections, home, audit, logging, quotas, limits, listoperationsresponse, listoperationsrequest, listlocationsresponse, listlocationsrequest, getoperationrequest, getlocationrequest, deleteoperationrequest, canceloperationrequest, shared, v1alpha, cloudresource, rules, writeinsight, scannedresources, results, patch, health, red, hat, openshift, sap, redis, mysql, authenticate, start, free, skip, main,

Text of the page (random words):
workload manager best practices for sql server google cloud documentation skip to main content technology areas close 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 cross product tools close access and resources management costs and usage management infrastructure as code sdk languages frameworks and tools console english deutsch español américa latina français português brasil 中文 简体 日本語 한국어 sign in workload manager start free overview guides reference resources technology areas more overview guides reference resources cross product tools more console workload manager authenticate to workload manager best practices reference google cloud best practices best practices for mysql best practices for redis best practices for sap best practices for sql server best practices for red hat openshift rest reference overview v1 rest resources projects locations overview get list projects locations deployments overview create delete get list projects locations deployments actuations overview create delete get list projects locations discoveredprofiles overview get list projects locations discoveredprofiles health overview get projects locations evaluations overview create delete get list patch projects locations evaluations executions overview delete get list run projects locations evaluations executions results overview list projects locations evaluations executions scannedresources overview list projects locations insights overview delete writeinsight projects locations operations overview cancel delete get list projects locations rules overview list types cloudresource v1alpha rest resources projects locations overview get list projects locations deployments overview create delete get list projects locations deployments actuations overview create delete get list projects locations operations overview cancel delete get list shared types types canceloperationrequest deleteoperationrequest getlocationrequest getoperationrequest listlocationsrequest listlocationsresponse listoperationsrequest listoperationsresponse quotas and limits monitor audit logging 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 workload manager reference send feedback workload manager best practices for sql server stay organized with collections save and categorize content based on your preferences this document lists the best practices that workload manager supports for evaluating sql server workloads running on google cloud to learn about workload manager see product overview severity levels when you run an evaluation workload manager evaluates resources by comparing their current state with best practices if a resource doesn t comply with a selected best practice workload manager assigns it a severity level that indicates how far the resource is out of compliance the google cloud console marks each non compliant resource with an icon the following table explains these icons their corresponding severity levels how the current resource setting might impact your workload and recommendations for modifying the resource to adhere to best practices icon severity level impacts recommendation critical system reliability unplanned outages unsupported configuration resolve as soon as possible to prevent an impact on system availability and data integrity due to a high risk of an unplanned outage high degraded performance system stability resolve during the next planned maintenance window medium suboptimal performance supportability resolve at your earliest convenience low informational non essential behavior although there s no resolution needed reviewing this best practice can provide useful insights best practices for sql server workloads the following table shows the workload manager best practices for evaluating sql server workloads that run on google cloud note that to enable workload manager for evaluating your sql server workloads you must set up google cloud s agent for sql server on the host vms category best practice name and description severity stability sql perform backup regularly when taking regular database backups be careful not to consume too many persistent disk iops use the local ssd to stage your backups and then push them to a cloud storage bucket for more information see backing up in best practices for sql server vms medium performance sql enable the buffer pool extension the buffer pool extension feature lets you push clean pages to a local ssd instead of dropping them this works along the same lines as virtual memory which is to say by swapping and gives you access to the clean pages on the local ssd which is faster than going to the regular disk to fetch the data for more information see enabling the buffer pool extension in best practices for sql server vms medium performance sql format secondary disks formatting a disk with a 64 kb allocation unit lets sql server read and write extents more efficiently which increases the i o performance of the disk medium failover clustering sql enable failover clustering to enable failover clustering in the compute engine agent you need to add the flag enable wsfc true to your vm metadata for more information see enabling failover clustering in compute engine medium performance sql avoid index fragmentation if one or more indexes are 95 fragmented we recommend scheduling defrag jobs medium performance sql move data files and log files to a new disk by default the preconfigured image for sql server comes with everything installed on the boot persistent disk which mounts as the c drive consider attaching a secondary ssd persistent disk and moving the log files and data files to the new disk for more information see place data and log files on separate drives in sql server documentation medium stability sql match max server memory setting with available physical memory on the instance we recommend that the max server memory setting matches the available physical memory on the instance medium performance sql set the power profile to high performance to configure sql server for optimal performance on google cloud we recommend that you set the power profile to high performance instead of balanced for more information see setting the power profile medium performance sql match max degree of parallelism to the number of cpus on the server google cloud recommends that the default setting for max degree of parallelism matches the number of cpus on the server in practice 8 works as a good default value for more information see parallel query processing in best practices for sql server vms medium performance sql use compressed tables compressing tables could make your system perform faster for more information see using compressed tables in best practices for sql server vms medium performance sql use local ssds for tempdb create new sql server instances with one or more local ssds to store the tempdb and windows paging files medium performance sql set log file to fixed amount and schedule regular backups consider disabling autogrowth and setting your log file to a fixed size medium performance sql optimize virtual log files monitor virtual log file growth and take action to prevent log file fragmentation for more information see optimizing virtual log files in best practices for sql server vms medium cost optimization sql disable simultaneous multithreading smt disabling smt reduces the number of vcpus for each core by half which might reduce your licensing costs for more information consult your licensing agreement an industry best practice for an optimal tco for most sql server workloads is to set the number of threads per core to one and then to right size the vm shape according to the workload requirements controlling the number of cores is further possible using custom visible cores consult your technical account manager for further details for more information see how to set the number of threads per core medium stability sql google cloud backup and disaster recovery agent not detected consider google s backup and disaster recovery solutions for optimal protection for more information see backup and dr service medium send feedback except as otherwise noted the content of this page is licensed under the creative commons attribution 4 0 license and code samples are licensed under the apache 2 0 license for details see the google developers site policies java is a registered trademark of oracle and or its affiliates last updated 2026 07 10 utc need to tell us more easy to understand easytounderstand thumb up solved my problem solvedmyproblem thumb up other otherup thumb up hard to understand hardtounderstand thumb down incorrect information or sample code incorrectinformationorsamplecode thumb down missing the information samples i need missingtheinformationsamplesineed thumb down other otherdown thumb down last updated 2026 07 10 utc products and pricing see all products google cloud pricing google cloud marketplace contact sales support community forums support release notes system status resources github getting started with google cloud code samples cloud architecture center training and certification engage blog events x twitter google cloud on youtube google cloud tech on youtube about google privacy site terms google cloud terms manage cookies our third decade of climate action join us sign up for the google cloud newsletter subscribe english deutsch español américa latina français português brasil 中文 简体 日本語 한국어