Como verificar o espaço utilizado pelo banco MS SQL Server ?

Espaço no banco MS SQL Server Acesse o Painel de Controle e entre com seu usuário e senha;

Espaço no banco MS SQL Server Em Hospedagem de Sites, clique no link Site, da hospedagem desejada, conforme imagem abaixo:

Espaço no banco MS SQL Server

Espaço no banco MS SQL Server Para administrar bases de dados em plataforma SQL Server contratadas adicionalmente (em Contratar Adicionais, no Menu à esquerda de seu painel de controle), abaixo próximo ao rodapé da página em SERVIÇOS ADICIONAIS NO PLANO, você encontrará todas as informações necessárias para administrar sua base, clicando em Bancos de Dados Adicionais.

Espaço no banco MS SQL Server

Espaço no banco MS SQL Server Já no caso de bases de dados SQL Server inclusas ao seu plano de hospedagem, existe uma opção na guia BANCO DE DADOS onde o painel para gerenciamento de sua base com as informações para administração da mesma pode de acessado:

Espaço no banco MS SQL Server

Espaço no banco MS SQL Server Após clicar em uma das opções informadas acima (dependendo da plataforma de sua Base de Dados), será exibido um painel semelhante ao exibido abaixo, onde as informações de sua base podem ser consultadas:

Espaço no banco MS SQL Server

Tamanho das Tabelas

sp_spaceused <TABELA> 

A sintaxe sp_spaceused <TABELA> exibe, respectivamente, o nome da tabela (name), número de linhas (rows), espaço reservado para a tabela (reserved), espaço usado pelos dados na tabela (data), espaço usado pelos indexes da tabela (index_size) e espaço sem uso na tabela (unused).

Se nenhuma tabela for especificada, serão exibidos dois resultados: – nome da base de dados (database_name), tamanho da base (database_size) e espaço não alocado (unallocated space). – espaço reservado (reserved), espaço usado por dados na base de dados (data), espaço usado por indexes na base de dados (index_size) e espaço sem uso na base (unused).

sp_helpdb <NOME_DA_BASE> 

Você também pode usar a stored procedure sp_helpdb para obter informações sobre sua base de dados. A sintaxe sp_helpdb <NOME_DA_BASE> exibe, respectivamente:

– Nome da base de dados (name), tamanho (db_size), proprietário (owner), número de identificação da base (dbid), data de criação (created), opções da base (Status) e compatibilidade (compatibility_level – 80 = MS SQL Server 2000). – Nome lógico do arquivo de armazenamento (name), seu número de identificação (fileid), nome do arquivo (filename), seu filegroup, tamanho (size), tamanho máximo que poderá chegar (maxsize – espaço contratado), taxa de crescimento (growth) e para qual uso é designado o arquivo (usage – dados ou logs).

IMPORTANTE: No momento não é possível visualizar o espaço consumido das bases de dados SQL Server 2008 pelo painel de controle, de modo que pode conferir tal informação diretamente no banco, conforme uso do sp_helpdb.

