MessageHandler Database in SQL way too large
I have a database in SQL Server 2008 that is reporting it is 1.5GB when the actual size is a fraction of that.
EXEC sp_spaceused reports that the database is 1533.07MB
EXEC sp_msforeachtable 'EXEC sp_spaceused [?];' reports the following sizes;
MessageBacklog 400KB
activejobs - 4832KB
queuelog - 1496KB
Does anyone know why the size of the file is 1.5GB? Is there a way to reduce this?
EDIT: I attached an image of the size results.
Thanks
sql.png
EXEC sp_spaceused reports that the database is 1533.07MB
EXEC sp_msforeachtable 'EXEC sp_spaceused [?];' reports the following sizes;
MessageBacklog 400KB
activejobs - 4832KB
queuelog - 1496KB
Does anyone know why the size of the file is 1.5GB? Is there a way to reduce this?
EDIT: I attached an image of the size results.
Thanks
sql.png
ASKER
Is there a way to identify the object or transaction log that is taking up the space and if possible how would I reduce the size?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I checked, and the database is using the Simple Recovery model.
The size of the tables is data plus indexes.
With that said, isn't linear sum as you did.