Public/nlp-synonyms.ps1
|
# ============================================================================= # nlp-synonyms.ps1 - Umgangssprachliche Stichworte -> Funktionsnamen. # Boost-Tabelle fuer die Klartextsuche in Show-sqmToolGui: Wer nicht weiss, wie # eine Funktion heisst, tippt z.B. "Datenbank restoren" oder "Platte ist voll" # ins Suchfeld statt eines Funktionsnamens/Wildcards. Ohne Eintrag hier greift # trotzdem die Volltextsuche ueber Synopsis/Description/Parameter - diese Tabelle # faengt nur Formulierungen ab, die in der Hilfe nicht woertlich vorkommen # (z.B. Konjugationen wie "restoren" statt "Restore"). # # Bei neuen Funktionen oder haeufig falsch gesuchten Begriffen hier ergaenzen. # Format: 'stichwort oder phrase' = @('Funktionsname1', 'Funktionsname2', ...) # ============================================================================= $sqmNlpSynonyms = @{ 'restoren' = @('Invoke-sqmRestoreDatabase') 'wiederherstellen' = @('Invoke-sqmRestoreDatabase') 'zurücksichern' = @('Invoke-sqmRestoreDatabase') 'zuruecksichern' = @('Invoke-sqmRestoreDatabase') 'sichern' = @('Invoke-sqmUserDatabaseBackup', 'New-sqmOlaUsrDbBackupJob', 'New-sqmOlaSysDbBackupJob', 'New-sqmBackupMaintenanceJob') 'backup machen' = @('Invoke-sqmUserDatabaseBackup') 'backup kontrolle' = @('Test-sqmBackupStatus') 'backup pruefen' = @('Test-sqmBackupStatus', 'Test-sqmBackupIntegrity') 'backup status' = @('Test-sqmBackupStatus') 'letztes backup' = @('Test-sqmBackupStatus', 'Get-sqmDatabaseHealth') 'ohne backup' = @('Test-sqmBackupStatus') 'rpo' = @('Test-sqmBackupStatus') 'ausschlussliste' = @('Get-sqmBackupExcludeReport', 'Show-sqmBackupExcludeForm') 'exclude tabelle' = @('Get-sqmBackupExcludeReport', 'Show-sqmBackupExcludeForm') 'backup ausschluss' = @('Get-sqmBackupExcludeReport', 'Show-sqmBackupExcludeForm') 'nicht gesichert' = @('Get-sqmBackupExcludeReport', 'Test-sqmBackupStatus') 'ntfs rechte' = @('Grant-sqmVolumeAccess', 'Copy-sqmNTFSPermissions') 'ordnerrechte' = @('Grant-sqmVolumeAccess', 'Copy-sqmNTFSPermissions') 'authenticated users' = @('Grant-sqmVolumeAccess') 'vererbung' = @('Grant-sqmVolumeAccess') 'icacls' = @('Grant-sqmVolumeAccess') 'platte voll' = @('Get-sqmDiskSpaceReport') 'speicherplatz' = @('Get-sqmDiskSpaceReport') 'festplatte' = @('Get-sqmDiskSpaceReport', 'Get-sqmDiskInfoByDriveLetter', 'Get-sqmDiskPartitionMap') 'langsam' = @('Get-sqmLongRunningQueries', 'Get-sqmWaitStatistics', 'Invoke-sqmPerfBaseline') 'hängt' = @('Get-sqmBlockingReport', 'Get-sqmLongRunningQueries') 'haengt' = @('Get-sqmBlockingReport', 'Get-sqmLongRunningQueries') 'blockiert' = @('Get-sqmBlockingReport', 'Get-sqmBlockingHistory') 'blockierung' = @('Get-sqmBlockingReport', 'Get-sqmBlockingHistory') 'vorfall' = @('Get-sqmBlockingHistory') 'historie' = @('Get-sqmBlockingHistory') 'deadlock' = @('Get-sqmDeadlockReport') 'umschalten' = @('Invoke-sqmFailover') 'ausfallsicherheit' = @('Get-sqmAlwaysOnHealthReport', 'Invoke-sqmFailover') 'passwort' = @('New-sqmRandomSaPassword', 'Set-sqmSqlPolicyState') 'zertifikat' = @('Get-sqmCertificateReport', 'Install-sqmCertificate', 'New-sqmCertificateRequest') 'fragmentiert' = @('Get-sqmIndexFragmentation') 'inventar' = @('Invoke-sqmInstanceInventory') 'wer ist drin' = @('Get-sqmSysadminAccounts', 'Get-sqmLoginSettings') 'gesundheit' = @('Get-sqmDatabaseHealth', 'Get-sqmSQLInstanceCheck') 'wer ist aktiv' = @('Get-sqmWhoIsActive', 'Show-sqmWhoIsActiveMonitor') 'aktive sessions' = @('Get-sqmWhoIsActive', 'Show-sqmWhoIsActiveMonitor') 'whoisactive' = @('Get-sqmWhoIsActive', 'Show-sqmWhoIsActiveMonitor') 'zurueckschwenken' = @('Invoke-sqmPreferredPrimaryCheck', 'New-sqmPreferredPrimaryJob') 'zurückschwenken' = @('Invoke-sqmPreferredPrimaryCheck', 'New-sqmPreferredPrimaryJob') 'bevorzugter knoten' = @('Invoke-sqmPreferredPrimaryCheck', 'New-sqmPreferredPrimaryJob') 'falscher knoten' = @('Invoke-sqmPreferredPrimaryCheck', 'Get-sqmAlwaysOnHealthReport') 'patchwochenende' = @('Invoke-sqmPreferredPrimaryCheck', 'Get-sqmAlwaysOnFailoverHistory') 'health report' = @('Invoke-sqmHealthReport') 'gesamtbericht' = @('Invoke-sqmHealthReport') 'gesundheitscheck' = @('Invoke-sqmHealthReport', 'Get-sqmSQLInstanceCheck') 'psblitz' = @('Invoke-sqmHealthReport') 'offene transaktion' = @('Invoke-sqmHealthReport') 'plan cache' = @('Get-sqmPlanCacheReport', 'Get-sqmPlanInsights') 'teure abfragen' = @('Get-sqmPlanCacheReport', 'Invoke-sqmQueryStore') 'top queries' = @('Get-sqmPlanCacheReport', 'Invoke-sqmQueryStore') 'blitzcache' = @('Get-sqmPlanCacheReport') 'ausfuehrungsplan' = @('Get-sqmPlanCacheReport', 'Get-sqmPlanInsights') 'ungenutzte indizes' = @('Get-sqmIndexUsageReport') 'doppelte indizes' = @('Get-sqmIndexUsageReport') 'unused index' = @('Get-sqmIndexUsageReport') 'heap' = @('Get-sqmIndexUsageReport') 'blitzindex' = @('Get-sqmIndexUsageReport', 'Get-sqmMissingIndexes') 'index optimize' = @('Invoke-sqmIndexOptimize') 'indexoptimize' = @('Invoke-sqmIndexOptimize') 'index rebuild' = @('Invoke-sqmIndexOptimize') 'index reorganize' = @('Invoke-sqmIndexOptimize') 'indizes neu aufbauen' = @('Invoke-sqmIndexOptimize') 'indexwartung' = @('Invoke-sqmIndexOptimize', 'Get-sqmIndexFragmentation') 'fragmentierung beheben' = @('Invoke-sqmIndexOptimize') 'statistiken aktualisieren' = @('Invoke-sqmUpdateStatistics') 'update statistics' = @('Invoke-sqmUpdateStatistics') 'statistik' = @('Invoke-sqmUpdateStatistics') 'vlf' = @('Invoke-sqmLogShrink') 'vlfs' = @('Invoke-sqmLogShrink') 'log schrumpfen' = @('Invoke-sqmLogShrink') 'log verkleinern' = @('Invoke-sqmLogShrink') 'log voll' = @('Invoke-sqmLogShrink') 'log waechst' = @('Invoke-sqmLogShrink') 'log_reuse_wait' = @('Invoke-sqmLogShrink') 'io latenz' = @('Get-sqmFileLatencyReport') 'langsame platte' = @('Get-sqmFileLatencyReport', 'Get-sqmDiskSpaceReport') 'storage langsam' = @('Get-sqmFileLatencyReport') 'file latency' = @('Get-sqmFileLatencyReport') 'standard job' = @('Install-sqmStandardJob') 'standardjob' = @('Install-sqmStandardJob') 'login sync job' = @('Install-sqmStandardJob', 'New-sqmAutoLoginSyncJob') 'loginsync' = @('Install-sqmStandardJob', 'Sync-sqmLoginsToAlwaysOn') 'job installieren' = @('Install-sqmStandardJob', 'New-sqmAgentCommandJob') 'wer ruft auf' = @('Find-sqmAgentJobReference', 'Find-sqmDatabaseObject') 'ruft prozedur auf' = @('Find-sqmAgentJobReference') 'welcher job' = @('Find-sqmAgentJobReference', 'Get-sqmAgentJobScheduleReport') 'wird das benutzt' = @('Find-sqmAgentJobReference', 'Find-sqmDatabaseObject') 'prozedur loeschen' = @('Find-sqmAgentJobReference') 'prozedur löschen' = @('Find-sqmAgentJobReference') 'datenbank abschalten' = @('Find-sqmAgentJobReference', 'Get-sqmLinkedServerUsage') 'wer leert die tabelle' = @('Find-sqmAgentJobReference') 'ssis umziehen' = @('Invoke-sqmSsisCatalogMigration') 'ssisdb umziehen' = @('Invoke-sqmSsisCatalogMigration') 'katalog umziehen' = @('Invoke-sqmSsisCatalogMigration') 'ssis auf neuen server' = @('Invoke-sqmSsisCatalogMigration') 'ssis upgrade' = @('Invoke-sqmSsisCatalogMigration', 'Test-sqmSSISPackageCompatibility') 'pakete laufen nicht mehr' = @('Invoke-sqmSsisCatalogMigration', 'Find-sqmAgentJobReference') 'hauptschlüssel' = @('Invoke-sqmSsisCatalogMigration') 'master key' = @('Invoke-sqmSsisCatalogMigration') 'datei verschieben' = @('Move-sqmDatabaseFile') 'dateien verschieben' = @('Move-sqmDatabaseFile') 'mdf verschieben' = @('Move-sqmDatabaseFile') 'ldf verschieben' = @('Move-sqmDatabaseFile') 'tempdb verschieben' = @('Move-sqmDatabaseFile', 'Get-sqmTempDbRecommendation') 'tempdb umziehen' = @('Move-sqmDatabaseFile') 'auf anderes laufwerk' = @('Move-sqmDatabaseFile') 'laufwerk wechseln' = @('Move-sqmDatabaseFile') 'datenbank umziehen' = @('Move-sqmDatabaseFile', 'Invoke-sqmRestoreDatabase') 'log auf eigene platte' = @('Move-sqmDatabaseFile') 'platte zu klein' = @('Move-sqmDatabaseFile', 'Get-sqmDiskSpaceReport') 'verwaiste user' = @('Invoke-sqmDatabaseStandardization') 'orphaned user' = @('Invoke-sqmDatabaseStandardization') 'user ohne login' = @('Invoke-sqmDatabaseStandardization') 'kompatibilitaet' = @('Invoke-sqmDatabaseStandardization') 'kompatibilitätsstufe' = @('Invoke-sqmDatabaseStandardization') 'compatibility level' = @('Invoke-sqmDatabaseStandardization') 'recovery time' = @('Invoke-sqmDatabaseStandardization') 'target recovery' = @('Invoke-sqmDatabaseStandardization') 'nach migration aufraeumen' = @('Invoke-sqmDatabaseStandardization') 'datenbank standardisieren' = @('Invoke-sqmDatabaseStandardization') 'ssrs umziehen' = @('Invoke-sqmSsrsMigration') 'reports umziehen' = @('Invoke-sqmSsrsMigration') 'berichte umziehen' = @('Invoke-sqmSsrsMigration') 'reportserver migration' = @('Invoke-sqmSsrsMigration') 'report server migrieren' = @('Invoke-sqmSsrsMigration') 'reporting services migration' = @('Invoke-sqmSsrsMigration', 'Install-sqmSsrsReportServer') 'datenquelle umhaengen' = @('Invoke-sqmSsrsMigration') 'rdl kopieren' = @('Invoke-sqmSsrsMigration') } |