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

Откуда:
Сообщений: 5
Основная база 16 гиг, в настройках сервера поставил мин объем памяти 16000 Мб, максимальный 32000. Реально сервер занимает полгига, свободной памяти больше 20 гиг
Вот итоги memorystatus
+

Process/System Counts Value
---------------------------------------- --------------------
Available Physical Memory 31096168448
Available Virtual Memory 8744880902144
Available Paging File 97110552576
Working Set 507465728
Percent of Committed Memory in WS 100
Page Faults 267188
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0

(10 row(s) affected)

Memory Manager KB
---------------------------------------- -----------
VM Reserved 49091868
VM Committed 387736
Locked Pages Allocated 15305068
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 32768008
Current Committed 15692808
Pages Allocated 14513696
Pages Reserved 0
Pages Free 533880
Pages In Use 4726992
Page Alloc Potential 26402608
NUMA Growth Phase 0
Last OOM Factor 0
Last OS Error 0

(16 row(s) affected)

Memory node Id = 0 KB
---------------------------------------- -----------
VM Reserved 49032652
VM Committed 386160
Locked Pages Allocated 5467332
Pages Allocated 5102200
Pages Free 284656
Target Committed 16383992
Current Committed 5853496
Foreign Committed 0
Away Committed 0
Taken Away Committed 0

(10 row(s) affected)

Memory node Id = 1 KB
---------------------------------------- -----------
VM Reserved 59152
VM Committed 1556
Locked Pages Allocated 9837736
Pages Allocated 9411504
Pages Free 249216
Target Committed 16383992
Current Committed 9839296
Foreign Committed 0
Away Committed 0
Taken Away Committed 0

(10 row(s) affected)

Memory node Id = 64 KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 20
Locked Pages Allocated 0

(3 row(s) affected)

MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16184

(6 row(s) affected)

MEMORYCLERK_SQLGENERAL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 136

