It doesn't happen regular, and some measurements are taken to upgrade the server so it's not an acute problem. But i'm really curious.

If an ratio is, lets say 90%, after...

I also want to thank everyone. I learned a lot.

@Shawn, after rereading the topic is understand you are thinking my server was the same server as Jasons. Sorry, i should...

I'm confused. Is the 384MB not part of the "Total Server Memory" counter?

I could't resolve this from the KB.

But if it is not a part of Total Server Memory then...

Yes, there are performance issues. I think the real issue is a high avg physical queue length (average of about 10 per disk). They are working on that. But also,...

The mistake most people make is that they think wife 1.0 and wife 2.0 are utilities, but in fact it's a complete OS that controls all of your resources.

You only...

Then I would really like to know, why does one server stick at 1,61 and the other at 1,8? Can I do something about it? Anyone?

I had installed sql server 2000 and mySQL 3.51 on my development PC. It worked fine. I agree with David, don't use this in production, they all want all of...

Even standard edition can use 2GB. Why does it stick at 1.61?

-is it a dedicated server?

-did you accidentally manually specified SQL Server's RAM?

This has no bearing on my answer. ALL objects are created on only 1 server. The DTS package is scheduled and runs about 30 seconds (connecting to about 25 servers)....

I'm using the following script to check backup's (execute sql task in a dts). Maybe you can use it as an example:

Declare serverdbcursor cursor read_only for

select server_name, database_name

from...

1. Microsoft says op page msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_4azp.asp: "While the goal is for SQL Server 2000 to always recognize that the statements generate essentially the same plan and reuse the plans, SQL...

@jacob

I'm referring to other books.

But I'm curious. Does the book say that ad-hoc sql-statements are also compiled.

@rcnelsonmba

You are comparing a select in a SP with no views to an ad-hoc select wich has views. That's comparing appels and pears (dutch saying). If you had...

In my experience over 90% of the people I talk about SP's think that they are pre-compiled on creating and ad-hoc SQL-plans can't be reused (sometimes even writers of books)....

To my knowlegde SP's are not compiled, or am i mistaken about the following piece of BOL:

SQL Server 2000 and SQL Server version 7.0 incorporate a number of changes to...