Ce versiune de SQL Server? Ce versiune de OS? Cita memorie fizica? Cit de mare e pagefile?
Daca e SQL 2005 ar fi interesant de vazut care clerk consuma memoria:
select top(10) single_pages_kb+multi_pages_kb as total_pages_kb, *
from sys.dm_os_memory_clerks
order by total_pages_kb desc
Numai de bine,
~ Remus
http://rusanu.com