ignatandrei:
Aveam probleme cu memoria server-ului (un 2005 pe 64 de biti, SP2). Am pus un procexp si iata rezultatele :
Process PID Description Virtual Size Private Bytes Working Set I/O Read Bytes I/O Write Bytes I/O Other Bytes
MsDtsSrvr.exe 1464 5,417,512 K 83,420 K 23,304 K 66,105 1,284 8,964
sqlservr.exe 1684 SQL Server Windows NT - 64 Bit 2,375,360 K 806,604 K 751,440 K 3,846,696,692 686,421,579 889,703,423
SQLAGENT90.EXE 2236 Microsoft SQL Server Agent 551,260 K 32,204 K 12,392 K 240,515 35,604 299,554
Ideea ar fi ca Virtual Size este enorm pentru DTS (ma rog, SSIS). Vreo idee de ce ?
Este SP2 - exista cumva un SP3 ?
Multumesc,
Dupa 3 ore de functionare:
Process PID Description Virtual Size Private Bytes Working Set I/O Read Bytes I/O Write Bytes I/O Other Bytes
MsDtsSrvr.exe 1464 5,413,416 K 79,312 K 1,024 K 69,241 1,732 8,964
sqlservr.exe 1684 SQL Server Windows NT - 64 Bit 2,457,356 K 1,341,028 K 1,232,488 K 14,611,292,831 3,046,151,926 2,009,768,874
SQLAGENT90.EXE 2236 Microsoft SQL Server Agent 553,308 K 33,592 K 10,352 K 301,348 91,171 966,020
Ideea este ca nu stiu cum sa ii spun sa nu isi mai aloce atita memorie de care nu are nevoie ... parerea mea...
Ignat Andrei
http://serviciipeweb.ro/iafblog