Microsoft Command Line Utilities 11 for SQL Server<\/a><\/p>\nAnpassen der Einstellung:<\/h1>\nHerstellen der Verbindung f\u00fcr WSUS 4:<\/h2>\n
SQLCMD -E -S \\\\.\\pipe\\Microsoft##WID\\tsql\\query<\/p>\n
Herstellen der Verbindung f\u00fcr WSUS 3:<\/h2>\n
SQLCMD -E -S \\\\.\\pipe\\mssql$microsoft##ssee\\sql\\query<\/p>\n
Eingeben am Prompt:<\/h2>\n
exec sp_configure ’show advanced option‘, ‚1‘;
\nreconfigure;<\/p>\n
Um die aktuelle Einstellung zu pr\u00fcfen:<\/h2>\n
exec sp_configure;
\ngo<\/p>\n
Um die Einstellung anzupassen:<\/h2>\n
exec sp_configure ‚max server memory‘, 2048;
\nreconfigure with override;
\ngo<\/p>\n
Quit um Eingabe zu beenden.<\/p>\n
SQL-Server Dienst neu starten nicht vergessen!<\/strong><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Allgemeine Informationen: Viele WSUS Standardinstallationen verwenden die Windows Internal Database. Bei Servern mit wenig Speicher kann es schon zu Performance Problemen f\u00fchren, wenn der SQL Server keine Speicherobergrenze gesetzt bekommt. Die Anpassung der Windows Internal Database muss auf dem Server … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[16],"tags":[209,212,210,211,17],"class_list":["post-1205","post","type-post","status-publish","format-standard","hentry","category-wsus","tag-internal-database","tag-limit","tag-max","tag-server-memory","tag-wsus-2"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p1ByMg-jr","_links":{"self":[{"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1205"}],"version-history":[{"count":1,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1205\/revisions"}],"predecessor-version":[{"id":1206,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1205\/revisions\/1206"}],"wp:attachment":[{"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1205"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.schertel.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}