1

Our application from a vendor is using SQL Server 2008 R2 as its database on the backend. Although rarely, but sometimes an issue comes up that we think is related to their database (for example a performance issue etc.). We cannot modify their propriety database but want to detect transactions going into that proprietary(vendor) database and react accordingly. Question: How can we achieve the above in their propriety SQL Server database?

UPDATE

I probably did not phrase the above question well. So, I'm writing this update. What I mean is the following: In a similar scenario for another application that uses propriety Oracle database in its backend we use Oracle’s LogMiner utility to detect transactions going into that proprietary(vendor) database and react accordingly.

nam
  • 21,967
  • 37
  • 158
  • 332
  • React? What are you hoping to happen? I would talk to the vendor when there is a performance issue to investigate what's happening. That's what you're paying them for. – JazzmanJim Jun 15 '18 at 17:00

1 Answers1

1

You can't. You can talk to the vendor and see if they'll give you an admin login/password into the database directly, but they aren't likely to want to for fear that you will break something and then blame them for it. Your best bet is to file a bug report with the vendor and pressure them to fix the underlying problem.

Russell Fox
  • 5,273
  • 1
  • 24
  • 28
  • Yup. This is why you pay for support from a vendor. – JazzmanJim Jun 15 '18 at 17:03
  • @RussellFox Russel I probably did not explain my question well. So, I have added an `UPDATE` section now. – nam Jun 15 '18 at 18:31
  • Well, there are 3rd party log readers that might work, but I'm not sure they will with a database that's been locked down by a vendor. SQL and Oracle are different beasts under the covers. You can try Apex: https://www.apexsql.com/sql_tools_log.aspx – Russell Fox Jun 15 '18 at 21:05