{"id":1916,"date":"2019-09-23T18:58:25","date_gmt":"2019-09-23T16:58:25","guid":{"rendered":"https:\/\/adm-adria.nevtron.si\/?p=1916"},"modified":"2019-09-16T13:10:54","modified_gmt":"2019-09-16T11:10:54","slug":"foglight-for-sql-server-omogoca-preprost-pregled-delovanja-podatkovnih-baz-na-sql-serverju","status":"publish","type":"post","link":"https:\/\/adm-adria.si\/en\/2019\/09\/foglight-for-sql-server-omogoca-preprost-pregled-delovanja-podatkovnih-baz-na-sql-serverju\/","title":{"rendered":"Foglight for SQL Server omogo\u010da preprost pregled delovanja podatkovnih baz na SQL Serverju"},"content":{"rendered":"<p><a href=\"https:\/\/adm-adria.si\/portfolio\/foglight-for-sql-server\/\"><b>Foglight for SQL Server \u2013 Performance Investigator<\/b><\/a><span style=\"font-weight: 400;\"> omogo\u010da \u0161irok in preprost pregled nad delovanjem SQL Server baz podatkov. Na enem mestu granularno in v realnem \u010dasu vidimo najbolj kriti\u010dne dogodke v okolju, s \u010demer nam je omogo\u010deno hitro ukrepanje v primeru te\u017eav pri delovanju baz podatkov. S prilagoditvijo nadzornih plo\u0161\u010d, lahko DBA preda nadzor oddelku za nadzor delovanja IT sistemov, sam pa lahko ve\u010d \u010dasa posveti razvoju, optimizaciji in u\u010denju.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Lastnosti <\/span><a href=\"https:\/\/adm-adria.si\/portfolio\/foglight-for-sql-server\/\"><b>Foglight for SQL Server \u2013 Performance Investigator<\/b><\/a><span style=\"font-weight: 400;\">:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Preglednost <\/b><span style=\"font-weight: 400;\">\u2013 na enem mestu preko intuitivnega grafi\u010dnega vmesnika na preprost na\u010din vidimo delovanje celotnega okolja baz podatkov. Ker je vgrajena tudi povezava do OS, lahko nadziramo tudi delovanje stre\u017enikov.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Zgodovinski podatki<\/b><span style=\"font-weight: 400;\"> \u2013 orodje v svoji bazi podatkov hrani dogodke, potek in na\u010din izvajanja SQL stavkov, resurse potrebne za izvajanje posameznih stavkov in delovanje okolja ter vse spremembe v nastavitvah. S tem nam je omogo\u010dena primerjava izvajanja istega stavka v razli\u010dnih \u010dasovnih okvirih in obremenitvah in nam tako omogo\u010da iskanje vzrokov, zakaj so se performanse izvajanja spremenile ter kako jih izbolj\u0161ati.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Avtomatsko obve\u0161\u010danje o te\u017eavah<\/b><span style=\"font-weight: 400;\"> \u2013 zaradi vgrajenega sistem sledenja sistema in bogatih zgodovinskih podatkov, Foglight for SQL Server lahko alarmira ne glede na to kako imamo nastavljene pragove pri katerih naj bi se alarm spro\u017eil na primer ob nenadoma nenormalnem pove\u010devanju zasedenosti diskovnega prostora.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Planiranje s pomo\u010djo predikativnih metod<\/b><span style=\"font-weight: 400;\"> \u2013 DBA mora redno spremljati porabo resursov in pravo\u010dasno naro\u010dati nove komponente, saj v finan\u010dnih oddelkih ne marajo, da DBA preko no\u010di naro\u010da npr. novo diskovje, ampak naj bi bila vsa naro\u010dila planirana v naprej.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Z dodatkom <\/span><b>SQL Optimizer<\/b><span style=\"font-weight: 400;\"> dobimo popolno orodje za nadzor, diagnostiko in optimizacijo baznega okolja.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Olaj\u0161ano poro\u010danje<\/b><span style=\"font-weight: 400;\"> \u2013 zaradi vgrajenega orodja za kreiranje poro\u010dil, DBA ne izgublja \u010dasa z v\u010dasih kompliciranim programiranjem poro\u010dil za razli\u010dna vodstva. S preprosto drag&amp;drop metodo, je tako poro\u010dilo narejeno v minutah.<\/span><\/li>\n<\/ul>\n<hr \/>\n<p>[kad_youtube url=&#8221;https:\/\/www.youtube.com\/watch?v=zTDvS21J_Bg&amp;t=769s&#8221; ]<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<blockquote><p><span style=\"font-weight: 400;\">Bi preizkusili, kako deluje<\/span> <a href=\"https:\/\/adm-adria.si\/portfolio\/foglight-for-sql-server\/\"><b>Foglight for SQL Server \u2013 Performance Investigator<\/b><\/a> <span style=\"font-weight: 400;\">v praksi?<\/span><\/p>\n<p>Obrnite se na nas in z veseljem vam bomo priskrbeli brezpla\u010den preizkus predstavljene re\u0161itve!<\/p>\n<p>Va\u0161e \u017eelje nam sporo\u010dite na <b>info[@]adm-adria.eu <\/b>ali <b>+386 59 251 955.<\/b><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Foglight for SQL Server \u2013 Performance Investigator omogo\u010da \u0161irok in preprost pregled nad delovanjem SQL Server baz podatkov. Na enem mestu granularno in v realnem \u010dasu vidimo najbolj kriti\u010dne dogodke v okolju, s \u010demer nam je omogo\u010deno hitro ukrepanje v primeru te\u017eav pri delovanju baz podatkov. S prilagoditvijo nadzornih plo\u0161\u010d, lahko DBA preda nadzor oddelku [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1917,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1916","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novice"],"_links":{"self":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/1916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/comments?post=1916"}],"version-history":[{"count":1,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/1916\/revisions"}],"predecessor-version":[{"id":1918,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/posts\/1916\/revisions\/1918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/media\/1917"}],"wp:attachment":[{"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/media?parent=1916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/categories?post=1916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adm-adria.si\/en\/wp-json\/wp\/v2\/tags?post=1916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}