Some large tables in SQL

Question

my database is 25gig,  so been looking through and here are few of the large ones, is there any way to reduce these?  is 25gig  a bit large?

my system size is

Network Elements5019Nodes744Interfaces4215Volumes60

Network Elements 5019 
Nodes 744 
Interfaces 4215 
Volumes 60

Network Elements5019Nodes744Interfaces4215Volumes60

Retain Detail Stats 60 Days 
Retain Hourly Stats 120 Days 
Retain Daily Stats 360 Days 
Retain Events 120 Days

interfaceerrors_detail
 
data space 1.8gig 
index space 3.4gig

interfacetraffic_detail
 
data space 5.5gig 
index space 4.2 gig

responsetime_detail

data space 1.1 gig 
index 3.2 gig

scottd · Answer

Did you check the tables in question after the maintenance run to verify the new retention policy was working correctly?

Also, when records are deleted from the db, that doesnt always mean that the table space will be freed up. You may need to rebuild your indexes to reduce the size.

If you have a DBA available to you, he/she could identify and sort this issue quickly.

Spiky · Answer

i reduced it to 30days and the database has stayed the same size

i have also run database maintenance and it's still the same size

any more options?

Spiky · Answer

ok, i will reduce that then :)

cheers