Veja também


    Este procedimento é válido para clientes que utilizam o Painel de Controle.
    Caso precise de mais espaço em seu banco e o sistema de administração de seus produtos seja a Central do cliente, é necessário a contratação Para saber qual sistema você utiliza, acesse: Estou usando o Painel de Controle ou a Central do Cliente?.
    Caso precise de mais espaço em seu banco e o sistema de administração de seus produtos seja a Central do cliente, é necessário a contratação de uma nova base com o espaço desejado, e posteriormente realizar a migração do conteúdo

    Espaço no banco MS SQL Server Acesse o Painel de Controle e entre com seu usuário e senha;

    Espaço no banco MS SQL Server Em Hospedagem de Sites, clique no link Site, da hospedagem desejada, conforme imagem abaixo:

    Espaço no banco MS SQL Server

    Espaço no banco MS SQL Server No menu à esquerda do painel, clique em Contratar Adicionais;

    Espaço no banco MS SQL Server

    Espaço no banco MS SQL Server Selecione o serviço MB espaço adicional em base SQL e adicione a quantidade de MBs que deseja contratar;

    Espaço no banco MS SQL Server

    Espaço no banco MS SQL Server Clique no botão Adicionar Serviços localizando no final da página;

    Espaço no banco MS SQL Server Na página seguinte, caso tenha mais de uma Base MS-SQL, selecione a base que irá receber o espaço adicional e finalize o pedido clicando no botão Adicionar Serviços.

    Veja também


    Esse artigo ajudou você?

    87 respostas para “Espaço no banco MS SQL Server”

    1. security screens price

      Cool blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple tweeks would really make my blog stand out. Please let me know where you got your theme. Thanks a lot

      Responder
    2. Herschel Nosel

      Intimately, the post is in reality the greatest on this worthy topic. I fit in with your conclusions and also will thirstily look forward to your forthcoming updates. Saying thanks definitely will not simply be sufficient, for the amazing lucidity in your writing. I will certainly perfect away grab your rss feed to stay privy of any kind of updates. Authentic work and also much success in your business endeavors!

      Responder
    3. Good Girls Revolt

      Throughout the great scheme of things you’ll secure an A just for effort and hard work. Where exactly you misplaced me ended up being in the details. As it is said, the devil is in the details… And that couldn’t be more true here. Having said that, permit me say to you precisely what did give good results. Your text is certainly quite persuasive which is most likely the reason why I am taking an effort in order to comment. I do not make it a regular habit of doing that. Next, whilst I can easily notice a leaps in reason you make, I am not necessarily convinced of just how you seem to unite your ideas which inturn make the conclusion. For the moment I will, no doubt subscribe to your issue but wish in the future you actually link your dots much better.

      Responder
    4. plumbing services why not try here

      I simply wanted to say thanks all over again. I’m not certain what I would’ve sorted out without the entire ideas contributed by you about my subject. It seemed to be the troublesome circumstance for me personally, but being able to view this professional way you dealt with that took me to cry with gladness. I will be thankful for your assistance and pray you really know what a powerful job you were doing training others by way of your webpage. I am certain you have never met all of us.

      Responder
    5. Teodoro Marenco

      My spouse and i got really thankful when Ervin could conclude his investigations while using the precious recommendations he gained out of your site. It’s not at all simplistic to simply choose to be freely giving procedures that many some people may have been selling. Therefore we fully grasp we need the blog owner to thank for this. The type of explanations you made, the simple site navigation, the friendships your site make it possible to foster – it’s got mostly sensational, and it’s aiding our son in addition to the family understand the theme is fun, and that is particularly fundamental. Thank you for all the pieces!

      Responder
    6. Bryan Erbentraut

      Hi, you used to write magnificent articles about seattle plumbers, but the last several posts have been kinda lackluster… I miss your tremendous articles. Past several posts are just a little out of track! Seattle Plumbing

      Responder
    7. visite site electrician near me free estimate

      This is very fascinating, You’re an overly professional blogger. I have joined your rss feed and sit up for in quest of more of your great post. Also, I have shared your site in my social networks!

      Responder
    8. Bio Melt Pro Ingredients side effects

      Great blog you have got here.. It’s hard to find excellent writing like yours nowadays. I seriously appreciate individuals like you! Take care!!

      Responder
    9. Fashion

      Hi, I do believe this is a great site. I stumbledupon it 😉 I will revisit yet again since i have saved as a favorite it. Money and freedom is the greatest way to change, may you be rich and continue to help others.

      Responder
    10. Margit Jovanovic

      Nice post. I learn something more challenging on distinct blogs everyday. It will always be stimulating to read content off their writers and practice a little something from their store. I’d choose to use some with all the content in my small weblog whether you do not mind. Natually I’ll provide a link on your own internet weblog. Many thanks sharing.

      Responder
    11. go here - managed it services dallas

      Wonderful goods from you, man. I have understand your stuff previous to and you’re just extremely magnificent. I actually like what you have acquired here, really like what you’re saying and the way in which you say it. You make it enjoyable and you still care for to keep it wise. I can not wait to read much more from you. This is really a wonderful site.

      Responder
    12. porno

      This design is spectacular! You obviously know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!

      Responder
    13. Chausse faux cuir

      Heya i am for the first time here. I came across this board and I find It truly useful & it helped me out much. I hope to give something back and help others like you helped me.

      Responder
    14. electronics sales daily

      I was able to find good info from your blog articles.

      Responder
    15. Steffanie Creighton

      This will be the correct blog for really wants to be familiar with this topic. You realize a great deal its practically difficult to argue together with you (not too I just would want…HaHa). You actually put a fresh spin on the topic thats been discussing for some time. Wonderful stuff, just fantastic!

      Responder
    16. best app for cheap flights

      Having read this I believed it was rather informative. I appreciate you finding the time and effort to put this article together. I once again find myself personally spending a lot of time both reading and commenting. But so what, it was still worthwhile!

      Responder
    17. cialis for sale

      What i do not realize is in reality how you are now not really much more well-preferred than you might be now. You’re very intelligent. You understand therefore considerably in relation to this matter, produced me for my part believe it from a lot of numerous angles. Its like men and women don’t seem to be fascinated until it is something to do with Woman gaga! Your own stuffs great. All the time take care of it up!

      Responder
    18. game news

      Howdy! This blog post could not be written any better! Reading through this article reminds me of my previous roommate! He always kept talking about this. I will forward this article to him. Pretty sure he’s going to have a great read. Thanks for sharing!

      Responder
    19. Synapse XT

      An outstanding share! I’ve just forwarded this onto a colleague who had been conducting a little research on this. And he in fact bought me breakfast because I stumbled upon it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanks for spending time to discuss this subject here on your internet site.

      Responder
    20. Ernesto Mcgaffey

      You can also put a chatbox on your blog for more interactivity among readers.”‘.’*

      Responder
    21. water heater repair near me Continued

      I’m really enjoying the theme/design of your web site. Do you ever run into any web browser compatibility issues? A handful of my blog audience have complained about my site not operating correctly in Explorer but looks great in Opera. Do you have any ideas to help fix this problem?

      Responder
    22. click site

      I would like to voice my admiration for your kind-heartedness in support of all those that absolutely need guidance on your issue. Your very own dedication to getting the message around had become rather insightful and has frequently permitted others like me to attain their endeavors. Your personal interesting guidelines implies much to me and somewhat more to my peers. Thanks a ton; from all of us.

      Responder
    23. https://jbokeo.com/cach-dang-ky-jbo/

      Greetings! Very helpful advice within this post! It is the little changes that make the most important changes. Many thanks for sharing!

      Responder
    24. Solar Steve

      Thank you for creating this awesome article. I’ll be back to read more.

      Responder
    25. 출장 마사지

      I was able to find good information from your blog articles.

      Responder
    26. Office moving company

      Great website! I am loving it!! Will come back again. I am taking your feeds also

      Responder
    27. sexy whip

      magnificent points altogether, you simply gained a brand new reader. What would you suggest in regards to your post that you made a few days ago? Any positive?

      Responder
    28. Shaun Arenburg

      Having read this I thought it was extremely informative. I appreciate you finding the time and effort to put judi sicbo uang asli this information together. I once again find myself personally spending way too much time both reading and leaving comments

      Responder
    29. Kam Churchwell

      You are a great writer. Do you have any more sites? I love sucking dick btw hmu

      Responder
    30. How does ProstaStream work?

      Hello! I just would like to offer you a big thumbs up for the excellent information you have got here on this post. I will be coming back to your site for more soon.

      Responder
    31. Maria Mattioli

      Nice site. On your blogs very interest and i will tell a friends.Latoya Kollar

      Responder
    32. 제주안마

      Way cool! Some extremely valid points! I appreciate you penning this post and also the rest of the website is really good.

      Responder
    33. Video Marketing Dave

      I really enjoyed this article. You are an excellent writer. I’ll be back to see more! Thanks so much!

      Responder
    34. adjustable cock ring

      Definitely, what a magnificent website and enlightening posts, I will bookmark your website.All the Best!

      Responder
    35. sexy large lingerie

      My brother recommended I would possibly like this website. He was entirely right. This submit truly made my day. You can not imagine just how much time I had spent for this info! Thanks!

      Responder
    36. womens babydoll lingerie

      Thanks , I’ve recently been searching for information about this topic for a while and yours is the best I’ve found out so far. However, what about the conclusion? Are you positive in regards to the supply?

      Responder
    37. Skincell Pro side effects

      Having read this I believed it was extremely enlightening. I appreciate you taking the time and energy to put this article together. I once again find myself personally spending a significant amount of time both reading and posting comments. But so what, it was still worth it!

      Responder
    38. Strawberry Kush Feminized Cannabis Seeds

      I’m impressed, I have to admit. Rarely do I come across a blog that’s both equally educative and entertaining, and let me tell you, you’ve hit the nail on the head. The problem is something which too few men and women are speaking intelligently about. I’m very happy that I stumbled across this in my hunt for something regarding this.

      Responder
    39. University Furnishings Design

      Of course, what a magnificent site and illuminating posts, I definitely will bookmark your blog.All the Best!

      Responder
    40. transparent lingerie

      Heya i’m for the first time here. I came across this board and I find It truly useful & it helped me out much. I hope to give something back and help others like you helped me.

      Responder
    41. Milford Huver

      Having read this I thought it was extremely enlightening. I appreciate you spending some time and energy to put judi casino online this informative article together. I once again find myself spending a lot of time both reading and commenting

      Responder
    42. free horror

      You are so awesome! I do not believe I’ve truly read anything like this before. So nice to discover someone with a few unique thoughts on this subject matter. Really.. thank you for starting this up. This web site is one thing that is needed on the web, someone with a bit of originality.

      Responder
    43. Tom Smith

      Terriffic article! I’ll return to see your next article! Thank you!

      Responder
    44. fashion

      Greetings! Very useful advice within this post! It is the little changes that will make the greatest changes. Many thanks for sharing!

      Responder
    45. Elijah Garelik

      Additionally, it doesn’t matter how extremely you should be complete with treating a very platform, gradually you’ll discover an instance the places you should want to do a number instruct care; and as a consequence influenced by your real age but also bodybuilding, therfore the inches of one’s caravan it could be a awfully excessive pastime. motor movers

      Responder
    46. Darron Rumsey

      You actually make it appear really easy along with your presentation however I to find this matter to be actually one thing that I believe I’d never understand. It sort of feels too complicated and extremely huge for me. I’m taking a look forward in your next submit, I will try to get the dangle of it!

      Responder
    47. Pest Control Charlotte NC

      If you are looking for the best pest control company, look no more. These guys rock!

      Responder
    48. Pretty Gaming

      I’m excited to discover this page. I want to to thank you for your time just for this wonderful read!! I definitely savored every part of it and I have you bookmarked to check out new stuff in your blog.

      Responder
    49. Nicolas Schilk

      very nice publish, i certainly love this web site, carry on it

      Responder
    50. 슬롯

      Best view i have ever seen !

      Responder
    51. Jennette Orona

      I’m so glad that i visited your blog page. your submit is charming and provide me a little beneficial facts which make me got an notion of my new online site. Many thanks. Wish you always keep it up.

      Responder
    52. Hip Injuries In Dogs

      Howdy! Do you know if they make any plugins to protect against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

      Responder
    53. Room of choice delivery

      Hello! I know this is kinda off topic however I’d figured I’d ask. Would you be interested in trading links or maybe guest authoring a blog article or vice-versa? My site addresses a lot of the same topics as yours and I believe we could greatly benefit from each other. If you are interested feel free to shoot me an e-mail. I look forward to hearing from you! Excellent blog by the way!

      Responder
    54. Nick Hansley

      Good ¡V I should certainly pronounce, impressed with your site. I had no trouble navigating through all the tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Excellent task..

      Responder
    55. medicare supplement Plans

      I got this sit from my paal who shared with me concerning this website and now this time I am bowsing this website and reading very informative articles or reviews at this place.

      Responder
    56. Home Treatment For Gout In Foot

      Thanks for your personal marvelous posting! I definitely enjoyed reading it, you can be a great author.I will always bookmark your blog and will come back down the road. I want to encourage you to definitely continue your great writing, have a nice morning!

      Responder
    57. go to my site

      I just want to tell you that I am new to blogging and site-building and absolutely liked your website. Most likely I’m likely to bookmark your blog post . You surely come with fantastic stories. Thanks for sharing your web site.

      Responder
    58. Aceshin Folding Electric Mountain Bikes for sale

      hello there and thank you for your information – I have certainly picked up something new from right here. I did however expertise several technical points using this site, since I experienced to reload the site many times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your high-quality score if ads and marketing with Adwords. Well I am adding this RSS to my email and can look out for a lot more of your respective fascinating content. Ensure that you update this again soon..

      Responder
    59. PRO BIKE TOOL Accessories for sale

      Hi my loved one! I want to say that this post is amazing, great written and come with approximately all significant infos. I would like to see extra posts like this .

      Responder
    60. water heater repair near me have a peek here

      It’s actually a cool and useful piece of info. I am glad that you shared this useful information with us. Please stay us informed like this. Thank you for sharing.

      Responder
    61. Home Protection Plans

      Hello there! Would you mind iif I share your blog with my twitter
      group? There’s a lot of people that I thhink would reaply appreciate your content.Plese let me know.
      Thanks!

      Responder
    62. slots bonus

      Best view i have ever seen !

      Responder
    63. Raphael

      Very good post! We will be linking to this great content
      on our website.Keep up the great writing!

      Responder
    64. basement foundation repair

      Thanks a lot for sharing this with all of us you really know what you are talking about! Bookmarked. Please also visit my site =). We could have a link exchange arrangement between us!

      Responder
    65. 마사지알바

      You’re thus amazing. Oh my Our god. Jesus bless you.

      Responder
    66. VitalFlow

      Great web site you have got here.. It’s difficult to find high-quality writing like yours these days. I truly appreciate people like you! Take care!!

      Responder
    67. Home Warranty Insurance

      Hi there to every body, it’s my first go too see of this webpage;
      this webpawge contains amazing and really excellent data in support of readers.

      Responder
    68. Bariatric Vitamins Multivitamin Gummies

      Cool blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your theme. Kudos

      Responder
    69. plumbing contractors click this link now

      Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will certainly return.

      Responder
    70. Swing set installers

      Hey there, You’ve done an excellent job. I will certainly digg it and personally suggest to my friends. I am sure they will be benefited from this website.

      Responder
    71. the original source PACE

      Heya i’m for the primary time here. I came across this board and I in finding It really helpful & it helped me out a lot. I am hoping to offer one thing again and help others such as you helped me.

      Responder
    72. ways to remodel your room

      Great site. Plenty of useful info here. I’m sending it to several pals ans additionally sharing in delicious. And of course, thanks for your sweat!

      Responder
    73. Pool table refelting

      There are certainly quite a lot of details like that to take into consideration. That could be a nice point to deliver up. I offer the thoughts above as basic inspiration but clearly there are questions just like the one you convey up the place crucial thing might be working in trustworthy good faith. I don?t know if best practices have emerged round things like that, but I’m sure that your job is clearly recognized as a fair game. Each boys and girls really feel the influence of just a moment’s pleasure, for the rest of their lives.

      Responder
    74. White glove furniture delivery

      Howdy very nice website!! Guy .. Excellent .. Superb .. I’ll bookmark your web site and take the feeds also¡KI am glad to seek out so many helpful information here within the submit, we’d like develop more techniques on this regard, thank you for sharing. . . . . .

      Responder
    75. digital marketing mix 8ps

      Hey there! This post couldn’t be written any better! Reading through this post reminds me of my old room mate! He always kept chatting about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!

      Responder
    76. my review here

      I just want to mention I am beginner to weblog and absolutely enjoyed this web page. Very likely I’m likely to bookmark your site . You really come with amazing posts. Thanks a bunch for sharing your blog.

      Responder
    77. roadside assistance

      Excellent website. Plenty of helpful information here. I’m sending it to a few pals ans also sharing in delicious. And obviously, thanks to your effort!

      Responder
    78. visit this web-site

      Thank you, I’ve just been looking for information about this subject for ages and yours is the best I’ve discovered till now. But, what about the bottom line? Are you sure about the source?

      Responder
    79. alberta car towing

      One thing I would really like to reply to is that fat reduction plan fast is possible by the right diet and exercise. Your size not just affects the look, but also the entire quality of life. Self-esteem, depressive disorders, health risks, and physical ability are affected in putting on weight. It is possible to make everything right whilst still having a gain. Should this happen, a problem may be the culprit. While an excessive amount of food but not enough physical exercise are usually accountable, common medical conditions and key prescriptions can greatly help to increase size. Thanks for your post in this article.

      Responder
    80. movies123

      Hey there! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My web site looks weird when viewing from my iphone. I’m trying to find a theme or plugin that might be able to fix this problem. If you have any suggestions, please share. Many thanks!

      Responder
    81. Virginia pool table movers

      Howdy! Would you mind if I share your blog with my twitter group? There’s a lot of folks that I think would really enjoy your content. Please let me know. Thank you

      Responder
    82. Check This Out

      Some genuinely choice articles on this site, saved to fav.

      Responder
    83. address

      fantastic points altogether, you simply received a logo new reader. What might you suggest in regards to your put up that you simply made some days ago? Any sure?

      Responder
    84. Carlos Neider

      I simply want to mention I am all new to blogging and absolutely savored your website. Most likely I’m want to bookmark your website . You certainly have great posts. Thanks a bunch for sharing with us your blog site.

      Responder

    Comente sobre este conteúdo! Escreva o que pensa, complemente, vamos discutir. O conhecimento é livre!