Viewing 15 posts - 1,441 through 1,455 (of 3,232 total)
Yes, definately the for loop container around your execute sql task. That's the easiest way.
May 6, 2009 at 12:05 pm
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...
May 6, 2009 at 11:46 am
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...
May 6, 2009 at 11:43 am
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. ...
May 5, 2009 at 1:54 pm
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...
May 5, 2009 at 9:50 am
Krasavita (5/5/2009)
May 5, 2009 at 8:39 am
Krasavita (5/4/2009)
May 5, 2009 at 8:34 am
Krasavita (5/4/2009)
Also, should I change it back to sp_configure to 0. or I can leave it?
It's up to you...it doesn't hurt anything to leave it, but others that run...
May 4, 2009 at 3:14 pm
Whoo Hooo!! Glad you got it figured out.
May 4, 2009 at 3:06 pm
sp_configure 'show advanced options',1
reconfigure
go
Then re-run sp_configure.
May 4, 2009 at 2:23 pm
Continue thread here: http://www.sqlservercentral.com/Forums/Topic709588-5-1.aspx#bm709715
May 4, 2009 at 2:22 pm
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
May 4, 2009 at 2:21 pm
Krasavita (5/4/2009)
May 4, 2009 at 2:09 pm
Use Windows Performance Monitor counters:
SQL Server:Memory Manager>>Target Server Memory
SQL Server:Memory Manager>>Total Server Memory
May 4, 2009 at 2:01 pm
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?
May 4, 2009 at 1:59 pm
Viewing 15 posts - 1,441 through 1,455 (of 3,232 total)