SQL Server Performance Forum – Threads Archive
Monitoring SQL Server
Sorry, 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 attentionshttp://vyaskn.tripod.com/watch_your_timeouts.htm
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
Hi,
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
————————
http://hemantgirisgoswami.blogspot.com
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://www.sql-server-performance.com/blocking.asp
http://www.sql-server-performance.com/sf_block_prevention.asp
KBAhttp://support.microsoft.com/kb/271509
http://support.microsoft.com/kb/263889 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>