 | Note: Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account. |
This procedure applies to SQL Server 2005 and SQL Server 2008.
You can monitor the space usage for your database and transaction logs—how much space is available and how much is being used.
To monitor SQL database and transaction log space usage
To open a query window, in the SQL Server Management Studio, click New Query.
To check the database space usage, type
Use database_name
go
sp_spaceused
go
where database_name is the name of the database to check for space usage.
Click Execute.
Information on database space used is displayed.
To check the transaction log space usage, open another query windows by clicking New Query.
Type:
DBCC sqlperf(logspace)
Click Execute.
Information on transaction log space usage is displayed.