{"id":2417,"date":"2018-08-31T00:39:39","date_gmt":"2018-08-31T00:39:39","guid":{"rendered":"http:\/\/dbtut.com\/?p=2417"},"modified":"2018-11-24T16:25:46","modified_gmt":"2018-11-24T16:25:46","slug":"emc-flash-drive-as-temp-database-device","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/","title":{"rendered":"EMC flash drive as Temp database device"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size.<\/p>\n<p>Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join\/self join.<\/p>\n<p>Mainly for financial risk reporting; the reporting tools are SAP business object, IBM Cognos and Micro Strategy dashboard, lots of cubes and ad-hoc queries. Most queries will do hash\/merge joins, group by, order by; over 95% i\/o will be at Temp DB devices.<\/p>\n<p>For reporting server similar to this, in general, to support multiple running SQL in the system; the i\/o from Temp database is became major bottleneck.<\/p>\n<p>You can find good references about Cube from\u00a0<a href=\"https:\/\/www.dremio.com\/what-is-a-data-warehouse\/\">Data Warehouses Explained by Dremio.<\/a><\/p>\n<p style=\"font-weight: 400;\"><strong>DW graphical query plan output<\/strong><\/p>\n<pre class=\"lang:default decode:true \">$ egrep 'Act' CCAR_dqi_20180917-140154_2496060.html\r\n\r\n&lt;TR&gt;&lt;TD&gt;&lt;B&gt;&lt;FONT SIZE=-2&gt;Act. Temp Space Used (Mb)&lt;\/FONT&gt;&lt;\/B&gt;&lt;\/TD&gt;&lt;TD&gt;&lt;FONT SIZE=-2&gt;231986.2&lt;\/FONT&gt;&lt;\/TD&gt;&lt;\/TR&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>If you have 5 concurrent reports similar to that, you will need close to 1000G temp database space.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Setup 3 EMC flash drive<\/strong><\/p>\n<p>From Red Hat Linux box, we have 3 EMC flash internal cards as fioa\/fiob\/fioc.<\/p>\n<pre class=\"lang:default decode:true \">$ dmesg | grep fio | grep 'block device'\r\n\r\nfioinf HP 2410GB MLC PCIe ioDrive2 Duo for ProLiant Servers 0000:63:00.0: Creating block device fioa: major: 252 minor: 0 sector size: 512...\r\n\r\nfioinf HP 2410GB MLC PCIe ioDrive2 Duo for ProLiant Servers 0000:64:00.0: Creating block device fiob: major: 252 minor: 16 sector size: 512...\r\n\r\nfioinf HP 1205GB MLC PCIe ioDrive2 for ProLiant Servers 0000:54:00.0: Creating block device fioc: major: 252 minor: 32 sector size: 512...\r\n\r\n$ ls -ltr \/dev\/fio*\r\n\r\nbrw-rw---- 1 root disk 252, 16 Aug 19 11:44 \/dev\/fiob\r\n\r\nbrw-rw---- 1 root disk 252, 32 Aug 19 11:44 \/dev\/fioc\r\n\r\nbrw-rw---- 1 root disk 252,\u00a0 0 Aug 19 11:44 \/dev\/fioa\r\n\r\n$\r\n\r\nFrom these 3 EMC drives, we set up 5 raw volumes.\r\n\r\n$ ls -1 \/dev\/raw\/raw100*\r\n\r\n\/dev\/raw\/raw1001\r\n\r\n\/dev\/raw\/raw1002\r\n\r\n\/dev\/raw\/raw1003\r\n\r\n\/dev\/raw\/raw1004\r\n\r\n\/dev\/raw\/raw1005\r\n\r\n$\r\n\r\n$ ls -ltr \/dev\/ssd*\r\n\r\ntotal 0\r\n\r\nlrwxrwxrwx 1 root root 7 Aug 19 11:44 ssd-vol2 -&gt; ..\/dm-5\r\n\r\nlrwxrwxrwx 1 root root 7 Aug 19 11:44 ssd-vol1 -&gt; ..\/dm-4\r\n\r\nlrwxrwxrwx 1 root root 7 Aug 19 11:44 ssd-vol4 -&gt; ..\/dm-7\r\n\r\nlrwxrwxrwx 1 root root 7 Aug 19 11:44 ssd-vol3 -&gt; ..\/dm-6\r\n\r\nlrwxrwxrwx 1 root root 7 Aug 19 11:44 ssd-vol5 -&gt; ..\/dm-8\r\n\r\n$\r\n\r\n# pvscan\u00a0 \u00a0-- UNIX SA privilege needed for this command\r\n\r\n\u00a0 PV \/dev\/md0p1 VG ssd-vg lvm2 [2.00 TiB \/ 170.24 GiB free]\r\n\r\n\u00a0 PV \/dev\/fioc VG ssd-vg lvm2 [1.10 TiB \/ 0 free]\r\n\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p style=\"font-weight: 400;\"><strong>I\/O stat monitoring<\/strong><\/p>\n<p>Finally, we can check i\/o rates from 3 flash devices.<\/p>\n<pre class=\"lang:default decode:true \">$ iostat -nx 5 | egrep 'await|fio'\r\n\r\nDevice:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rrqm\/s\u00a0\u00a0 wrqm\/s\u00a0\u00a0\u00a0\u00a0 r\/s\u00a0\u00a0\u00a0\u00a0 w\/s\u00a0\u00a0 rsec\/s\u00a0\u00a0 wsec\/s avgrq-sz avgqu-sz\u00a0\u00a0 await r_await w_await\u00a0 svctm\u00a0 %util\r\n\r\nfioa\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 5.60\u00a0\u00a0 32.97\u00a0\u00a0 580.77\u00a0 3374.98\u00a0\u00a0 102.55\u00a0\u00a0\u00a0\u00a0 1.18\u00a0\u00a0 31.46\u00a0\u00a0\u00a0 9.99\u00a0\u00a0 35.12\u00a0\u00a0 0.22\u00a0\u00a0 0.84\r\n\r\nfiob\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a00.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 5.60\u00a0\u00a0 32.40\u00a0\u00a0 580.46\u00a0 3375.32\u00a0\u00a0 104.10\u00a0\u00a0\u00a0\u00a0 1.16\u00a0\u00a0 32.36\u00a0\u00a0 10.18\u00a0\u00a0 36.19\u00a0\u00a0 0.22\u00a0\u00a0 0.83\r\n\r\nfioc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 6.36\u00a0\u00a0 37.48\u00a0\u00a0 774.91\u00a0 4499.65\u00a0\u00a0 120.32\u00a0\u00a0\u00a0\u00a0 0.36\u00a0\u00a0\u00a0 8.34\u00a0\u00a0\u00a0 1.59\u00a0\u00a0\u00a0 9.49\u00a0\u00a0 0.13\u00a0\u00a0 0.55\r\n\r\nDevice:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rrqm\/s\u00a0 \u00a0wrqm\/s\u00a0\u00a0\u00a0\u00a0 r\/s\u00a0\u00a0\u00a0\u00a0 w\/s\u00a0\u00a0 rsec\/s\u00a0\u00a0 wsec\/s avgrq-sz avgqu-sz\u00a0\u00a0 await r_await w_await\u00a0 svctm\u00a0 %util\r\n\r\nfioa\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 1.65\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 273.34\u00a0\u00a0 165.78\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.28\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.28\u00a0\u00a0 0.00\u00a0\u00a0 0.00\r\n\r\nfiob\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 1.37\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 265.71\u00a0\u00a0 193.86\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.29\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.29\u00a0\u00a0 0.00\u00a0\u00a0 0.00\r\n\r\nfioc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 1.41\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 383.95\u00a0\u00a0 272.23\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.25\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.25\u00a0\u00a0 0.00\u00a0\u00a0 0.00\r\n\r\nDevice:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 rrqm\/s\u00a0\u00a0 wrqm\/s\u00a0\u00a0\u00a0\u00a0 r\/s\u00a0\u00a0\u00a0\u00a0 w\/s \u00a0\u00a0rsec\/s\u00a0\u00a0 wsec\/s avgrq-sz avgqu-sz\u00a0\u00a0 await r_await w_await\u00a0 svctm\u00a0 %util\r\n\r\nfioa\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 43.11\u00a0\u00a0\u00a0\u00a0 0.00\u00a0 5393.08\u00a0\u00a0 125.10\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.20\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.20\u00a0\u00a0 0.00\u00a0\u00a0 0.00\r\n\r\nfiob\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 43.29\u00a0\u00a0\u00a0\u00a0 0.00\u00a0 5413.54\u00a0\u00a0 125.07\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.21\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.21\u00a0\u00a0 0.00\u00a0\u00a0 0.00\r\n\r\nfioc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.00\u00a0\u00a0 46.20\u00a0\u00a0\u00a0\u00a0 0.00\u00a0 7106.33\u00a0\u00a0 153.83\u00a0\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.19\u00a0\u00a0\u00a0 0.00\u00a0\u00a0\u00a0 0.19\u00a0\u00a0 0.00\u00a0\u00a0 0.00<\/pre>\n\n<p style=\"font-weight: 400;\">\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2417\" class=\"pvc_stats all  \" data-element-id=\"2417\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join\/self join. Mainly for financial risk reporting; the reporting tools are SAP &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2417\" class=\"pvc_stats all  \" data-element-id=\"2417\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":92,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[299,1319],"tags":[1509],"class_list":["post-2417","post","type-post","status-publish","format-standard","","category-linux","category-sybase","tag-temp-database-linux"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EMC flash drive as Temp database device - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EMC flash drive as Temp database device - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"&nbsp; Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join\/self join. Mainly for financial risk reporting; the reporting tools are SAP &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-31T00:39:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T16:25:46+00:00\" \/>\n<meta name=\"author\" content=\"Rey Wang\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rey Wang\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\"},\"author\":{\"name\":\"Rey Wang\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/5a211585fe4d6565b824316acd8fd700\"},\"headline\":\"EMC flash drive as Temp database device\",\"datePublished\":\"2018-08-31T00:39:39+00:00\",\"dateModified\":\"2018-11-24T16:25:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\"},\"wordCount\":196,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"keywords\":[\"temp database linux\"],\"articleSection\":[\"Linux\",\"Sybase\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\",\"name\":\"EMC flash drive as Temp database device - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-31T00:39:39+00:00\",\"dateModified\":\"2018-11-24T16:25:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EMC flash drive as Temp database device\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/5a211585fe4d6565b824316acd8fd700\",\"name\":\"Rey Wang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e6ab4240ec28cb9a0bcd1df2b82fd82bec0f905e83dd887da8599601347721d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e6ab4240ec28cb9a0bcd1df2b82fd82bec0f905e83dd887da8599601347721d6?s=96&d=mm&r=g\",\"caption\":\"Rey Wang\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/reywang\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EMC flash drive as Temp database device - Database Tutorials","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:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/","og_locale":"en_US","og_type":"article","og_title":"EMC flash drive as Temp database device - Database Tutorials","og_description":"&nbsp; Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB size. Total DB size is way over 25TB, and we run very bizarre over 20 table joins, outer join\/self join. Mainly for financial risk reporting; the reporting tools are SAP &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-31T00:39:39+00:00","article_modified_time":"2018-11-24T16:25:46+00:00","author":"Rey Wang","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rey Wang","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/"},"author":{"name":"Rey Wang","@id":"https:\/\/dbtut.com\/#\/schema\/person\/5a211585fe4d6565b824316acd8fd700"},"headline":"EMC flash drive as Temp database device","datePublished":"2018-08-31T00:39:39+00:00","dateModified":"2018-11-24T16:25:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/"},"wordCount":196,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"keywords":["temp database linux"],"articleSection":["Linux","Sybase"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/","name":"EMC flash drive as Temp database device - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-31T00:39:39+00:00","dateModified":"2018-11-24T16:25:46+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/31\/emc-flash-drive-as-temp-database-device\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"EMC flash drive as Temp database device"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/5a211585fe4d6565b824316acd8fd700","name":"Rey Wang","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e6ab4240ec28cb9a0bcd1df2b82fd82bec0f905e83dd887da8599601347721d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e6ab4240ec28cb9a0bcd1df2b82fd82bec0f905e83dd887da8599601347721d6?s=96&d=mm&r=g","caption":"Rey Wang"},"url":"https:\/\/dbtut.com\/index.php\/author\/reywang\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=2417"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2417\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}