It is a standard version and tried to reboot the server, still has this warning.

Thanks. I will ignore this warnning and check after install user database.

In addtion, i query the sys.dm_os_ring_buffers :

TypeIndicatorsProcessIndicatorsSystemAvail Phys Mem, KbAvail VAS, Kb

RESOURCE_MEMPHYSICAL_LOW021276674328455055332

RESOURCE_MEMPHYSICAL_LOW221276677728455057380

the value of IndicatorsSystem is 2, this means Low Physical Memory. But you can see the Avail Physical...

the locked_page_allocations_kb values in sys.dm_os_process_memory is 0

should be fine if you din't take transcation log backup. Becuase FULL/DIFF backup doesn't break log chain.

You missed group by, here is one example:

select EmployeeKey,AVG(SalesAmountQuota) as Amout_Avg

from [dbo].[FactSalesQuota]

[highlight=#ffff11] group by EmployeeKey[/highlight]

You missed group by, here is one example:

select EmployeeKey,AVG(SalesAmountQuota) as Amout_Avg

from [dbo].[FactSalesQuota]

group by EmployeeKey

got it. thanks so much.

yes, from task manager.

Thanks Gail. When i query memory utilization by SQL Server, i found AWE allocated about 2GB, working set only taken 88MB ,is it normal?

Query AWE allocated memory:

select

...

Thanks Perry.

one question about EMPTYFILE paramters:

If i have 4 data files on one filegroup, then i use DBCC SHRINKFILE with emptyfile paramter to empty the first data file, which file these...

DBCC shirinkfile may not move data to other files. you can virtually move the data from the table to a different filegroup by creating a clustered index and placing it...

you may check with you Exchange Admin and make sure setup relay service in Exchange Server.

Thanks Arun.