November 17, 2004 at 1:10 am
Hi there,
I'm having problems with a process, which handles a huge amount of data. This data is financial info over 24 months. It takes hours to process 1 month, which is unacceptable, since the (monthly) process would take days, a week or more, to finish. We found out, that if we stop & start SQL Server(7) and process only a month at a time the process runs much faster for the first months. After a while it stalls and we're getting memoryproblems againm(page_iolatches and such). If we stop & start SQL Server again, we can do the next couple of months.
Question: can I unload data in RAM without stopping & starting SQL Server? Or shouild I look at another solution? WOuld this problem still exists in SQL Server 2000?
Machinespecs currently: Windows 4 NT, 1 Gb RAM, dual processor P4 2.8 Gh, fast disk RAID 5.
Greetz,
Hans Brouwer
November 18, 2004 at 12:32 am
Do check the following commands
DBCC PROCCACHE, DBCC FreeProccache,
dbcc dropcleanbuffers
it might be usefull
Jeswanth
--------------------------------
November 18, 2004 at 11:42 am
Which Service Pack you have? As far as I remember sp2 for SQL Server has memory issues....
My 0.02 cents
November 18, 2004 at 9:32 pm
SP 3
visit http://www.microsoft.com/sql/downloads/topdownloads.asp
Jeswanth
--------------------------------
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply