Friday, January 30, 2009

If sometimes your SQL 2005 server responds slow to your queries....

There can be many reason that cause your SQL server to respond slowly to your queries.(Disk I/O , RAM ,CPU....) If you believe that your hardwares have aduquate values, try stopping SQL 2005 trace process and test your queries again.

exec sp_configure 'show advanced options' , 1
reconfigure
exec sp_configure 'default trace enabled', 0
reconfigure

No comments:

Post a Comment

 
span.fullpost {display:inline;}