I have inherited a database from the previous DBA. He was also a .NET programmer, and there are a dozen other programmers who have come and gone. All of whom did varying levels of documenting their code. My issue has to do with being asked to determine all the consumers for a certain database/table. “What applications are using the data in this table or that table” I have tried profiler, and been very displeased with the results, if this is my only recourse, so be it. However, if there is some other way I can capture the users/operations being performed on a given table, please let me know.
by Ari Weil
Quest’s Performance Analysis for SQL Server product is going to be the simplest, most complete way for you to not only see the data you’re looking for, but also to:
- Determine the impact these programs are having on your database environment
- Analyze a baseline of each programs’ unique footprint to understand its execution profile
- Receive context-sensitive performance advisories pointing out problematic processes / statements / configurations
- Review an unlimited history of execution activity
- Dive into a dimensional analysis of the most significant data to drive a focused, concise tuning process
There are other ways to get the data you want, of course. You could create a table, or set of tables to hold user, program, context_info, client user, client machine, and sql handle information, and create a SQL agent job to periodically query the database environment to dump the observed values into the table(s). You can then report on that data using custom queries, Crystal Reports, or Analysis Services.
Share this post with friends
