bibi92

<div>
Adding profiling to a production instance could reduce performance, so if performance is already poor it may get worse.<br>Just a cautionary note, nothing more. e.g. You may ned to warn users, or, at least, the help desk.<br><br>Also consider that patterns of use often change (e.g. end-of-month activity) so when, and how long, you profile needs consideration.
</div>


President / Owner CARDA Consultants Inc.

Daniel Pineault

<div>
Alternatively you could use the Data Collection and/or Activity monitor to debug performance issues on that particular server as detailed here:&nbsp;<a href="https://solutioncenter.apexsql.com/monitor-sql-server-queries-find-poor-performers-activity-monitor-and-data-collection/" rel="ugc">https://solutioncenter.apexsql.com/monitor-sql-server-queries-find-poor-performers-activity-monitor-and-data-collection/</a>&nbsp;
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hello,<br>Following performance issues, how is possible to capture sql server 2014 users activity one day and replay it on tests instance ?<br><br>Thank you<br><br>Best regards <br><br>
</div>
</div>



Hello,
Following performance issues, how is possible to capture sql server 2014 users activity one day and replay it on tests instance ?
Thank you
Best regards

capture sql server users activity

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.