Wiki Life: Sharepoint Database Calculator application referenced by TechNet Article


I want to introduce an application about Sharepoint and MSSQL Server writen by Erdem Avni Selçuk. With this application, you can calculate average Sharepoint Content database size and get an idea of disk space required. The application uses the Microsoft Best Practice's formula.

Sizlere SharePoint ve MSSQL ile alakali Erdem Avni Selçuk tarafindan yazilmis yeni bir SharePoint uygulamasi tanitmak istiyorum. Bu uygulama Microsoft Best Practice’ler ile belirtilen SharePoint için MSSQL database boyutu hesaplama formüllerini kullanarak sizlere ortalama olarak SharePoint Content veritabaniniz için ne kadar alana ihtiyaciniz oldugunu kolay ve pratik bir yönden hesaplayarak gösterir.

You can install it on your mobile device for free from Google Play Store. Also, the Application has a very useful and simple user interface. As a consequence there is both low power/battery usage and processing requirement. The application is self contained, it needs no extra library.

Program Google Play üzerinde yayinda olup herhangi bir özel yetki istemeden telefonunuza kurulabilmektedir. Ayrica UI olarakta gayet sade ve ek kütüphaneler kullanilmadigindan Pil kullanimi ve performans gibi sorunlarida telefonunuzu kullanirken sizi etkilemeyecektir.

You can see an application screenshot below, and you can try it here

Asagida programin ekran görüntülerini bulabilirsiniz.  Uygulamayi buradan indirerek deneyebilirsiniz.

This application was created by Storage and SQL Server capacity planning and configuration ( SharePoint Server 2013) as a referance article.

The application calculates the database size by referanced TechNet article.

Input Value

Number of documents (D)

200,000

Calculated by assuming 10,000 users times 20 documents

Average size of documents (S)

250 KB

List items (L)

600,000

Number of non-current versions (V)

2

Assuming that the maximum versions allowed is 10

Database size = (((200,000 x 2)) × 250) + ((10 KB × (600,000 + (200,000 x 2))) = 110,000,000 KB or 105 GB

SharePoint Database Calculator uygulamasi Microsoft tarafindan yayinlanan “Storage and SQL Server capacity planning and configuration ( SharePoint Server 2013) “ makalesini referans alarak hazirlanmistir. Verimlilik kategorisinde kullanabileceginiz bu basit uygulama makalede de belirtildigi gibi asagidaki referans degerleri alarak hesaplamada bulunur.

I hope this application develops more, and I hope you download it. After a try, please give some feedback.

SharePoint Database Calculator uygulamasinin daha gelismesini umar bu ufak ve faydali programi indirip denemenizi ve Google Play üzerinden feedbacklerinizi de iletmenizi umariz.

Turkish Wiki Ninja

Davut

Comments (5)

  1. That’s awesome! Fantastic application! Thanks to Erdem for building it!

  2. Thanks Davut and Ed. You are very kind.

  3. Recep YUKSEL says:

    Thank you very much Davut, Thank you very much Erdem.

  4. Danish Islam says:

    Thanks for sharing Davut. Thanks Erdem for this application.

  5. Hello everyone. this program deleted from the google because we cant use SharePoint Name on any program. Now it’s new build and new name activated the small tool . please check https://goo.gl/hGC1tC this url. Thanks

Skip to main content