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