Delete or not delete ...

[paprita]

I have to permanently delete some machines ... I'll try to delete them but they are always there ... what could be the problem?

[Hemoco]

paprita wrote:
Going back to the first problem, I'd like to use the normal function (and not the script) because I need to permanently delete more than 500 PC: how can I do?

Problem is the same, your database times out, so first we need to solve this.

[Hemoco]

Most likely the single disk is the problem.

What you could try to make it faster:

Stop lansweeper service
Set the sql logging mode to "simple"
Shrink and reorganize the database
Stop sql services
defrag the harddisk

[paprita]

Lansweeper wrote:
Most likely the single disk is the problem.
Stop lansweeper service
Set the sql logging mode to "simple"
Shrink and reorganize the database
Stop sql services
defrag the harddisk

Well, I did what you ask me to do and:
- the function to permanently delete PC un lsmanage doesn't go yet;

Lansweeper wrote:
delete from tblcomputers where computername='mycomputer'

- PC's I had delete with script you give to me (I had try with 5 or 6 PC's), come back again.

My problem is that in my domain I have more than 500 PC that I can't have under my control ... now I have set them to "not active" but all data are in db and I need to delete them permanently: what can I do?

Thanks

[paprita]

Lansweeper wrote:
Most likely the single disk is the problem.

What you could try to make it faster:

Stop lansweeper service
Set the sql logging mode to "simple"
Shrink and reorganize the database
Stop sql services
defrag the harddisk

I'll try it.
Thanks.

[Hemoco]

What hardware is the server running?
How big is your database?

[paprita]

Lansweeper wrote:
What hardware is the server running?

Actual version:
- single processor dual core clock 2.900 MHz
- 4 GB RAM
- 1 HD SATA

Future version (I hope in october):
- dual processor Xeon quad core
- 4 GB RAM
- 4 HD SAS raid 1+0

Lansweeper wrote:
How big is your database?

Actual 3,7 GB

[paprita]

I made another tentative: I've stopped active scan and with db unload I've tried to permanently delete some records ... nothing good ... they are still there ...

Trying with your script take lots of time yet ...

[Hemoco]

Is the sql server running on seperate hardware?
I would suggest lowering the amount of scanning threads.

[paprita]

Lansweeper wrote:
Is the sql server running on seperate hardware?

Yes

Lansweeper wrote:
I would suggest lowering the amount of scanning threads.

Ok ... now there are 30 threads ... I try to lower them waiting for better HW ...

[Hemoco]

Most likely processor load will be the problem.

When you look at your errorlog.txt file, do you see any timeout errors?