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?

[paprita]

Lansweeper wrote:
Most likely processor load will be the problem.

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

Processor load seems to be low but in errorlog.txt there are lots of timeout messagges like

03/09/2009 8.43.27: 'computername' Timeout. Il tempo disponibile è scaduto prima del completamento dell'operazione o il server non risponde.
in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
in System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
in System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
in System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
in System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
in System.Data.SqlClient.TdsParserStateObject.ReadByte()
in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
in System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
in System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
in System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
in LansweeperService.MdlWmi.GetWMI(String Querystr, String Table, LS_Computer& mycomputer, String section, SqlConnection& sqlcon)

[Hemoco]

Could you monitor the load on your SQL server, it is most likely overloaded which would also explain the long wait queue for the scanning.

[paprita]

Lansweeper wrote:
Could you monitor the load on your SQL server, it is most likely overloaded which would also explain the long wait queue for the scanning.

How can I see SQL server load? By processor or by memory usage or something else?

[paprita]

I've tried to wait with 3 different records and it seems to work but:

- first record take more than 20 minutes to finish;
- second record take more about 10 minutes to finish;
- third record take about 13 minutes to finish.

I think that something goes wrong ... what do you think about?

[Hemoco]

Could you try this sql script to delete one computer:

delete from tblcomputers where computername='mycomputer'

[paprita]

Lansweeper wrote:
Could you try this sql script to delete one computer:

delete from tblcomputers where computername='mycomputer'

I've tried but:
- after send the script lsmanage was blocked (I've tried several times and wait several minutes each tentative) ... I need to close it by Task Manager;
- record is still there ...
- I've tried with the "normal" way but it goes in timeout and recordi is still there ...

You have to consider that lansweeperservice is alwais in active mode and in dayhours queue is alwais very very long ... may be this could be important ...

[Hemoco]

paprita wrote:

- after send the script lsmanage was blocked (I've tried several times and wait several minutes each tentative) ... I need to close it by Task Manager;

The timeout for lsmanage.exe is 3 minutes before it times-out.
When the screen seems to "hang" it's still working on the delete.

[Hemoco]

How much time does the delete take?

[paprita]

Lansweeper wrote:
How much time does the delete take?

About 60 sec ...

[paprita]

paprita wrote:

Lansweeper wrote:
How much time does the delete take?

About 60 sec ...

Any news, please?