The debugging tag has no wiki summary.
1
vote
0answers
26 views
Is there an effective way to create extended event data that includes stacktraces in SQL Server on a local db instance?
I read Paul Randal's article on getting the symbols for SQL Server. I have a theory that I could get the extended events to read the symbols from the symbol server catch directory by setting the ...
1
vote
1answer
73 views
Is it possible in Oracle to trace SQL statements that result in errors?
We have Oracle 11g in production. Application system is still under active development. It will be very handy to get SQL statements which cause any error.
Does Oracle provide a standard function to ...
1
vote
0answers
137 views
MySQL: Writing log entries from stored procedure
Is there a standard way to write log messages in MySQL stored procedures?
I can write log messages to a designated log table, but I prefer the standard log mechanism where each message is coupled ...
1
vote
1answer
45 views
debugging an ssis package which is invoked from a .net application?
can we attach a debugger to an SSIS package which is invoked to execute from a .net assembly?
3
votes
2answers
3k views
How to debug deadlocks in SQL Server 2008 R2?
I'm using SQL Server 2008 R2 that automatically lock database items based on my queries.
Sometimes this deadlocks - two threads with different queries never ends.
Is there any way to debug how SQL ...
2
votes
1answer
112 views
Getting conversion error, for value that doesnt exist in database [closed]
I am running this query:
SELECT
thirdpid
, ea.Empid
, ea.Empname
, em.RsCode
, em.CustomerName AS 'RS Name'
, SUM(CASE WHEN ea.Present=1 THEN 1 ELSE 0 END) AS 'Present days'
...
1
vote
1answer
433 views
High MySQL CPU usage, queries seem fine, not running ntp
I've had about 48 hours of extremely high CPU usage on my main MySQL database for no apparent reason.
I realize this question is quite similar to the one posed here: High CPU usage from MySQL with no ...
1
vote
1answer
312 views
Why I cannot let EXPLAIN update statements?
I can imagine that it's actually more important to explain SELECT statements, but I wonder why there's no possibility to use EXPLAIN on UPDATEs/INSERTs. I may use a WHERE-statement in an UPDATE where ...
0
votes
0answers
79 views
Debugging\Profiling CONTEXT_INFO
i have a problem with CONTEXT_INFO in SQL Server 2008.
My problem is identical to this question: Why is my CONTEXT_INFO() empty?
We use CONTEXT_INFO to store the application user in it and the use ...
4
votes
1answer
408 views
How do I find out *why* a user has certain effective permissions?
I know that I can query effective permissions by using sys.fn_my_permissions:
USE myDatabase;
SELECT * FROM fn_my_permissions('dbo.myTable', 'OBJECT')
entity_name | subentity_name | ...
1
vote
1answer
955 views
strategy for enabling a general query log on MySQL 5.0.95 with no restart?
I would like to configure a general query log for a busy MySQL 5.0.95 production server without effecting the availability.
Obviously I can set the "log" option in the my.cnf file and restart the ...
1
vote
1answer
1k views
Why are breakpoints not being hit in SQL Server Management Studio?
SQL Server Management Studio allows debugging of SQL (breakpoints and stepping through the SQL). It is possible to step in to a stored proc being called and to see a call stack. However I cannot ...
2
votes
1answer
189 views
Has anyone ran into this replication breaking bug before?
I've been having this issue where replication was breaking on colliding primary keys. The annoying thing was these were auto increment generated.
I think my issues been tracked down to ...
4
votes
1answer
954 views
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...
