Description

This guide explains how to create a disk report.

Someone times processes can get slow, this could be because of too much information stored in the database.
with this guide we will guide you through creating a disk report with SQL to see what is taking up space.

Requirements

• Admin access to the TEOS server
• Login for the SQL database

How to create a disk report

1. Start the SQL server management studio.
    
2. In most cases the SQL server is the same as the TEOS server, if so, the local login information can be used of the windows machine. 
   
   But in some cases the SQL server is not located on the same machine, we will then need the login credentials for the remote SQL server.
    
3. Select “Connect”, you will be presented with the database. In here we can unfold the “Databases” folder to show the different installed databases.
   
    
4. To create a report of a data base we need to right click one of the databases and select “reports”
   
    
5. Select “Standard Reports” and then “Disk usage by top tables”. This report provides detailed data on the utilization of disk space by top 1000 tables within the database.
   
    
6. With this information we can get insight on what is using space and how much to better pin point the problem at hand.

For any further questions please contact support support@teos.support