(6 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16320

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 6547476
VM Committed 131072
Locked Pages Allocated 252068
SM Reserved 0
SM Committed 0
Pages Allocated 3199944

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 7238136

(6 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total) KB
---------------------------------------- -----------
VM Reserved 6547476
VM Committed 131072
Locked Pages Allocated 252068
SM Reserved 0
SM Committed 0
Pages Allocated 10438080

(6 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 15592

(6 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2632

(6 row(s) affected)

MEMORYCLERK_QUERYDISKSTORE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 312

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 88

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 104

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- -----------
VM Reserved 1856
VM Committed 1856
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8856

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 13120

(6 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total) KB
---------------------------------------- -----------
VM Reserved 1856
VM Committed 1856
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 21976

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1264

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 488

(6 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1752

(6 row(s) affected)

MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- -----------
VM Reserved 9450880
VM Committed 10724
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 63704

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 448

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 464

(6 row(s) affected)

MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

MEMORYCLERK_SNI (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40

(6 row(s) affected)

MEMORYCLERK_SNI (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

MEMORYCLERK_SNI (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_SNI (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80

(6 row(s) affected)

MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 296

(6 row(s) affected)

MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_BHF (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 392

(6 row(s) affected)

MEMORYCLERK_BHF (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 320

(6 row(s) affected)

MEMORYCLERK_BHF (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 712

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- -----------
VM Reserved 3072
VM Committed 3072
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (node 1) KB
---------------------------------------- -----------
VM Reserved 1536
VM Committed 1536
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_XE_BUFFER (Total) KB
---------------------------------------- -----------
VM Reserved 4608
VM Committed 4608
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_HOST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 46792

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24800

(6 row(s) affected)

MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2608

(6 row(s) affected)

MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 74200

(6 row(s) affected)

MEMORYCLERK_SOSOS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192

(6 row(s) affected)

MEMORYCLERK_SOSMEMMANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 109720
VM Committed 104152
Locked Pages Allocated 5424
SM Reserved 0
SM Committed 0
Pages Allocated 0

(6 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 208

(6 row(s) affected)

MEMORYCLERK_FILETABLE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

MEMORYCLERK_XE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 6912

(6 row(s) affected)

MEMORYCLERK_SPATIAL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

MEMORYCLERK_SQLLOGPOOL (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4304

(6 row(s) affected)

MEMORYCLERK_LWC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192

(6 row(s) affected)

MEMORYCLERK_FSCHUNKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48

(6 row(s) affected)

CACHESTORE_OBJCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5160

(6 row(s) affected)

CACHESTORE_SQLCP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3668768

(6 row(s) affected)

CACHESTORE_PHDR (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5032

(6 row(s) affected)

CACHESTORE_XPROC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 48

(6 row(s) affected)

CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 288

(6 row(s) affected)

CACHESTORE_NOTIF (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_STACKFRAMES (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

CACHESTORE_BROKERTBLACS (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_BROKERTBLACS (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40

(6 row(s) affected)

CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

CACHESTORE_EVENTS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
----------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4120

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4536

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5600

(6 row(s) affected)

CACHESTORE_SYSTEMROWSET (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10136

(6 row(s) affected)

CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_CONVPRI (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_CONVPRI (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32

(6 row(s) affected)

CACHESTORE_SEARCHPROPERTYLIST (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
----------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192

(6 row(s) affected)

CACHESTORE_XML_SELECTIVE_DG (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 120592

(6 row(s) affected)

USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 19256

(6 row(s) affected)

USERSTORE_DBMETADATA (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 7440

(6 row(s) affected)

USERSTORE_DBMETADATA (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 26696

(6 row(s) affected)

USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 536

(6 row(s) affected)

USERSTORE_TOKENPERM (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 240

(6 row(s) affected)

USERSTORE_TOKENPERM (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 776

(6 row(s) affected)

USERSTORE_OBJPERM (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1000

(6 row(s) affected)

USERSTORE_OBJPERM (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 600

(6 row(s) affected)

USERSTORE_OBJPERM (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1600

(6 row(s) affected)

USERSTORE_SXC (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 208

(6 row(s) affected)

USERSTORE_SXC (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160

(6 row(s) affected)

USERSTORE_SXC (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8

(6 row(s) affected)

USERSTORE_SXC (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 376

(6 row(s) affected)

USERSTORE_QDSSTMT (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 64

(6 row(s) affected)

USERSTORE_QDSSTMT (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

USERSTORE_QDSSTMT (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80

(6 row(s) affected)

OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1152

(6 row(s) affected)

OBJECTSTORE_LBSS (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1280

(6 row(s) affected)

OBJECTSTORE_LBSS (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2432

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1344

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1928

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56

(6 row(s) affected)

OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3328

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 384

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 160

(6 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 544

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- -----------
VM Reserved 131076
VM Committed 131076
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 5336

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 4848

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24

(6 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- -----------
VM Reserved 131076
VM Committed 131076
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 10208

(6 row(s) affected)

OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
------------------------------------------ -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

OBJECTSTORE_XACT_CACHE (node 0) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 992

(6 row(s) affected)

OBJECTSTORE_XACT_CACHE (node 1) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 904

(6 row(s) affected)

OBJECTSTORE_XACT_CACHE (node 64) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16

(6 row(s) affected)

OBJECTSTORE_XACT_CACHE (Total) KB
---------------------------------------- -----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1912

(6 row(s) affected)

Buffer Pool Value
---------------------------------------- -----------
Database 1303969
Simulated 0
Target 8175616
Dirty 55614
In IO 0
Latched 0
Page Life Expectancy 76759

(7 row(s) affected)

Procedure Cache Value
---------------------------------------- -----------
TotalProcs 23782
TotalPages 459881
InUsePages 212

(3 row(s) affected)

Global Memory Objects Pages
---------------------------------------- -----------
Resource 413
Locks 1276
XDES 307
DirtyPageTracking 24
SETLS 24
SubpDesc Allocators 24
SE SchemaManager 6070
SE Column Metadata Cache 9003
SE Column Metadata Cache Store 114
SQLCache 11556
Replication 2
ServerGlobal 52
XP Global 2
SortTables 3

(14 row(s) affected)

Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 2971504
Current Max 2971504
Future Max 2971504
Physical Max 2971504
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0

(11 row(s) affected)

Small Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 106496
Current Max 106496
Future Max 106496

(5 row(s) affected)

Remote Query Memory Objects (internal) Value
---------------------------------------- -----------
Grants 0
Waiting 0
Available 1485752
Current Max 1485752

(4 row(s) affected)

Optimization Queue (internal) Value
---------------------------------------- --------------------
Overall Memory 26895974400
Target Memory 21165219840
Last Notification 1
Timeout 6
Early Termination Factor 5

(5 row(s) affected)

Small Gateway (internal) Value
---------------------------------------- -----------
Configured Units 96
Available Units 96
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000

(6 row(s) affected)

Medium Gateway (internal) Value
---------------------------------------- -----------
Configured Units 24
Available Units 24
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1

(6 row(s) affected)

Big Gateway (internal) Value
---------------------------------------- -----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1

(6 row(s) affected)

Memory Pool Manager KB
---------------------------------------- -----------
Reserved Current 0
Reserved Limit 26407672

(2 row(s) affected)

Memory Pool (internal) KB
---------------------------------------- -----------
Allocations 4721928
Predicted 10666240
Private Target 0
Private Limit 0
Total Target 31129600
Total Limit 31129600
OOM Count 0

(7 row(s) affected)

MEMORYBROKER_FOR_CACHE (internal) KB
---------------------------------------- -----------
Allocations 3870896
Rate 1304
Target Allocations 24335560
Future Allocations 0
Overall 26265600
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_STEAL (internal) KB
---------------------------------------- -----------
Allocations 205800
Rate -72
Target Allocations 20669160
Future Allocations 0
Overall 26265600
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_RESERVE (internal) KB
---------------------------------------- -----------
Allocations 0
Rate -864
Target Allocations 26265600
Future Allocations 5943008
Overall 26265600
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_COMMITTED (internal) KB
---------------------------------------- -----------
Allocations 645232
Rate 0
Target Allocations 21108592
Future Allocations 0
Overall 26265600
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_HASHED_DATA_PAGES (internal) KB
--------------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 20463360
Future Allocations 0
Overall 26265600
Last Notification 1

(6 row(s) affected)

MEMORYBROKER_FOR_XTP (internal) KB
---------------------------------------- -----------
Allocations 0
Rate 0
Target Allocations 20463360
Future Allocations 0
Overall 26265600
Last Notification 1

(6 row(s) affected)

Memory Broker Clerk (Buffer Pool) Pages
---------------------------------------- ----------------------
Total 1303969
Simulated 0
Simulation Benefit 0
Internal Benefit 0
External Benefit 0
Value Of Memory 0
Periodic Freed 0
Internal Freed 0



Некоторые запросы соответственно тормозят. Не могу понять, что надо изменить, чтобы сервер использовал больше памяти.
6 июл 17, 09:53    [20617866]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
aleks2
Guest
Не пробовали работать с базой? Т.е. запросы ей фсякие слать...
6 июл 17, 10:15    [20617933]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
AlexPi
Member

Откуда:
Сообщений: 5
aleks2, с базой уже 2-е суток работают 60 пользователей, создаются бекапы. Ну что ему еще надо?))
6 июл 17, 10:19    [20617950]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
aleks2
Guest
SELECT  
(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,  
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,  
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,  
process_physical_memory_low,  
process_virtual_memory_low  
FROM sys.dm_os_process_memory;  
6 июл 17, 10:36    [20618001]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
AlexPi
Member

Откуда:
Сообщений: 5
aleks2,
Memory_usedby_Sqlserver_MB Locked_pages_used_Sqlserver_MB Total_VAS_in_MB process_physical_memory_low process_virtual_memory_low
-------------------------- ------------------------------ -------------------- --------------------------- --------------------------
15504 15019 8388607 0 0
6 июл 17, 10:37    [20618008]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
aleks2
Guest
AlexPi
aleks2,
Memory_usedby_Sqlserver_MB Locked_pages_used_Sqlserver_MB Total_VAS_in_MB process_physical_memory_low process_virtual_memory_low
-------------------------- ------------------------------ -------------------- --------------------------- --------------------------
15504 15019 8388607 0 0


Ну и чо вы катите бочку на MS SQL?


15504 Мб = 15 Гб
6 июл 17, 10:39    [20618025]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
TaPaK
Member

Откуда: Kiev
Сообщений: 6794
AlexPi,

автор
. Реально сервер занимает полгига,
это вы в диспечере посмотрели, что-ли?
6 июл 17, 10:40    [20618028]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
AlexPi
Member

Откуда:
Сообщений: 5
TaPaK, да. Походу лоханулсяю Подскажите, где в итогах memorystatus смотреть верную инфу?
6 июл 17, 10:45    [20618047]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
TaPaK
Member

Откуда: Kiev
Сообщений: 6794
AlexPi,

ну алекс же дал короткий вариант мониторинга. а так
Available Physical Memory 31096168448
Current Committed 15692808
6 июл 17, 10:52    [20618090]     Ответить | Цитировать Сообщить модератору
 Re: SQL server 2014 sp2 использует мало памяти  [new]
AlexPi
Member

Откуда:
Сообщений: 5
TaPaK, aleks2, Спасибо за помощь
6 июл 17, 10:57    [20618111]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить