I am using NI Teststand; this tool provides a schema to implement on a relational DB, and I have implemented it on SQL Server.
Every so often the DB inserts are taking a long time to complete.
Unfortunately, this tool calls a DLL to perform the updates. So I can't directly see what queries are running.
1) Is there a transaction log where I can see the queries?
2) Is there a log where I can see the time each query took to run?
3) Is there a tool that would help me identify what was slow? (I suspect FK lookups)
I am not a DB guru, but if I can prove this solution is viable, I might be able to hire one. ;)