April 12, 2005 at 9:50 am
Is there a way to find deadlocks on a server without having Admin rights to the server?. Due to SOX we have no rights to the production server and we have a major deadlock problem.
April 12, 2005 at 11:24 am
I do not think so. Profiler really helps here, but that requires SA access. There is an article on this site about tracing deadlocks.
http://www.sqlservercentral.com/columnists/skumar/tracingdeadlocks.asp
April 12, 2005 at 3:08 pm
This is one of those issues...
When I have clients call me up with problems like this I tell them: If you have SA access I'll spend ten minutes with you for free and help you find or solve the problem, if you don't have SA access, my rate is $500 per hour and I don't know how long it will take me...
April 14, 2005 at 5:44 am
If there is someone you can ask that has 'sa' authority have them set Trace Flag 1204 on? This will right the deadlock information to the SQL Server Error Log and then you can troubleshoot from there...of course only if you have permissions to the error logs!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply