Hmmm.....your counters have changed quite a bit since the first post where they were lower. I think running a couple hour perfmon will help tell the tale. To...

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