SQL Server Performance Forum – Threads Archive
Server response time has exceeded the errorServer response time has exceeded the error threshold I’m keep getting this message from all servers. Is it bad?
what can I do to fix it? thanks Nelson
you need to see the index in the table, because i think your problem is there. Whit the query analizer execute the query with option Ctrl+k (show execution plan) and evaluate if the query are used the index. Good luck and i am sorry for my english. Bye
The Pipo Dba.
What SO, SQL and network do you have?
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
windows 2003 – sql 2000 spk 3 –
Try SP4 on SQL, check KBAhttp://support.microsoft.com/?kbid=897284 fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.