One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition) \u00c2\u00a0are the System Views. \u00c2\u00a0System Views have simplified troubleshooting and performance tuning a lot in the past few years. Couple of versions ago DBAs had to write complex scripts and stored procedures to join, extract, transform and compare data to reach performance matrix. But now the database vendors got smarter and created system and dynamic views that does all that behind the scene and give the DBAs the information in a more intelligent fashion.
\nLets compare some of the key dynamic views DBAs use on a regular basis :<\/p>\n
<\/p>\n
The above and many more dynamic and systems views and routines can be found for those three databases at<\/p>\n
If anyone has any tips and tricks or useful scripts, please post it on the comments<\/p>\n","protected":false},"excerpt":{"rendered":"
One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition) \u00c2\u00a0are the System Views. \u00c2\u00a0System Views have simplified troubleshooting and performance tuning a lot in the past few years. Couple of versions ago DBAs had to write complex scripts and stored procedures to join, extract, transform and compare […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[303,3,358,364,658],"tags":[943,676,678,953,679,677,306,680,197,675,681],"class_list":["post-1169","post","type-post","status-publish","format-standard","hentry","category-database","category-db2","category-how-to","category-oracle","category-sql-server-2","tag-db2","tag-dynamic-views","tag-msdn-library","tag-oracle","tag-oracle-documents","tag-performance-views","tag-sql-server","tag-sys-dm","tag-sysibmadm","tag-system-views","tag-v"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1169"}],"version-history":[{"count":17,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions"}],"predecessor-version":[{"id":1497,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1169\/revisions\/1497"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}