I think this will do the trick

select

type,

sum(virtual_memory_reserved_kb) as [VM Reserved],

sum(virtual_memory_committed_kb) as [VM Committed],

sum(awe_allocated_kb) as [AWE Allocated],

sum(shared_memory_reserved_kb) as [SM Reserved],

sum(shared_memory_committed_kb) as [SM Committed],

sum(multi_pages_kb) as [MultiPage Allocator],

sum(single_pages_kb) as [SinlgePage...

I thought taht was only for Virtual Servers, I normally use Target Server Mem and Total Server mem. But recently have read many conflicting interpretations of the values returned.

What is...

Thanks that worked using the encrypted version in the filter. I thought I had already tried that. I must of got the syntax wrong.

In terms of performance, I'm running on...

Additionally, the PK index is now larger (potentially much larger) because it contains all columns. So if you have queries that only needed the PK key columns, then it now...

My problems occured after the index was built successfully. 2-3 minutes later, during the build all was ok. No blocking etc.

The system is never completely quiet, but it was...

Just the person I wanted to answer this question.....

Yes I forgot about that. PK is written into all NON Clustered index. Another point that makes chosing the right column as...