| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 20/08/2009 03:32:02
|
Mountainman
SysAider
Joined: 19/02/2009
Messages: 5
Offline
|
I need help......
My database have exploded.
It is now 32½ GB on MSSQL
I have around 120 users and 150 assets
We are 3 operators/administrators
Does anybody have any idea, how to get the size down.
I think the size exploded because the inventory functionality was set to collect data every 2 hours. Thats a huge mistake 
This was only ment to be active initially for a few days, but somehow I forgot to change it 
|
|
|
20/08/2009 03:39:20
|
Mucho
SysAider
Joined: 13/05/2009
Messages: 41
Offline
|
Mountainman wrote:I need help......
My database have exploded.
It is now 32½ GB on MSSQL
I have around 120 users and 150 assets
We are 3 operators/administrators
Does anybody have any idea, how to get the size down.
I think the size exploded because the inventory functionality was set to collect data every 2 hours. Thats a huge mistake
This was only ment to be active initially for a few days, but somehow I forgot to change it
Please check you data size and transaction log size in properities of that database....
i suggest biggest is transaction log...
then if you dont plan use in time recovery, truncate transaction log and switch database to simple mode.
|
|
|
20/08/2009 03:57:39
|
Mountainman
SysAider
Joined: 19/02/2009
Messages: 5
Offline
|
Database size is 32½ GB
Log file size is 16 MB
Logging is set to simple
|
|
|
25/08/2009 07:55:37
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Mountainman,
Which version of SysAid are you currently using?
If you are not using 6.0.09 please upgrade to it and let us know if the size is still the same.
Best regards.
Haim
|
Pushing IT forward |
|
|
25/08/2009 08:25:08
|
Mountainman
SysAider
Joined: 19/02/2009
Messages: 5
Offline
|
Version is now 6.0.09 
Database size is now about 18GB
Is there any way to get the assets inventory deleted ???
I would very much like to get the database size minimized
I only have 650 helpdesk tasks in the database....
This message was edited 1 time. Last update was at 25/08/2009 08:27:18
|
|
|
25/08/2009 10:25:27
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Mountainman,
service requests usually take a small space in the database, attachments, assets, and monitoring information usually take up more space.
You can also check what is the size of any table and let us know what are the biggest tables, which can tell us why the database grew so much.
Regards.
Haim
|
Pushing IT forward |
|
|
28/08/2009 05:56:45
|
Mountainman
SysAider
Joined: 19/02/2009
Messages: 5
Offline
|
There are 4 tables that are over 20 MB:
computer: 63,313MB
computer_changes: 141,719MB
computer_history: 1.2835,398MB
computer_log: 27,895MB
The rest of the tables are under 20 MB
This message was edited 1 time. Last update was at 28/08/2009 05:57:18
|
|
|
31/08/2009 02:00:46
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Mountainman,
It seems like the table "computer_history" wasn't deleted as it should have been when you upgrade to 6.0.9
This is a new table that was added in version 6, and in some cases it can grow to big sizes just like happened in you case.
The upgrade to 6.0.09 changes this folder, but it should also delete all the previous content.
Please truncate the computer_history table while the SysAid server is down and you have a recent backup.
This should reduce most of the size of your db and prevent it from growing to this size so fast.
Best regards.
Haim
|
Pushing IT forward |
|
|
31/08/2009 04:41:06
|
Mountainman
SysAider
Joined: 19/02/2009
Messages: 5
Offline
|
Database file is now 431 MB
Log file is 100 MB
Thanks for your help, Haim.
You rock !!!!
Once again I'm convinced that I bought the right product, since support is fast and professional
|
|
|
31/08/2009 09:52:33
|
Brian Martin
Elite SysAider
Joined: 11/02/2009
Messages: 181
Location: Knoxville, TN
Offline
|
Just a FYI.
After the update to 6.0.09 our database went from 14+GB to 7GB.
|
- Brian Martin
Unofficial SysAid Wiki - Most common issues and their solutions can be found here.
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/Sysforums/templates/default/images/icon_www.gif){kind=icon}
