I saw the "Target Memory" and "Total Memory" parameters on Windows Perfmon.

"Target Memory" is the total amount of dynamic memory the server is willing to consume.

and

"Total Memory" is Total amount...

All my databaseas are small.

If Sql Server doesn't need to use any more memory, why threadshold Target Memory is bigger than Total Memory?

Regards and Thanks

Felipe

I have 3GB RAM on my server.

I'm using Sql Server Enterprise Edition

Sql Server is only using 900MB.

Windows 2000 server.

Thanks

Felipe

My problem is because, my max memory is 3Gb, on Total Memory i have

900Mb and on Target Server i have 1500Gb. But on threadshol Memory Available (Mb) i have...

Your are right!!

Thanks very much!

Michele.

This works.

Thanks very much!!

When i execute the folow query on Query Analyzer:

select * from sysdatabases

I HAVE THIS ERROR:

(2 row(s) affected)

Server: Msg 220, Level 16, State 1, Line 1

Arithmetic overflow error for data type...

Yes, i have permission. Because i have the sa pass!

Allen,

        the result was:

Thanks...This resolved my problem.

Regards,

Felipe Venancio