My company's server is a Windows 2000 machine that has 3G memory and a SQL Server 2000 DBMS. I have a stored procedure that runs slowly. Is there a qucik, easy way to see whether memory is the major performance hit? While the stored procedure is running the mem usage on Task Manager shows about 1.7G. Does that a guarantee that the memory size isn't a problem? Thanks.