January 28, 2004 at 1:59 am
Hi,
I am having a SQL 2000 SP3 d/b on win2k server, that is updated everday with thousands of new records on few tables. Whenever there is lot of INSERTs going on, the SELECt queries are performing slower and vice versa. the d/b is quite big, close to 50gb.
Will it help if we batch the insert statements? If we run data updates and reporting simultaneously the d/b response comes down a lot , but the CPU utilization is very low too. What tuning options are applicable for this scenario? which SQL perf counters I need to monitor to detect the bottleneck ?
thanks in advance,
Andy.
January 28, 2004 at 9:15 am
Can you run the insert during low system usage time?
It looks like you have blocking issue. Read KB at http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453
January 29, 2004 at 12:13 pm
I would check the physical disk object's various queue length counters to see if your disk subsystem is the bottleneck.
This link contains a similar question & answer, has some good reference links: http://dbforums.com/arch/72/2002/9/514681
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply