{"id":57,"count":1,"description":"<h1>Gestionnaire de diagnostic SQL<\/h1>\r\n<h4>Identifier et r\u00e9soudre les probl\u00e8mes du serveur SQL avant qu'ils ne surviennent<\/h4>\r\n<ul class=\"checkmark-list\">\r\n \t<li>Surveiller et g\u00e9rer les serveurs SQL \u00e0 l'\u00e9chelle de l'entreprise<\/li>\r\n \t<li>Identifier et corriger les goulets d'\u00e9tranglement en mati\u00e8re de performances<\/li>\r\n \t<li>Analyser les performances dans le temps<\/li>\r\n \t<li>Diagnostiquer et r\u00e9soudre les probl\u00e8mes \u00e0 partir d'un ordinateur ou d'un appareil mobile<\/li>\r\n \t<li>Aucun agent ou objet de base de donn\u00e9es n'est requis sur les serveurs surveill\u00e9s<\/li>\r\n<\/ul>","link":"https:\/\/www.barnsten.com\/fr\/product-category\/idera-tools\/sql-diagnostic-manager\/","name":"SQL Diagnostic Manager","slug":"gestionnaire-de-diagnostic-sql","taxonomy":"product_cat","parent":114,"meta":{"order":["95"],"display_type":[""],"thumbnail_id":["0"],"product_count_product_cat":["1"],"bottom_description":["<h2>Enterprise Overview<\/h2>\r\nWith SQL diagnostic manager, you can monitor and manage your entire SQL Server environment from a single console. Once SQL diagnostic manager alerts you of a problem you can quickly and easily see the cause of the alert, diagnose, and fix the problem.\r\n\r\n&nbsp;\r\n<h2>Track Query Performance Over Time<\/h2>\r\nThe Query History view enables you to see how a particular query has performed over time. Query performance can be viewed by duration, reads, writes, etc.\r\n\r\n&nbsp;\r\n<h2>Mobile SQL Server access while you\u2019re on the go<\/h2>\r\nManaging servers doesn\u2019t mean you have to be tied to your desk. When on the go, you need to be able to gain quick access to your SQL Server environment. SQL diagnostic manager mobile enables you to view the overall status of all of the SQL Servers in your environment, drill-down to view details on sessions, jobs, databases, as well as take actions like kill a session, start\/stop a job or run a query.\r\n\r\n&nbsp;\r\n<h2>Query Performance Tuning<\/h2>\r\nThe Queries view enables you to do query monitoring and easily identify potentially poor performing queries, such as long or most frequent queries or queries consuming unusually high CPU or I\/O.\r\n\r\n&nbsp;\r\n<h2>Easily diagnose historical performance issues<\/h2>\r\nThe Server Overview displays an overview of a SQL Server's real-time or historical performance metrics, including resources, locks, blocks and session information.\r\n\r\nThe History Browser enables the server state to be shown as it looked at a historical point-in-time to aid in problem troubleshooting and resolution.\r\n\r\n&nbsp;\r\n<h2>Identify Server Resource Bottlenecks<\/h2>\r\nThe Server Waits view help quickly and easily identify the overall system resource bottleneck. It\u2019s easy to see which wait stat resource the server is waiting on the most in order to identify the biggest resource bottleneck.\r\n\r\n&nbsp;\r\n<h2>Identify Query Resource Bottlenecks<\/h2>\r\nThe Query Waits view help quickly and easily identify the statements, applications, and databases that are waiting the longest and identifies what wait stat (resource) they are waiting on and for how long. This allows you to easily identify the highest priority item for optimization.\r\n\r\n&nbsp;\r\n<h2>Monitor SQL Server Mirroring Performance<\/h2>\r\nSQL diagnostic manager has the ability to monitor state and performance of your mirroring environment and send alerts whenever the state of your mirrored environment changes or performance is being adversely affected.\r\n\r\n&nbsp;\r\n<h2>Monitor SQL Server Deadlocks<\/h2>\r\nThe ability to detect previously deadlocked sessions and diagnose the causes is very important in SQL Server environments. SQL diagnostic manager will alert you on deadlocks that occurred in SQL 2005\/2008 environments, and then let you see the deadlocked details and easily export the details to a deadlock XML (.xdl) file.\r\n\r\n&nbsp;\r\n<h2>Monitor tempdb Performance<\/h2>\r\nThe Tempdb Summary view can be used to identify current activity affecting tempdb as well as recent trends of file sizes, object types and sizes, page latch contention, and version store generation and cleanup rates. In the real time view a user can trace or kill a running process, and with full history browser support users may easily drill through to view locks and query history from any tempdb affecting session detected in the past 30 days. Associated alerts inform administrators of out-of-control activity, including long running version store transactions and sessions utilizing excessive space in tempdb, allowing early and immediate intervention.\r\n\r\n&nbsp;\r\n<h2>SQL Server Performance Reporting<\/h2>\r\nSQL diagnostic manager 7.1 has a new reporting interface that provides a series of new enterprise summary, server summary, alerts, mirroring, and forecasting reports. These reports can be easily view in the SQLdm Console or deployed and scheduled to SQL Server Reporting Services using the SQLdm reporting interface."],"_bottom_description":["field_5d026ca35467a"]},"menu_order":95,"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Diagnostic Manager - Idera Tools - Barnsten.com<\/title>\n<meta name=\"description\" content=\"SQL diagnostic manager for fast performance monitorig on all your SQL Servers\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.barnsten.com\/fr\/categorie-produit\/outils-idera\/gestionnaire-de-diagnostic-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Diagnostic Manager - Idera Tools - Barnsten.com\" \/>\n<meta property=\"og:description\" content=\"SQL diagnostic manager for fast performance monitorig on all your SQL Servers\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.barnsten.com\/fr\/categorie-produit\/outils-idera\/gestionnaire-de-diagnostic-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Barnsten.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"CollectionPage\",\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/product-category\\\/idera-tools\\\/sql-diagnostic-manager\\\/\",\"url\":\"https:\\\/\\\/www.barnsten.com\\\/product-category\\\/idera-tools\\\/sql-diagnostic-manager\\\/\",\"name\":\"SQL Diagnostic Manager - Idera Tools - Barnsten.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#website\"},\"description\":\"SQL diagnostic manager for fast performance monitorig on all your SQL Servers\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/product-category\\\/idera-tools\\\/sql-diagnostic-manager\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/product-category\\\/idera-tools\\\/sql-diagnostic-manager\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.barnsten.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Idera Tools\",\"item\":\"https:\\\/\\\/www.barnsten.com\\\/product-category\\\/idera-tools\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Diagnostic Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#website\",\"url\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/\",\"name\":\"Barnsten.com\",\"description\":\"Development Software &amp; Database tools\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#organization\",\"name\":\"Barnsten B.V.\",\"url\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.barnsten.com\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/Barnsten-logo-oranje@3x.png\",\"contentUrl\":\"https:\\\/\\\/www.barnsten.com\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/Barnsten-logo-oranje@3x.png\",\"width\":406,\"height\":150,\"caption\":\"Barnsten B.V.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.barnsten.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Diagnostic Manager - Idera Tools - Barnsten.com","description":"SQL diagnostic manager pour la surveillance rapide des performances de tous vos serveurs SQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.barnsten.com\/fr\/categorie-produit\/outils-idera\/gestionnaire-de-diagnostic-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"SQL Diagnostic Manager - Idera Tools - Barnsten.com","og_description":"SQL diagnostic manager for fast performance monitorig on all your SQL Servers","og_url":"https:\/\/www.barnsten.com\/fr\/categorie-produit\/outils-idera\/gestionnaire-de-diagnostic-sql\/","og_site_name":"Barnsten.com","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.barnsten.com\/product-category\/idera-tools\/sql-diagnostic-manager\/","url":"https:\/\/www.barnsten.com\/product-category\/idera-tools\/sql-diagnostic-manager\/","name":"SQL Diagnostic Manager - Idera Tools - Barnsten.com","isPartOf":{"@id":"https:\/\/www.barnsten.com\/nl\/#website"},"description":"SQL diagnostic manager pour la surveillance rapide des performances de tous vos serveurs SQL","breadcrumb":{"@id":"https:\/\/www.barnsten.com\/product-category\/idera-tools\/sql-diagnostic-manager\/#breadcrumb"},"inLanguage":"fr-FR"},{"@type":"BreadcrumbList","@id":"https:\/\/www.barnsten.com\/product-category\/idera-tools\/sql-diagnostic-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.barnsten.com\/"},{"@type":"ListItem","position":2,"name":"Idera Tools","item":"https:\/\/www.barnsten.com\/product-category\/idera-tools\/"},{"@type":"ListItem","position":3,"name":"SQL Diagnostic Manager"}]},{"@type":"WebSite","@id":"https:\/\/www.barnsten.com\/nl\/#website","url":"https:\/\/www.barnsten.com\/nl\/","name":"Barnsten.com","description":"Logiciels de d\u00e9veloppement et outils de base de donn\u00e9es","publisher":{"@id":"https:\/\/www.barnsten.com\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.barnsten.com\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.barnsten.com\/nl\/#organization","name":"Barnsten B.V.","url":"https:\/\/www.barnsten.com\/nl\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.barnsten.com\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/www.barnsten.com\/wp-content\/uploads\/2019\/04\/Barnsten-logo-oranje@3x.png","contentUrl":"https:\/\/www.barnsten.com\/wp-content\/uploads\/2019\/04\/Barnsten-logo-oranje@3x.png","width":406,"height":150,"caption":"Barnsten B.V."},"image":{"@id":"https:\/\/www.barnsten.com\/nl\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.barnsten.com\/fr\/wp-json\/wp\/v2\/product_cat\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.barnsten.com\/fr\/wp-json\/wp\/v2\/product_cat"}],"about":[{"href":"https:\/\/www.barnsten.com\/fr\/wp-json\/wp\/v2\/taxonomies\/product_cat"}],"up":[{"embeddable":true,"href":"https:\/\/www.barnsten.com\/fr\/wp-json\/wp\/v2\/product_cat\/114"}],"wp:post_type":[{"href":"https:\/\/www.barnsten.com\/fr\/wp-json\/wp\/v2\/product?product_cat=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}