Viewing 4 posts - 16 through 19 (of 19 total)
Have you got any errors in SQL Server Logs or in System log in OS?
November 16, 2016 at 4:04 am
Hi
I think Management Data Warehouse (MDW) will help you. If you have not much disk space, you can disable query statistics and server activity data collectors (especially query statistics consumes...
November 16, 2016 at 1:55 am
Here is an exhaustive article about your question:
https://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/
Actually you can create XE-session and open live data view when locks or deadlocks appear.
November 16, 2016 at 12:26 am
szejiekoh (10/31/2016)
Hi all,What would be the best practice to "copy/replicate" these jobs over ?
-- doing backup of msdb and frequent restore to the mirrored/replica instance ?
I think that you...
November 15, 2016 at 8:53 am
Viewing 4 posts - 16 through 19 (of 19 total)