Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Не хватает памяти  [new]
memory_limit
Guest
Отругался в логке

Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576

Правильно я понимая, что 32-битный сервер не может использовать больше 1728784 KB памяти? И чтобы он все же использовал большем памяти, нужно включить AWE?

+

2013-08-09 20:36:16.45 spid57
Memory Manager KB
---------------------------------------- ----------
VM Reserved 1728784
VM Committed 1721192
AWE Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0
2013-08-09 20:36:16.45 spid57
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 1725968
VM Committed 1718488
AWE Allocated 0
MultiPage Allocator 48272
SinglePage Allocator 22528
2013-08-09 20:36:16.45 spid57
Memory node Id = 32 KB
---------------------------------------- ----------
VM Reserved 1728
VM Committed 1672
AWE Allocated 0
MultiPage Allocator 1600
SinglePage Allocator 22528
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1440
MultiPage Allocator 7544
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 1658304
VM Committed 1658304
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 504
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 104
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 192
MultiPage Allocator 72
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- ----------
VM Reserved 432
VM Committed 432
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 168
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- ----------
VM Reserved 1920
VM Committed 1920
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2256
MultiPage Allocator 32160
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 488
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 128
MultiPage Allocator 344
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SNI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 72
MultiPage Allocator 16
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SNI (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 16
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SNI (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 72
MultiPage Allocator 32
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 24
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_BHF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 120
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLQERESERVATIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 28888
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 4224
VM Committed 4224
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_HOST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1088
MultiPage Allocator 960
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 5384
MultiPage Allocator 6024
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SOSNODE (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 1520
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 5400
MultiPage Allocator 7544
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 96
SM Committed 96
SinglePage Allocator 0
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 32
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
MEMORYCLERK_XE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 64
MultiPage Allocator 96
2013-08-09 20:36:16.46 spid57
CACHESTORE_OBJCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_SQLCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1240
MultiPage Allocator 200
2013-08-09 20:36:16.46 spid57
CACHESTORE_PHDR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_XPROC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_NOTIF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 8
2013-08-09 20:36:16.46 spid57
CACHESTORE_STACKFRAMES (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 8
2013-08-09 20:36:16.46 spid57
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 16
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 40
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 32
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 112
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 32
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 32
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 4888
MultiPage Allocator 144
2013-08-09 20:36:16.46 spid57
USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 496
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1152
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_OBJPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 600
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_SXC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 112
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_SXC (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
USERSTORE_SXC (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 120
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 64
MultiPage Allocator 0
2013-08-09 20:36:16.46 spid57
OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 488
MultiPage Allocator 56
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_SNI_PACKET (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 56
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 488
MultiPage Allocator 112
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 400
MultiPage Allocator 0
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 4096
VM Committed 4096
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1032
MultiPage Allocator 0
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_LOCK_MANAGER (node 32) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 24
MultiPage Allocator 0
2013-08-09 20:36:16.47 spid57
OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- ----------
VM Reserved 4096
VM Committed 4096
AWE Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1056
MultiPage Allocator 0
2013-08-09 20:36:16.48 spid57
Buffer Pool Value
---------------------------------------- ----------
Committed 204760
Target 204760
Database 92719
Dirty 21324
In IO 0
Latched 1
Free 109114
Stolen 2927
Reserved 3500
Visible 204760
Stolen Potential 188095
Limiting Factor 11
Last OOM Factor 0
Page Life Expectancy 192
2013-08-09 20:36:16.48 spid57
Process/System Counts Value
---------------------------------------- ----------
Available Physical Memory 1674711040
Available Virtual Memory 13864960
Available Paging File 6344970240
Working Set 2023677952
Percent of Committed Memory in WS 100
Page Faults 608565
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 1
2013-08-09 20:36:16.48 spid57
Procedure Cache Value
---------------------------------------- ----------
TotalProcs 1
TotalPages 184
InUsePages 133
2013-08-09 20:36:16.48 spid57
Global Memory Objects Pages
---------------------------------------- ----------
Resource 201
Locks 132
XDES 46
SETLS 4
SE Dataset Allocators 8
SubpDesc Allocators 4
SE SchemaManager 344
SE Column Metadata Cache 284
SQLCache 40
Replication 2
ServerGlobal 26
XP Global 2
SortTables 3674
2013-08-09 20:36:16.48 spid57
Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 1
Waiting 0
Available 142552
Current Max 146163
Future Max 146163
Physical Max 146163
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
2013-08-09 20:36:16.48 spid57
Small Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 7692
Current Max 7692
Future Max 7692
2013-08-09 20:36:16.48 spid57
Optimization Queue (internal) Value
---------------------------------------- ----------
Overall Memory 1344528384
Target Memory 1283022848
Last Notification 1
Timeout 6
Early Termination Factor 5
2013-08-09 20:36:16.48 spid57
Small Gateway (internal) Value
---------------------------------------- ----------
Configured Units 16
Available Units 16
Acquires 0
Waiters 0
Threshold Factor 250000
Threshold 250000
2013-08-09 20:36:16.48 spid57
Medium Gateway (internal) Value
---------------------------------------- ----------
Configured Units 4
Available Units 4
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
2013-08-09 20:36:16.48 spid57
Big Gateway (internal) Value
---------------------------------------- ----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
2013-08-09 20:36:16.48 spid57
Memory Pool Manager Pages
---------------------------------------- ----------
Reserved Current 3611
Reserved Limit 191706
2013-08-09 20:36:16.48 spid57
Memory Pool (internal) Pages
---------------------------------------- ----------
Allocations 6427
Predicted 39356
Private Target 0
Private Limit 0
Total Target 194522
Total Limit 194522
OOM Count 0
2013-08-09 20:36:16.48 spid57
MEMORYBROKER_FOR_CACHE (internal) Pages
---------------------------------------- ----------
Allocations 1363
Rate -36
Target Allocations 156529
Future Allocations 0
Overall 164127
Last Notification 1
2013-08-09 20:36:16.48 spid57
MEMORYBROKER_FOR_STEAL (internal) Pages
---------------------------------------- ----------
Allocations 1453
Rate -15
Target Allocations 156619
Future Allocations 0
Overall 164127
Last Notification 1
2013-08-09 20:36:16.48 spid57
MEMORYBROKER_FOR_RESERVE (internal) Pages
---------------------------------------- ----------
Allocations 3611
Rate 0
Target Allocations 164127
Future Allocations 36540
Overall 164127
Last Notification 1
12 авг 13, 12:43    [14695997]     Ответить | Цитировать Сообщить модератору
 Re: Не хватает памяти  [new]
fwefewfewfew
Guest
memory_limit
Правильно я понимая, что 32-битный сервер не может использовать больше 1728784 KB памяти? И чтобы он все же использовал большем памяти, нужно включить AWE?


ПроцессОСVASMax PhysicalMemoryAWE/Locked
32x322Gb64GbAWE
32x32+/3gB3Gb32GbAWE
32x644GbG4GbAWE
64x648Tb1TbLocked Pages
64IA647Tb1TbLocked Pages


Вам или /3Gb выставить или AWE.
12 авг 13, 13:41    [14696499]     Ответить | Цитировать Сообщить модератору
 Re: Не хватает памяти  [new]
fwefwe
Guest
fwefewfewfew,

Память доступная через AWE Window SQL Server использует только для DataCache... может быть для сетевых буферов, но я не уверен на счет последнего...
12 авг 13, 13:43    [14696516]     Ответить | Цитировать Сообщить модератору
 Re: Не хватает памяти  [new]
memory_limit
Guest
А какому пользователю давать права Lock Pages in Memory, если MSSQL запущен из под Local System?

http://msdn.microsoft.com/en-us/library/ms190730.aspx
12 авг 13, 14:14    [14696792]     Ответить | Цитировать Сообщить модератору
 Re: Не хватает памяти  [new]
memory_limit
Guest
memory_limit
А какому пользователю давать права Lock Pages in Memory, если MSSQL запущен из под Local System?

http://msdn.microsoft.com/en-us/library/ms190730.aspx


Я так понял после этой статьи, что это право уже дано Local System.

http://blogs.msdn.com/b/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx
12 авг 13, 14:46    [14697041]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить