Yes, definately the for loop container around your execute sql task. That's the easiest way.

Also, you may consider running the trace as I suggested but also adding in the counters that I referenced earlier in the thread. In addition to those counters, consider...

Your buffer cache hit ratio is a bit on the low side. I would want this to be higher than 95%. This is a cummulative measure from the...

OK. Here's a recap. You have 8 GB of memory in your server. You have your SQL instance configured (max server memory) to use 6 GB. ...

I think your Microsoft guy is full of it. Here's the Microsoft documentation that shows how to use the /3GB switch to set up your SQL Server 2000 instance:

http://support.microsoft.com/kb/274750

Microsoft...

Krasavita (5/5/2009)

---

Microsoft strongly recommends that we NEVER set this switch due to SQL 2000 2GB memory limit. How to see how much memory my server is using?What can I clean...

Krasavita (5/4/2009)

---

Thank you so much for your help, how can I get to boot.ini file ?and get access to 3 GB How can I find out if it works only...

It's up to you...it doesn't hurt anything to leave it, but others that run...

Whoo Hooo!! Glad you got it figured out.

sp_configure 'show advanced options',1

reconfigure

go

Then re-run sp_configure.

Continue thread here: http://www.sqlservercentral.com/Forums/Topic709588-5-1.aspx#bm709715

Either by using Windows Performance monitor (Start>>Control Panel>>Administrative Tools>>Performance) and finding the counters in the drop down

OR

select *

from master..sysperfinfo

where charindex('memory manager',object_name) > 0

Krasavita (5/4/2009)

---

You'll need to set your advanced options for sp_configure to ON for your max server memory values to display. If I sat on is this going damage anything, any...

Use Windows Performance Monitor counters:

SQL Server:Memory Manager>>Target Server Memory

SQL Server:Memory Manager>>Total Server Memory

You'll need to set your advanced options for sp_configure to ON for your max server memory values to display.

Also, what version of SQL Server 2000 are you running?