Bom dia, alguém poderia me ajudar a avaliar o dbcc memorystatus?
Buffer Distribution Buffers
------------------------------ -----------
Stolen 16173
Free 42303
Procedures 64992
Inram 0
Dirty 249353
Kept 0
I/O 0
Latched 612
Other 2527687
(9 row(s) affected)
Buffer Counts Buffers
------------------------------ -----------
Commited 2901120
Target 2901120
Hashed 2777591
InternalReservation 1940
ExternalReservation 9467
Min Free 528
Visible 124000
(7 row(s) affected)
Procedure Cache Value
------------------------------ -----------
TotalProcs 8931
TotalPages 64992
InUsePages 15178
(3 row(s) affected)
Dynamic Memory Manager Buffers
------------------------------ -----------
Stolen 78566
OS Reserved 3312
OS Committed 3290
OS In Use 2667
General 5132
QueryPlan 66555
Optimizer 4254
Utilities 49
Connection 1992
(9 row(s) affected)
Global Memory Objects Buffers
------------------------------ -----------
Resource 2449
Locks 1893
XDES 168
SQLCache 1043
Replication 2
LockBytes 2
ServerGlobal 23
(7 row(s) affected)
Query Memory Objects Value
------------------------------ -----------
Grants 8
Waiting 0
Available (Buffers) 54291
Maximum (Buffers) 66419
(4 row(s) affected)
Optimization Queue Value
------------------------------ -----------
Optimizing 1
Waiting 0
Available 31
Maximum 32
(4 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Obrigado.
Vinicius Fonseca. MCTS - Sql Server 2005 / ITIL Classifique as respostas.
