SQL Server Performance Forum – Threads Archive

Track users for Time out problem

Some of users had ODBC time out problem this morning and I hear the problem still exists. How can I check the users if I don’t want to use Profiler? How can I find out why they get time out? There is restriction for me to run scripts or Profiler against the production. CanadaDBA

---

Did you get this fixed? It’s going to be hard to troubleshoot without any access to production. Don’t you have a DBA who has that access? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

A good guide tohttp://vyaskn.tripod.com/watch_your_timeouts.htm watch the issue and fix it. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

I am the only DBA. [B)] I have access rights but there is restriction for Profiler usage or anything that might impact production’s performance.

CanadaDBA

---

Looks good! Thanks
CanadaDBA

---

Run Profiler on another machine then. I can understand them not wanting you to actually open up Profiler on that server. They do need to give you the sysadmin rights though to run traces. Otherwise, you can’t do your job. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

Instead of using the GUI tool PROFILER why not run system stored procedures for trace.http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm explains the scenario. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>