The troubleshooting tag has no wiki summary.
3
votes
3answers
103 views
sleeping SPID blocking other transactions
I'm really having trouble tracking down some blocking we are experiencing.
The root blocking SPID's status is 'sleeping', the cmd is 'AWAITING COMMAND', and the sqltext is 'SET TRANSACTION ISOLATION ...
9
votes
3answers
3k views
What can cause a mirroring session to timeout then failover? SQL Server 2005
We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB ...
4
votes
1answer
120 views
Troubleshooting Postgresql spatial query failure. Next steps?
We have a set of spatial queries that are failing and I'm struggling with troubleshooting them. I suspect that we're running into some bug, but I'd like to nail things down a bit better so as to be ...
5
votes
4answers
272 views
How to troubleshoot orm queries interfering with other applications
Well, it's hypothetical scenario but what I'm trying to understand is the path to go from a post-morten log (say, an SQL Server Profiler trace) to identify the code on a ORM situation. To make it not ...
0
votes
0answers
48 views
Enumerate open oracle connections
How can I troubleshoot which processes are keeping connections open?
Background: A QA installation of several software components is generating an ORA-12516 error now and then, and I'm not sure which ...
1
vote
1answer
103 views
Clients timing out with no apparent reason
I have a SQL Server 2005 server that's been running fine most of the time.
Today the users started to get time outs when opening new connections, including myself when I tried to open another tab on ...
