sql server – server side traces

https://msdn.microsoft.com/en-us/library/cc293613.aspx start trace – stop trace, then script out file –> export –> script set InsertFileNameHere and run on server retrieve data from — SELECT * FROM fn_trace_gettable(‘c:inside_sql.trc’, 1) stop trace and don’t continue — EXEC sp_trace_setstatus 2, 2

Error: Cannot use file for clustered server

http://www.sysads.co.uk/2013/12/error-file-clustered-server/ Expand Services and applications, click on your clustered application (in my case is the default SQL Server (MSSQLSERVER)), right-click the SQL Server resource, and then click Properties Click the Insert button to add an additional row, then select the new shared disk that will…