tag:blogger.com,1999:blog-452997616681290979.post6319532594484782429..comments2024-03-14T04:38:06.187-03:00Comments on Blog do Luti: Pesquisa: Desperdício no data cacheLuciano Moreirahttp://www.blogger.com/profile/08581065147773927546noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-452997616681290979.post-70187088567006978532015-02-20T10:54:05.964-02:002015-02-20T10:54:05.964-02:00Total 59237.8828125000000 5022.790848731445 0.0847...Total 59237.8828125000000 5022.790848731445 0.084790Anonymoushttps://www.blogger.com/profile/12910164255173856560noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-42148039481648565392014-08-07T15:34:02.111-03:002014-08-07T15:34:02.111-03:00Total 29261.1250000000000 6507.887498855468 0.2224...Total 29261.1250000000000 6507.887498855468 0.222407Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-69137208787136949802012-02-07T16:19:24.625-02:002012-02-07T16:19:24.625-02:00segue o meu resultado:
Total 6102.1718750000000 1...segue o meu resultado:<br /><br />Total 6102.1718750000000 1203.795759200195 0.197273<br /><br />[]'s<br /><br />Kleber.Kleber Rafaelhttps://www.blogger.com/profile/04910315692768167361noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-28876794236460150442012-02-07T16:15:04.926-02:002012-02-07T16:15:04.926-02:00Este comentário foi removido pelo autor.Kleber Rafaelhttps://www.blogger.com/profile/04910315692768167361noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-65255361706337263582012-02-02T23:51:04.141-02:002012-02-02T23:51:04.141-02:00Segue minha contribuição:
DatabaseID TotalUtili...Segue minha contribuição:<br /> <br />DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />---------- ---------------- -------------------- -----------------------<br />Total 308169.3437500 44794.578456877929 0.145357<br />Total 44682.8281250 7830.732862471679 0.175251<br />Total 65719.8593750 7237.522212981445 0.110126<br />Total 256472.3359375 37873.706090926757 0.147671<br />Total 65481.3671875 3078.349461554687 0.047011<br />Total 912199.3750000 187078.873924254882 0.205085<br />Total 120048.0078125 15918.282025336914 0.132599Leivio Fontenelehttp://www.dbaninja.comnoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-26172895145146369502012-02-01T09:27:30.141-02:002012-02-01T09:27:30.141-02:00Total 390.6171875000000 19.401840209960 0.049669Total 390.6171875000000 19.401840209960 0.049669Aline Onishinoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-58786854028892582062012-01-31T17:27:26.359-02:002012-01-31T17:27:26.359-02:00Total 22965.5937500000000 5032.450761794921 0.2191...Total 22965.5937500000000 5032.450761794921 0.219130<br />Total 24669.7812500000000 5048.682723999023 0.204650<br /><br />Incrível estes dados. 5 GB disperdiçads... Nossa dá pra colocar muita coisa em 5GB... Muito bom isso luti! Valeu!Rodrigo Ribeiro Gomesnoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-81814284650386916452012-01-31T15:41:16.964-02:002012-01-31T15:41:16.964-02:00outras instâncias
Total 2.761.093.750.000.000 51.0...outras instâncias<br />Total 2.761.093.750.000.000 51.068.777.083.984 0.184958<br />Total 4.552.734.375.000.000 62.490.338.325.195 0.137258<br />Total 19.708.125.000.000.000 422.512.677.192.382 0.214385<br />Total 635.000.000.000.000 26.099.206.923.828 0.411011<br />Total 34.830.156.250.000.000 46.967.557.906.250 0.013484<br />Total 1.937.968.750.000.000 29.617.497.443.359 0.152827<br />Total 478.906.250.000.000 17.075.581.549.804 0.356553<br />Total 457.578.125.000.000 17.600.599.288.085 0.384646<br />Total 10.762.500.000.000.000 74.596.100.806.640 0.069311<br />Total 2.837.734.375.000.000 98.910.550.117.187 0.348554<br />Total 4.250.781.250.000.000 85.096.024.512.695 0.200189<br />Total 26.070.156.250.000.000 862.973.207.473.632 0.331019Victor Limahttps://www.blogger.com/profile/15253354047559466224noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-29476716845251258852012-01-31T15:32:35.479-02:002012-01-31T15:32:35.479-02:00Total 143.0781250000000 31.413375854492 0.219554Total 143.0781250000000 31.413375854492 0.219554Victor Limahttps://www.blogger.com/profile/15253354047559466224noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-1790939682861166702012-01-31T14:28:24.970-02:002012-01-31T14:28:24.970-02:00Total 33947.2109375000000 4877.022085189453 0.1436...Total 33947.2109375000000 4877.022085189453 0.143664Ozimar Henriquehttps://www.blogger.com/profile/11623866854526505519noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-82649505977914463792012-01-31T13:17:49.744-02:002012-01-31T13:17:49.744-02:00DatabaseID TotalUtilizadoMB EspacoLivreMB Percentu...DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 554.6250000000000 153.213917731445 0.276247Marcelo Bossa Godoyhttps://www.blogger.com/profile/05629097060918259752noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-12360940294366332442012-01-31T13:14:35.103-02:002012-01-31T13:14:35.103-02:00DatabaseID TotalUtilizadoMB ...DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 4380.4921875000000 1520.307349204101 0.347063Rodrigo Ramos Dornelhttps://www.blogger.com/profile/00891962784214712904noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-42575551653530458322012-01-31T12:47:14.990-02:002012-01-31T12:47:14.990-02:00DatabaseID TotalUtilizadoMB EspacoLivreMB ...DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 18389.3515625000000 1831.352266311523 0.099587Edvaldo Castrohttps://www.blogger.com/profile/13964781310810127220noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-66030933499220499982012-01-31T11:47:14.947-02:002012-01-31T11:47:14.947-02:00* SQL Server 2008 SP3 Enterprise x64 (OLAP)
Total...* SQL Server 2008 SP3 Enterprise x64 (OLAP)<br /><br />TotalUtilizadoMB: 22438.6015625000000<br />EspacoLivreMB: 4355.211185455078<br />PercentDesperdicado:0.194094<br /><br />* SQL Server 2008 SP3 Enteprise x64 (OLTP)<br /><br />TotalUtilizadoMB: 2077.5312500000000<br />EspacoLivreMB: 256.397269248046<br />PercentDesperdicado: 0.123414<br /><br />Abs.<br />Leandro RibeiroLeandro Ribeiro.https://www.blogger.com/profile/00339176728311771601noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-4857559905264832002012-01-31T11:38:28.293-02:002012-01-31T11:38:28.293-02:00Servidor de produção com desenvolvimento Interno
T...Servidor de produção com desenvolvimento Interno<br />TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />56708.1875000000000 4857.196565627929 0.085652<br /><br />Ambiente Totvs<br />TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />114420.5390625000000 15904.691816329101 0.139002Fabricio Limahttp://fabriciolima.net/blog/noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-51257408350026343772012-01-31T11:24:48.529-02:002012-01-31T11:24:48.529-02:00DatabaseID TotalUtilizadoMB EspacoLivreMB ...DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 23636.35156250 6813.436568259765 0.288260Davi Freitasnoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-79025892020630945752012-01-31T11:13:48.099-02:002012-01-31T11:13:48.099-02:00Servidor SQL Server 2008 SP 2
DatabaseID TotalUt...Servidor SQL Server 2008 SP 2<br /><br />DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 17898.804687500000 2465.730891227539 0.137759<br /><br />Att,<br />Marcos FrecciaMarcos Frecciahttp://marcosfreccia.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-54841622500298020182012-01-31T11:11:47.683-02:002012-01-31T11:11:47.683-02:00Valeu galera, vamos postando...
Atualizei o script...Valeu galera, vamos postando...<br />Atualizei o script com a conversão para BIGINT do free_space_in_bytes, evitando o problema que o Erickson comentou.<br /><br />[]s<br />LutiLuciano Moreirahttps://www.blogger.com/profile/08581065147773927546noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-50920605025784856852012-01-31T11:07:17.905-02:002012-01-31T11:07:17.905-02:00DatabaseID TotalUtilizadoMB EspacoLivreMB Percentu...DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br /><br />Total 6810.6953125000000 1190.627208708984 0.1748172769561Fábio Cordeiro Alexandrenoreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-71350505296139903882012-01-31T11:03:29.115-02:002012-01-31T11:03:29.115-02:00Luti, os resultados de uma das bases mais importan...Luti, os resultados de uma das bases mais importantes do cliente que atendo.<br /><br />Obs: tive de fazer uma conversão de free_space_in_bytes para bigint pois estava estourando o "int" que a função SUM retorna, desta forma: SUM(cast(free_space_in_bytes as bigint)<br /><br />DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 5800.531250000000 2893.475884437500 0.498829<br /><br />Muito bom, vai entrar para a lista de scripts!Erickson Riccihttps://www.blogger.com/profile/08105187306280332184noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-10511458023673089532012-01-31T10:42:29.627-02:002012-01-31T10:42:29.627-02:00Marina Malvino (Servidor Sql Server 2008)
Database...Marina Malvino (Servidor Sql Server 2008)<br />DatabaseID <br />Total<br />TotalUtilizadoMB<br />6806.9687500000000<br />EspacoLivreMB<br />1031.045667647460<br />PercentualDesperdicado<br />0.1514691348696Marinahttps://www.blogger.com/profile/08073817695057200252noreply@blogger.comtag:blogger.com,1999:blog-452997616681290979.post-82744751359787909122012-01-31T10:40:58.419-02:002012-01-31T10:40:58.419-02:00Luti, segue o que deu aqui no trabalho!
DatabaseI...Luti, segue o que deu aqui no trabalho!<br /><br />DatabaseID TotalUtilizadoMB EspacoLivreMB PercentualDesperdicado<br />Total 6299.8125000000000 943.942421913085 0.1498365898847Luan Moreno Medeiros Macielhttp://luanmorenodba.wordpress.com/noreply@blogger.com