|
| | | Junior Member
 
Group: Forum Members
Last Login: Today @ 12:27:37 PM
Posts: 13, Visits: 84 |
| | I seem to be getting into a bit of a state here, the SQL database on our WUG 12 installation has grown to the 4 GB limit in the three weeks we've been running it. We have less than 200 devices and I'm really surprised at the size of the db, has something gone wrong? I had to stop all passive monitoring and purge the passive log table as it had 3.7 million rows (possibly my mistake in setting up the program) but even after this the db is still at 3.8 GB. How can I get it to slim down to a more realistic size, assuming I'm right in thinking its too big? I've run all the tools in the db tools section of the console but to no real effect. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: Today @ 8:19:08 AM
Posts: 6, Visits: 62 |
| | It could be down to a number of things. roughly how many devices are you monitoring, how many active monitors do you have? Are you running 12.02? I had thsi problem as some of the database clean up routines were not clearing down the statistical interface table on the base 12 release. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 8/7/2008 5:36:33 AM
Posts: 4, Visits: 18 |
| Try this SQL command on the WhatsUp DB
create table #rowcount (tablename varchar(128), rowcnt int)
exec sp_MSforeachtable 'insert into #rowcount select ''?'', count(*) from ?'
select * from #rowcount order by rowcnt desc
drop table #rowcount
It'll list each table and the number of rows in each. That should give you an idea where your space has gone.
Also, don't forget that after deleting rows you'll still need to shrink the DB to free up the whitespace
osql -E -Q "DBCC SHRINKDATABASE (WhatsUp)"
|
| |
|
|