SQL Server 2K memory usage
Posted on 2008-06-23
Typically when our system is running normal we notice SQL server uses around 200-300 megs of memory on our server. However, whenever our website experiences SQL Server time outs, the memory usage on our server goes up to 1.7 gigs.
How can we find out what is causing the memory usage to spike to those level?