Viewing 15 posts - 1 through 15 (of 109 total)
It is a standard version and tried to reboot the server, still has this warning.
August 18, 2014 at 2:48 am
Thanks. I will ignore this warnning and check after install user database.
August 18, 2014 at 2:48 am
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...
August 18, 2014 at 1:26 am
the locked_page_allocations_kb values in sys.dm_os_process_memory is 0
August 18, 2014 at 1:19 am
should be fine if you din't take transcation log backup. Becuase FULL/DIFF backup doesn't break log chain.
December 30, 2013 at 12:12 am
You missed group by, here is one example:
select EmployeeKey,AVG(SalesAmountQuota) as Amout_Avg
from [dbo].[FactSalesQuota]
[highlight=#ffff11] group by EmployeeKey[/highlight]
May 23, 2013 at 9:49 pm
You missed group by, here is one example:
select EmployeeKey,AVG(SalesAmountQuota) as Amout_Avg
from [dbo].[FactSalesQuota]
group by EmployeeKey
May 23, 2013 at 9:49 pm
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
...
February 27, 2013 at 1:07 am
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...
October 21, 2012 at 10:01 pm
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...
October 19, 2012 at 5:22 pm
you may check with you Exchange Admin and make sure setup relay service in Exchange Server.
October 19, 2012 at 5:13 pm
Viewing 15 posts - 1 through 15 (of 109 total)