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.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.