Very slow queueing with MS SQL 2008 R2

administrator · Posted: Thu Jul 26, 2012 7:47 pm Post subject:

I'm afraid I wouldn't have the time to do something like that. Wish that I could.

If you ever do rebuild the system and find that SQL Server is normal afterwards, that would be good to know.

Regards

sundown · Posted: Fri Oct 05, 2012 12:52 pm Post subject:

I am finding Newsman unusable now after going to the latest release (3.0.7)

set @vSQLText = 'DELETE #TempPartImport FROM #TempPartImport INNER JOIN '+@pPartsTable+' ON '+@pPartsTable+'.MessageRef = #TempPartImport.MessageRef WHERE '+@pPartsTable+'.MessageRef IS NOT NULL'

was taking 1583971 milliseconds ... DISC IO is way too high ..

have stopped using NewsMan and using Grabit .. pity ... NewsMan was a cool app

administrator · Posted: Fri Oct 05, 2012 2:08 pm Post subject:

For it to be that slow, there has to be a reason. I never see anything like that using SQL Server on a 2007 PC.

* How many records are in the parts table being referenced at the time?

* Have you purged your database lately?

* How much memory have you allocated to SQL Server?

While SQL Server does use a lot of disk I/O, it is manageable if there is sufficient RAM to allow SQL to cache active transactions.

If your PC has difficulties with SQL Server, you should take a look at switching to MySQL.

Regards