SQL is good at managing its own memory so I would not try to second guess it as to how much it needs, or risk throttling the OS because it...

Simon_L (10/22/2008)

---

george .. thank you

its been bugging me for days ....

as for the 3gb set I mean via EM -> SQL Server properties -> used a fixed memory...

available bytes is total amount of physical memory available to ALL processes on the server. 1.46GB pretty good

total server memory (SQL server:memory manager object) is the amount of memory SQL...

good article I thought and I am in agreement about how cool it was that a lot of scalability features were included in SQL 2005 standard edition (we use standard...

hard to say why, post the error. You sure you have got new path correct.

That said there is no reason to have two log files. Get rid of the second...

one other thing............

as you are upgrading to SQL 2005 for each database you should :

change the compatibility mode to 90 (sp_dbcmptlevel )

run sp_updatestats

run dbcc updateusage

set default schema for users to...

you should have used the 'recovery' option rather than nocovery, you have left the database in a state where it has not done the 'recovery' part of restore (roll back...

dbadave,

perhaps this is your answer, a sort of halfway house, available from SQL2005 onwards, use AUTO_UPDATE_STATISTICS_ASYNC option

see

http://www.mssqltips.com/tip.asp?tip=1193

see also

http://msdn.microsoft.com/en-us/library/ms190397.aspx

DBADave (10/16/2008)

---

I'm going to turn it on, but before I do so there is a Trace flag I am trying to find that will log everytime Auto Update runs (I...

even with Gails info it sounds as if rowmodctr value is still in the ballpark so perhaps is the best guide you are going to get.

Else possibly run update stats...

george sibbald (8/4/2008)

---

thanks, you are right, I have a 9.00.3200 (CU4) server and it turns out it is working there.

still leaves the history cleanup task though. maintenance plan history delete...

yes sorry the others are correct, I am guilty of not thinking this through or reading the question properly.

However it does give you another option of sticking with your DTS...

Donna, the answer to that would be no.

When you install your 2005 instance however you can install the 200 dts designer components at the same time and you will be...

if there is ample diskspace I can think of no reason to limit the size of tempdb. IF tempdb fills everything comes to a halt till its cleared so why...

I did this myself recently and tried a number of things to avoid a full restore. all that mucking about has blurred my memory of what I did to get...