SQL Server Performance Forum – Threads Archive
Monitoring SQL ServerSorry, I’d to know, how can i fix my bottleneck, because i’m having a lot of time outs with my system. forgime my grammar I donÂ´t speak english very well thankÂ´s for you attentions
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm http://www.mindsdoor.net/SQLAdmin/sp_nrInfo.html Madhivanan Failing to plan is Planning to fail
as suggested refer links and in addition
1). Run profiler trace and refer the longest running queries
2). ensure if any bloking issue
3). ensure developers has properly commit/rollback transaction.
4). See if the application is not written poorly.
5). See if any Hardware/Network problem. HTH
Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
Timeout might occur due to blocking on system, so check whether if that is happening by running SP_WHO2 and check for BlkBy columns. Additional reading for you on blocking:
http://support.microsoft.com/kb/263889 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.