April 14, 2010 at 1:19 pm
I have an alert that I've set up to tell me when our user errors/sec rises above 150. I initially did this to learn whether there was any correlation between user errors in SQL Server and problems reported to me by our end users. I've not seen an obvious relationship here so far. However, I also haven't found something else just as valuable: a way to find out what these errors are. I've done numerous google searches only to repeatedly find the same high level information with no details about what causes the errors. I find it hard to believe the answer is not out there. I figure I have to be searching on the wrong terms... or something... anything! :blink: And so I asked myself, "Self, why don't you ask SSC?" And my self thought that was a good idea. So, does anybody have any insight into how to find out the cause and/or source generating my user errors? I realize I may not be able to get the actual error message. But, if there's a way to find out the application, server, or user associated with them that would go a long way.
Thanks!
Mia
April 14, 2010 at 1:32 pm
In general if I come across an application error that does not generate anything on the Window Server logs or SQL Server logs I look to server side traces or GUI Profiler if I'm in a hurry.
I realize I may not be able to get the actual error message. But, if there's a way to find out the application, server, or user associated with them that would go a long way.
This would depend on if the application is a client or web application. Most client apps I have worked with generate a log of themselves, or at most write to the local Windows Event Log. If it is a web application that is a COTS app there has got to be some type of logging or debugging mode that can be turned on. If there is not I would go back to the vendor and ask them why the heck not:hehe:.
Having the user capture screenshots of the errors is a good way to document for vendor support as well. If you can provide what type of application it is and the error the users are experiencing might help you get more detailed help
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 14, 2010 at 1:42 pm
Thanks! I'll try that.
Now, the funny part... as soon as I hit post I got this "crazy" idea to check profiler. Of course, as soon as I did I found an event for (yes, that's right) user error messages. The trace of error messages is a beautiful site. It's like watching the matrix flow flowing down on my screen. 😀
-mia
April 14, 2010 at 2:40 pm
Mia G (4/14/2010)
... as soon as I hit post I got this "crazy" idea to check profiler. Of course, as soon as I did I found an event for (yes, that's right) user error messages. The trace of error messages is a beautiful site. It's like watching the matrix flow flowing down on my screen. 😀
so... is the new IPR(*) feature of this forum fantastic or what? 😀
(*) Immediate Paranormal Reply
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.April 14, 2010 at 2:44 pm
Incredibly Fantastic! 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply