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
Friday, January 30, 2009
If sometimes your SQL 2005 server responds slow to your queries....
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment