SQLTeam.com | Weblogs | Forums

Tool or Utility for Recreating SQL Server Activity

sql2012

#1

Hello,

Does anyone know if there is a tool, utility or some built in functionality to recreate or "replay" server activity from the logs so that you could go back to a point in time and identify something that executed just before system degradation or a failure took place? Perhaps something complimentary to Solar Winds in which you could review activity over a specific time period (like replaying a trace, but not necessarily that gui...)

Thanks in advance for any information!

HK


#2

You can use Microsoft performance monitoring and tuning tools, you can also use the SQL Server Profiler by the using of this tool you can create and manage traces, analyze and replay trace results.

For performance monitoring and tuning tools: https://msdn.microsoft.com/en-us/library/ms179428.aspx
For profiler you need to follow this link: https://msdn.microsoft.com/en-us/library/ms181091.aspx