HI,
I'm working in DWH environment Every day many data gets extracted transformed & loaded But from last week i see that there are taking more time then previously executed.
I don't have a option to run SQL profiler on production.
Does Trace ON 1222 will impact on performance on production if enabled.
so what should i check for them & what need to check for improving performance of these servers?
i check fragmentation, Disk Space, Error Logs daily wat more need to check the improve the performance of server on DWH environment
Thanks In Advance