object_name counter_nameinstance_namecntr_valuecntr_type

SQLServer:Memory Manager Target Server Memory (KB) ...

x86

we are adding 4G RAM now. I have 2 instanses that I don't need, how can I remove them?

I know max 2147483647 MB, for each instanse, how much should I cut down too?

What is the configuration of the development server (total server memory, disk drives (raid type or not, etc)? How are the instances configured (min/max memory, etc)?

How can I check...

Server memory: Min 0, max:2147483647 MB, 1 processor

Is each instance contains their own RAM?

How can I see in sql server all instanses?

This is what I have from your code,but it is not showing instanse name:

object_name ...

Thank you

Thank you, I fixed it, someone were running along a query and I reboot server and it fixed it

I am looking for documentation, what do I need to have on 9 instanses, not to have performance issues. Right now we are using all of them and it is...

With 9 instances, unless you have a server with a lot of processors and cores and memory and a substantial disk IO system behind it, you can expect to have...

This is new maintance plan and I copied code from 2000,but I am using in 2005

Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)

[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.

this is what I get

2005