We are using third party (Idera) software for auditing activity on our SQL Servers (2000) and some of the events collected do not contain correct data.
Idera SQL Compliance Manager uses Profiler to generate trace files which it then parses elsewhere. Idera suggests that the problem lies outside of their control as the incorrect data is being recorded by Profiler.
The problem is with hostnames. Some of our Excel and Access queries are old and were built on machines that no longer exist on our domain and the hostnames that Profiler pulls for events generated by the firing of these queries are the old ones, not the proper ones.
Why is profiler pulling these out-of-date hostnames?
What I need to do is somehow identify the culprit queries so that I can fix them and I really don't know how to best approach this problem.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!