MSSQLTips

I have an application using MSSQL server 2005.  While the system is running, I check the task manager and find that it uses 3GB main memory ( the server has 3.5GB ) and Dual core CPU is only 10-15% used in average. 

However, it is very slow response time.  I need some advises to dig out the reason and improve the performance.

Thank you

hi,

Try to Check if any query is block your system. and if so, optimize it. and try to recreate/reorganize the indexes which created along with your tables.

use this command to check the blocking query.

sp_who2 'Active' 

Sivakumar R