SQL Server Tools General
I need to reverse engineer a SQL Server database in that there is an application that sits on top of the database.. I am trying to understand how certain tables in the database are affected by certain events in in the application.. example on the order entry screen, when an order is placed successfully, what relational tables are accessed
Can the SQl Server 2005 Profiler be used to assist with this kind of debugging
Thank you.
yes ...these kind of tracing can be done using profiler. to get clear picture add proper events/filters like database name/id etc
Madhu
Profiler works good.. A new method exists in SQl 2005, in the system view sys.dm_db_index_usage_stats... An example of it's usage would be this query.
select
top 500 db.name, obj.name, * from sys.dm_db_index_usage_stats ius inner join sys.databases db on ius.database_id = db.database_id inner join sys.objects obj on obj.object_id = ius.object_id
This view is refreshed each time SQL Server is restarted... You COULD restart SQL, then moniotr this system view for usage info... or Profiler it... Bruce
.. to addup you can take up help of DMVs in this case, refer to the updated books online about features of DMV in SQL 2005.
Also do not attempt to run PROFILER continuously as it might slow down the performance on SQL 2005 if your server is already stressed for resources.