| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 09/06/2009 04:55:54
|
JSH
SysAider
Joined: 18/08/2008
Messages: 24
Offline
|
We are using MS SQL 2005 and currently the size is almost 4 GB. (Been using Sysaid for 9 month now and have 3500 ServiceRequests)
Anyone else that would like to comment. I don't know if this is normal
|
|
|
09/06/2009 05:20:07
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hey JSH.
Please check what is the size of the SysAid database LDF file.
If it is bigger then a few hundred MB, you can shrink it by backing up your database.
4GB is a pretty large size but can be reasonable if you are using SysAid to audit a large number of assets or if you attached a lot of files into SysAid.
Best regards.
Haim
|
Pushing IT forward |
|
|
09/06/2009 05:22:49
|
JSH
SysAider
Joined: 18/08/2008
Messages: 24
Offline
|
The LDF-file is only 3-4 MB
Just did a shrink on it. (shrinking the database on a weekly basis)
|
|
|
09/06/2009 06:25:12
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 197
Location: Germany, BY
Offline
|
Hi JSH,
same found here 
I've posted almost the same question a few weeks ago.
I think it is all about windows updates. Everytime a client gets a windows update the table 'computer_history' grows  No secret that every 2 weeks there are a few updates available which leads to that issue, that the size of the table 'computer' gets added to the table 'computer_history'... and on my installation this is growing the database...
So I've started a Feature Request to avoid those updates being logged, hoping that it'll keep my database lean.
Can you find out WHAT database table is growing that fast?
I found a real nice stored procedure* around the internet and will attach it here for your convenience
Best regards,
EbroIN
[edit]
* = This is only the executed part of the stored procedure! You must generate a stored procedure for your database to integrate this script! Thanks to JSH he informed me about my ambiguous post here. So create a new stored procedure and post the SQL statemenents here. I've left all comments from the author inside this script (as told, I've found this script in the internet).
| Filename |
tableInfo.sql |
|
| Description |
Corrected TableInfo (corrected END) |
| Filesize |
1 Kbytes
|
| Downloaded: |
3 time(s) |
This message was edited 4 times. Last update was at 09/06/2009 11:05:45
|
|
|
09/06/2009 06:57:43
|
JSH
SysAider
Joined: 18/08/2008
Messages: 24
Offline
|
When running the SQL as a new query I get the error :
Msg 102, Level 15, State 1, Line 46
Incorrect syntax near 'END'.
|
|
|
09/06/2009 07:13:39
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 197
Location: Germany, BY
Offline
|
JSH wrote:When running the SQL as a new query I get the error :
Msg 102, Level 15, State 1, Line 46
Incorrect syntax near 'END'.
Oops, copied too much. You have to include this query into a stored procedure or this won't work.
I've removed the END command so this won't bother you anymore -> Thanks.
I cannot provide a complete SQL Solution for you, so you need to use SQL Studio Express (or something like this) in order to wrap this script inside such a wrapper (assuming your database is named ilient as default):
This will create a stored procedure....
You then need to execute the stored procedure with the following SQL commands (still assuming that your database is named ilient and the freshly created stored procedure is named helpers_tableInfo)
Alternatively you can simply create a new stored procedure using the SQL Server Management Studio.
SQL Server Management Studio --> Ilient --> Programmability --> Stored Procedures <-- RIGHT CLICK
Select --> New stored procedure
Paste the above code (including the pasted script - use the text editor of your choice) inside the Query Window (clear all existing code before) and hit APPLY only ONCE. This will create the procedure.
Afterwards you need to refresh the view (hit F5) and right click on your new stored procedure (it should show up by now).
Select --> Execute stored procedure --> Confirm with OK
This should do the trick...
I'll just modify my previous post and cut the last line (containing the END command)
Hope this helps,
best regards, EbroIN
|
|
|
10/06/2009 02:13:08
|
JSH
SysAider
Joined: 18/08/2008
Messages: 24
Offline
|
Just got another version of the SQL-statement and now I have the stored procedure - result:
| Filename |
Book1.htm |
|
| Description |
|
| Filesize |
10 Kbytes
|
| Downloaded: |
2 time(s) |
|
|
|
10/06/2009 02:52:34
|
Mucho
SysAider
Joined: 13/05/2009
Messages: 16
Location: Klasterec Nad Ohří
Offline
|
We have 10k service request and our sql server database in simple recovery mode have 3330 MB
|
Kdo nic nedělá ten nic nezkazí. |
|
|
16/06/2009 02:03:17
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 197
Location: Germany, BY
Offline
|
Hi,
back from my short holiday,
my database hasn't grown too much, waiting for the update cycle today ...
best regards,
EbroIN
|
|
|
16/06/2009 02:46:19
|
DK_Sysaider
Super SysAider
Joined: 07/05/2009
Messages: 79
Location: DK
Offline
|
We have nearly 600 service requests, and a database on 1 GB, still in the built in Derby database.
|
"The Helpdesk is not active as the IT staff is on holiday, your service request will be addressed in about 4 weeks." |
|
|
16/06/2009 05:29:44
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 197
Location: Germany, BY
Offline
|
DK_Sysaider wrote:We have nearly 600 service requests, and a database on 1 GB, still in the built in Derby database.
Hi DK_Sysaider,
how many assets are you monitoring using sysaid?
I suppose that computer_history is the "largest" table within my complete configuration...
Greetings - EbroIN
|
|
|
16/06/2009 06:50:52
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello everyone.
We have found that the "computer history" can grow too much in size on some cases.
We have identified the issue and we are working on a minor patch that will resolve this issue.
Meanwhile, if the computer history grow too much you can truncate it to keep the database size down until the fix will be available.
We are very sorry for the inconvenience
Best regards.
Haim
|
Pushing IT forward |
|
|
18/06/2009 06:30:08
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 197
Location: Germany, BY
Offline
|
Haim wrote:...we are working on a minor patch that will resolve this issue.
Hi Haim,
thanks for your feedback...
Would you please inform us, when this patch is available?
Thanks
|
|
|
18/06/2009 07:00:49
|
DK_Sysaider
Super SysAider
Joined: 07/05/2009
Messages: 79
Location: DK
Offline
|
EbroIN wrote:
DK_Sysaider wrote:We have nearly 600 service requests, and a database on 1 GB, still in the built in Derby database.
Hi DK_Sysaider,
how many assets are you monitoring using sysaid?
I suppose that computer_history is the "largest" table within my complete configuration...
Greetings - EbroIN
Sorry for the late responds, we are monitoring about 70 Assets..
I think it's is, we have one problem in the Activity log, this is shown all over:
Software Product Windows Genuine Advantage Validation Tool (KB892130) version changed from null to 1.7.0069.2
Being "updated" at every inventory check, at the most assets. It gives quite an log I guess .
I saw something earlier on the forum that there was a fix for this underway, and it could be in the version 6, but its still an issue.
But we can live with it.
|
"The Helpdesk is not active as the IT staff is on holiday, your service request will be addressed in about 4 weeks." |
|
|
21/06/2009 03:03:35
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
DK_Sysaider,
Please check if you are using version 6 of the agent on the machines who are having this issue as this issue should have been resolved in version 6 of the agent.
EbroIN,
We have postponed the official release of patch 6.0.07 to include this fix in the final edition, I hope we will have the patch ready by the end of the week.
Best regards.
Haim
|
Pushing IT forward |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/Sysforums/templates/default/images/icon_www.gif){kind=icon}
![[MSN]](/Sysforums/templates/default/images/icon_msnm.gif){kind=icon}
![[ICQ]](/Sysforums/templates/default/images/icon_icq_add.gif){kind=icon}
