November 30, 2011 at 10:19 am
I'm supporting an Application that's having a problem. At specified times, it dumps data out to a set of tables, and that data dump is failing occasionally. All of the SQL code is contained within the Application, and I have no access to it. All I can see is the database -- which is basically just tables.
So... my question is: Assuming an "Update" statement in the Application is failing, is there some place in SQL I can see that error? Is it only passed back to the Application or is it also recorded somewhere? Would I see it in Profiler? Or is there a better way?
Thanks in advance!
November 30, 2011 at 10:37 am
It has to run as SQL in the database engine eventually so yes I would run profiler which will show exactly what was run and can also trap errors.
As it only happens ocassionaly run profiler as a server side trace so when it happens you know you will have caught it.
If it only fails occasionally a frequent cause of that is timeouts or data related problems
---------------------------------------------------------------------
November 30, 2011 at 12:11 pm
Do you have deadlock reporting in SQLServer errorlog enabled ?
This can be accomplished using startup trace flags
-T1204
-T3605
and so you don't need to restart you instance you can enable it for the current instance using:
dbcc traceon(1204, 3605, -1)
This may already give you an idea if your system is having conflict areas
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 1, 2011 at 11:56 am
Keep in mind that "failure" could very easily be just bad selection info being sent in the dynamicSQL. Meaning the process or query might not "fail" - it just might be passing criteria that don't pick up the data needed.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply