SQL Server Sizing
Use Sizing to see how big one SQL Server instance is, how fast it grows, what grew, and which space you can reclaim.
Before you begin
- You need the View SQL Server and View Sizing permissions.
- Scops takes a snapshot of the instance once a day: the files of each database, the space used in them, and the tables and indexes. A new instance gets its first snapshot within minutes.
- Every hour, Scops also records when each index was last read and written. It keeps this record across restarts of the instance.
- Scops keeps the tables and indexes of 8 MB or more by name, at most 5,000 for each instance and day. The space of the others counts in the totals of their database.
Read the values at the top
| Value | What it shows | Click to open |
|---|---|---|
| Allocated | The size of all data and log files at the end of the window. | Files |
| Used | The space used in the data files. | Databases, or Files for one database |
| Log | The log in use, of the size of the log files. | Files |
| Grew in 7 days | How much the used space grew between the two snapshots of the window, and per day. | Overview |
| Reclaimable | The size of the unused indexes and idle tables. | Reclaimable |
If Scops could not read a database, a button such as 1 database not read shows next to the values. Hover over it to see why. It is gray when the database is not read on purpose, for example when it is offline.
Choose the window
Click 1W, 1M or 1Y to compare the newest snapshot with the one a week, a month or a year before. For two other days, click the calendar button, select From and to, and click Apply. You can select only the days that have a snapshot.
Read the charts
- Size shows the used and allocated space, day by day, for the last 30 days.
- Change per day shows how much each day changed from the snapshot before it. To show one day in the lists, click its bar. To show the window again, click the chip.
A day without a snapshot is a gap, not a drop to zero.
Find what grew
Overview lists the 15 tables and indexes that grew the most, and the 15 that were freed the most. Click a row to see its size day by day. To list all of them, click the line under a list, for example 12 more grew by.
new marks an object created in the window, and dropped an object that is gone at its end.
Find a table or index
Click Tables. The largest object is first.
Type a database, schema, table or index in Search tables, or select a kind, such as HEAP or NONCLUSTERED.
Open a row to see the size of its table day by day, and its data and indexes.
Last Read is amber when the last read is 30 days old or more.
Compare databases and files
- Databases shows the share of the instance, used, allocated and log space, and the change of each database. Click a database to show only that database.
- Files shows each file with its filegroup, size, used and free space, maximum size and growth.
Each tab lists the 200 largest. To find another one, search for it.
Find space to reclaim
Reclaimable lists what had no recorded read in the last 30 days:
- Unused indexes: nonclustered indexes that enforce nothing, written to but never read. Each one still costs its space, and a write with each change to its table.
- Idle tables: tables whose indexes were neither read nor written.
too new to tell counts the objects whose record is shorter than 30 days. On a secondary replica, Scops does not judge the indexes: judge them on the primary.
Related
Updated November 22, 2026