Monitoring SQL Server | SQL Server Performance Forums

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 attentions 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:
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.