Optimisation of database or server

Dear All,

I am very interested in belows question that is copied from http://www.mibuso.com/forum/viewtopic.php?t=12076&start=15&postdays=0&postorder=asc&highlight=, the question is as follows:

Hi all,

Currently my client has 35GB and 60 concurrent user using navision SP1 and SQL2000. It went live from this january 2006 and just 5 months the data blow. Their machine ML370 dual processor 3.2 ghz raid 0+1 10k rpm SCSI. bandwith transaction per day 600Mb.

Optimisation took us 4 hours and running weekly
Full backup took 1 hour, incremental hasve not tested yet
Restore and re-indexing took 12 hours for 35 GB
Adjust costing big transaction item with serial number can goes to 9 hours and some items goes beyond 12 hrs and we do this weekly and cutting down to daily.

Does anyone here have ever used MSA-Network storage or perhaps larger than dual processor, and or maintain a database larger than 100GB. If do, please kindly share with me onto how to maximise our time againt jumbo database.

Thanks,

Pls give your answer directly or to this forum. I expect your answers so much. tks in advance.

Rgds,

Mark

If you e.g. search the “old” mbsonline forum http://www.mbsonline.org/forum/search.asp for “SQL Server Performance” you will find plenty of advice …